Is the formula evaluation code in the scratchpad supposed to work?
I tried to evaluate a formula in a cell, but it gets the following
exception:
java.lang.NullPointerException
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSF
FormulaEvaluator.java:293)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaE
valuator.java:192)
I loaded up the source (using 3.0rc2), and it shows this is happening on
the following line:
int srcRowNum = srcRow.getRowNum();
Because "srcRow" is null. The calling method sends the "row" instance
variable, which obviously isn't set.
Am I supposed to call "evaluator.setCurrentRow(row)" before I call the
evaluator on a cell in that row? The documentation I found for the
evaluator doesn't mention this. If I'm supposed to do this, is there
something else I need to call for the evaluator to work?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
