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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
