Wrong result with formulas including $-sign using evaluator.evaluate(cell)?

[Rudolf Schmidt]

Hi,

evaluator.evaluate(cell) gives me wrong results, if it evaluates
cellformulas, that have $-signs in it or refer to cells which have formulas
with $, e.g. "C$12 * a3". Removing the $ helps, but is not always possible.

Any suggestions?

Snippet:
HSSFFormulaEvaluator evaluator = new HSSFFormulaEvaluator(sheet, wb);
evaluator.setCurrentRow(row);
HSSFFormulaEvaluator.CellValue cellValue = evaluator.evaluate(cell);
return cellValue.getNumberValue();

Regards, Rudolf


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]