#11 Formulas cannot handle boolean operations

[John S. Kirchwood]

Boolean functions don't work properly, and using them mangles the formula. The generated spreadsheet appears with "#VALUE?" written in the cell; clicking on the formula and clicking off it in Excel returns a proper result.

Also, the formula itself is a bit messed up in the spreadsheet. For example:

<test>

from pyExcelerator import *

w = Workbook()
ws = w.add_sheet('xyz')
ws.write(4, 4, Formula('IF(AND(A1<A3;A1>A2);3;5)'))
w.save('abc.xls')

</test>

This code will result in Excel interpreting the formula as "=IF(AND(A1<A3,A1>=A2),3,5" (note the ">=" where ">" was specified in the original).