https://bz.apache.org/bugzilla/show_bug.cgi?id=61468
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- OS| |All --- Comment #1 from [email protected] --- UPD: the cell is E9 (not E5 as stated above). The formula which is incorrectly evaluated is `=TotalMonthlyIncome`. The following code snippet produces different results in 3.15 and 3.17: InputStream input = Main.class.getClassLoader().getResourceAsStream("simple-monthly-budget.xlsx"); Workbook workbook = WorkbookFactory.create(input); Cell cell = workbook.getSheetAt(0).getRow(8).getCell(4); System.out.println("E9 numeric value (before evaluating formula): " + cell.getNumericCellValue()); FormulaEvaluator formulaEvaluator = workbook.getCreationHelper().createFormulaEvaluator(); formulaEvaluator.evaluateInCell(cell); System.out.println("E9 numeric value (after evaluating formula): " + cell.getNumericCellValue()); In 3.15: E9 numeric value (before evaluating formula): 3750.0 E9 numeric value (after evaluating formula): 3750.0 In 3.17: E9 numeric value (before evaluating formula): 3750.0 E9 numeric value (after evaluating formula): 3500.0 -- 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]
