Hi ,
Im getting below error when trying to update a Excel sheet containing
formulas.
Im using poi-3.1-FINAL-20080629.jar
and office 2002.Can any one please help out.Im struck with this issue from
the past 2 weeks.
cell formula:IF(E43,+E43/B43,0)
The value in the formula cells are: before 0.0
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateCell(HSSFFormulaEvaluator.java:386)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:338)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:183)
at
qualityreport.QualityReportMain.updatePercCells(QualityReportMain.java:458)
at
qualityreport.QualityReportMain.updateFormula(QualityReportMain.java:333)
at qualityreport.QualityReportMain.main(QualityReportMain.java:484)
java.lang.ClassCastException:
org.apache.poi.hssf.record.formula.eval.Ref2DEval
at
org.apache.poi.hssf.record.formula.functions.If.evaluate(If.java:40)
at
org.apache.poi.hssf.record.formula.eval.FuncVarEval.evaluate(FuncVarEval.java:43)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.invokeOperation(HSSFFormulaEvaluator.java:473)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateCell(HSSFFormulaEvaluator.java:386)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.internalEvaluate(HSSFFormulaEvaluator.java:338)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:183)
at
qualityreport.QualityReportMain.updatePercCells(QualityReportMain.java:458)
at
qualityreport.QualityReportMain.updateFormula(QualityReportMain.java:333)
at qualityreport.QualityReportMain.main(QualityReportMain.java:484)
Thanks in Advance
Sc
--
View this message in context:
http://www.nabble.com/java.lang.ClassCastException%3A-org.apache.poi.hssf.record.formula.eval.Ref2DEval-tp18339828p18339828.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
