On Tue, 6 May 2008, Andy Chien wrote: > As subject. How would I get the text formula string from the > FormulaRecord?
See lines 146 to 166 of src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java from svn trunk, or 3.1 beta 1. That should hopefully show you how to get both the evaluated answer of a formula, and the string the defines it. > Secondly, is there a way of setting the formula for a cell without it > getting parsed? Not in OLE2 excel. The formula is only ever stored in the file in its parser form, so we have to process the ptgs to get back the string. In OOXML excel, the formula is stored as a string, so it's much simpler Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
