https://bz.apache.org/bugzilla/show_bug.cgi?id=61841
Travis Burtrum <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |admin.apache@moparisthebest | |.com --- Comment #12 from Travis Burtrum <[email protected]> --- Created attachment 36497 --> https://bz.apache.org/bugzilla/attachment.cgi?id=36497&action=edit PoiFormulaChecker class demonstrating problem Here is a minimal testcase showing the bug which seems to only affect XSSF. when ran with HSSFWorkbook this is printed: evaluatedCell: org.apache.poi.ss.usermodel.CellValue [39.57] impl: HSSFWorkbook, maxRow: 4, elapsed: 209ms, 0s, 0min when ran with XSSFWorkbook: evaluatedCell: org.apache.poi.ss.usermodel.CellValue [#N/A] impl: XSSFWorkbook, maxRow: 4, elapsed: 248ms, 0s, 0min or with my patch to throw the exception instead of return null: Exception in thread "main" java.lang.RuntimeException: XSSFBUG: would shortcircuit wrongly: rowIndex: 2, _lastDefinedRow: 1 at org.apache.poi.xssf.usermodel.XSSFEvaluationSheet.getCell(XSSFEvaluationSheet.java:71) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:139) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:534) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:275) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:216) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:56) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluate(BaseFormulaEvaluator.java:110) at PoiFormulaChecker.main(PoiFormulaChecker.java:47) -- 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]
