Using 3.0rc2, the formula evaluator failed on a particular cell, with
the stacktrace following this. Before I file an issue for this, is this
expected to fail this way? Is there any workaround I can implement?
Error: Integer Expected
java.lang.RuntimeException: Cannot Parse, sorry : Integer Expected @ 28
[Formula String was:
'IF(D37=0,0,IF(AND(ISNUMBER(#REF!),ISNUMBER(D37)),#REF!/D37*100,0))']
at
org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser.java:114)
at
org.apache.poi.hssf.model.FormulaParser.Expected(FormulaParser.java:121)
at
org.apache.poi.hssf.model.FormulaParser.GetNum(FormulaParser.java:255)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:512)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:606)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:65
4)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:469
)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:341)
at
org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:280)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:505)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:606)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:65
4)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:469
)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:341)
at
org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:280)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:505)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:606)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:65
4)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:469
)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:341)
at
org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:280)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:505)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:606)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:65
4)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:479
)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:341)
at
org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:280)
at
org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:505)
at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:606)
at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:65
4)
at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:758)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSF
FormulaEvaluator.java:296)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaE
valuator.java:192)
---------------------------------------------------------------------
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/
