https://issues.apache.org/bugzilla/show_bug.cgi?id=46944
--- Comment #2 from criver...@gmail.com 2009-03-31 13:23:04 PST --- (In reply to comment #0) > 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) Ok I found that this doesn't happen when I use the FormulaEvaluator.evaluateFormulaCell which should be the method used for refreshing the sheet formulas instead of the one I was using(FormulaEvaluator.evaluateInCell). But I think the above error should be checked out anyways. -- 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: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
