On Fri, 1 Feb 2008, Vishwa Kumba wrote:
HSSFFormulaEvaluator.evaluateInCell() method seems to calculate
numerical formulae and populate the result into the Cell but not string
formula. I seem to be getting a ClassCastException.
Try using HSSFFormulaEvaluator.evaluateFormulaCell from trunk (or 3.0.2
final when released), that will calculate the value of the formula and
save it into the cell along with the formula
http://poi.apache.org/hssf/eval.html#EvaluateFormulaCell
Otherwise, if you are still getting an exception from
HSSFFormulaEvaluator, please open a new bug on bugzilla, upload the
problem file, and let us know which cell triggers it
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
