https://bz.apache.org/bugzilla/show_bug.cgi?id=64517
Bug ID: 64517 Summary: The formula in the cell cannot be modified correctly Product: POI Version: 4.1.1-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: HSSF Assignee: dev@poi.apache.org Reporter: 253684...@qq.com Target Milestone: --- Created attachment 37304 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37304&action=edit The file used to reproduce the bug When I use HSSFCell#setCellFormula to modify the formula in a cell, if I just adjust some cells in the formula, e.g.for AVERAGE(A1:F1) to AVERAGE(A2:F1), HSSFCell#setCellFormula will be wrong modify the row of the second cell to the row of the first cell, but the first cell will not be modified! before fixing: AVERAGE(A1:F1) Expected value: AVERAGE(A2:F1) Actual value: AVERAGE(A1:F2) Below is the test code to reproduce this problem: public static void main(String[] args) throws IOException { Workbook workbook = WorkbookFactory.create(new File("E:\\Average.xls")); Row row = workbook.getSheetAt(0).getRow(0); Cell cell = row.getCell(6); System.out.println("formula before modify:" + cell.getCellFormula()); cell.setCellFormula("B2:F1"); System.out.println("formula after modify:" + cell.getCellFormula()); } The Average.xls in the attached file. -- 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