#2 3 errors with formulas

closed-fixed
nobody
None
5
2007-02-14
2005-11-18
No

Run this code:

from pyExcelerator import *

w = Workbook()
ws = w.add_sheet('F')

try:
ws.write(15, 0, Formula('5>=3'))
except Exception, e:
print e

ws.write(16, 0, Formula('5>3'))
ws.write(17, 0, 5)
ws.write(17, 1, 7)
ws.write(18, 0, Formula('AND(A17>3;B17>5)'))

w.save('formulas.xls')

It illustrates 3 problems
15) greater-than-or-equal raises an exception
16) the greater-than has become a greater-than-or-equal
when opened under Excel 2003
18) the formula should be valid, but Excel reports "A
value used in the formula is of the wrong type"

Discussion

  • Glenn Washburn

    Glenn Washburn - 2007-02-14
    • status: open --> closed-fixed
     
  • Glenn Washburn

    Glenn Washburn - 2007-02-14

    Logged In: YES
    user_id=798633
    Originator: NO

    Fixed a bug in the lexer and parser for bug one and two respectively. The third bug I believe arises because ws.write(row, col, val) actually writes to row+1 when viewed in excel. So in the above example A17 is a formula cell, and there's nothing in B17.

     

Log in to post a comment.