[Bug 64517] New: The formula in the cell cannot be modified correctly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64517] New: The formula in the cell cannot be modified correctly

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]