https://issues.apache.org/bugzilla/show_bug.cgi?id=46944
Summary: Error Value can only be 0,7,15,23,29,36 or 42. It
cannot be -30
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I get the following exception when trying to refresh all formulas on an excel
sheet. I've attached an excel sheet and a java file that produce the error.
java.lang.RuntimeException: Error Value can only be 0,7,15,23,29,36 or 42. It
cannot be -30
at
org.apache.poi.hssf.record.BoolErrRecord.setValue(BoolErrRecord.java:101)
at
org.apache.poi.hssf.usermodel.HSSFCell.setCellErrorValue(HSSFCell.java:750)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.setCellValue(HSSFFormulaEvaluator.java:222)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateInCell(HSSFFormulaEvaluator.java:194)
at
com.tech_innovapr.poi.examples.UpdateFormulas.refreshWorkbookFormulas(UpdateFormulas.java:67)
at
com.tech_innovapr.poi.examples.UpdateFormulas.main(UpdateFormulas.java:25)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
