I have attached my latest patches to bugzilla that adds the ability to do floats. All existing tests pass .. i will write up new tests for floats soon .. promise :)
I have added a new NumberPtg.java, modelled on the existing records and Ptg. Tell me if its messed up somehow. (My knowledge of HSSF internals can only go up at the moment :) I have also changed one line in the areareference code in FormulaParser to go better with the style of the rest of the class. hope you dont mind. Andy, a couple of questions for you... 1. Can we remove the toFormulaString(Ptg[] operands) method, and keep only the String[] ones? To do a recursive evalutation of an RPN ptg array, you need the String one. i cant find an use case for the ptg[] method. 2. Can we remove the getStringLength method? i dont understand where it is used. Thanks - Avik PS. having added the cell ref and area ref code to the parser, i hope you agree that its simple :)
