poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58746] New: Formula: changed sheet name after re-order
Date Thu, 17 Dec 2015 09:51:19 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58746

            Bug ID: 58746
           Summary: Formula: changed sheet name after re-order
           Product: POI
           Version: 3.13-FINAL
          Hardware: PC
                OS: All
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: michele.bissoli.83@gmail.com

Hi all,
when I create a xls that contains a cell formula that refers to other cells in
others sheets AND after I re-order the sheet with this formula, the cell
doesn't contain the correct formula: POI has changed the sheet names into the
formula!

Example code:

HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet first = workbook.createSheet("first");
first.createRow(0).createCell(0).setCellValue(1);
HSSFSheet second = workbook.createSheet("second");
second.createRow(0).createCell(0).setCellValue(2);
HSSFSheet third = workbook.createSheet("third");
HSSFRow row = third.createRow(0);
row.createCell(0).setCellFormula("first!A1");
row.createCell(1).setCellFormula("second!A1");
// re-order for sheet "third"
workbook.setSheetOrder("third", 0);

What I obtain into the sheet "third":
- A1: "=second!A1" > it must be "=first!A1"!!
- B1: "=first!A1" > it must be "=second!A1"!!

Could you please correct this bug as soon as possible? This is very important
for the work i'm doing.

This bug is the same of 57474 but here I provide a simple code for reproduce
the problem.

Thanks very much,
Michele

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message