poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew Kharchuk" <...@ukraina.com>
Subject Problem with formula
Date Thu, 04 Nov 2004 11:37:52 GMT

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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message