- status: open --> closed-fixed
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"
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.