Re: Problem with formula

[Danny Mui]

It would be most helpful if you can enter this into bugzilla, with a 
junit testcase.

thanks
Andrew Kharchuk wrote:
When I'm trying to set the following formula value
"IF(ISBLANK(C2);0;IF(ISBLANK(L5);0;L5*C2)" I get an Exception. What is
wrong?
java.lang.RuntimeException: Cannot Parse, sorry : Integer Expected
 at org.apache.poi.hssf.model.FormulaParser.Abort(FormulaParser.java:117)
 at org.apache.poi.hssf.model.FormulaParser.Expected(FormulaParser.java:124)
 at org.apache.poi.hssf.model.FormulaParser.GetNum(FormulaParser.java:239)
 at org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:479)
 at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
 at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:596)
 at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:453)
 at org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:315)
 at org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:265)
 at org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:474)
 at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
 at
org.apache.poi.hssf.model.FormulaParser.Expression(FormulaParser.java:596)
 at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
 at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:678)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]