Hi,
I am building a web application using POI-3.5-FINAL-20090928.jar.
When I am calculating a sum in a cell wtih this code:
--------------------
Cell cell = risksheet.getRow(60).getCell(k);
evalA.evaluateFormulaCell(cell);
evalA.clearAllCachedResultValues();
val = risksheet.getRow(60).getCell(k).getNumericCellValue();
--------------------
I am receiving the following error:
java.lang.IllegalStateException: Cannot get a numeric value from a error
formula cell
org.apache.poi.hssf.usermodel.HSSFCell.typeMismatch(HSSFCell.java:616)
org.apache.poi.hssf.usermodel.HSSFCell.checkFormulaCachedValueType(HSSFCell.java:621)
org.apache.poi.hssf.usermodel.HSSFCell.getNumericCellValue(HSSFCell.java:646)
The formula in that cell is
=SUM(E46:E54)+SUM(E56:E57)+SUM(E59:E60)
I need some help please, maybe someone more experienced can suggest me
what am I doing wrong.
Thanks,
Adrian
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
