You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/01/31 11:33:29 UTC
[Bug 54509] New: Cells in shifting rows are not used in
column-referencing formulas.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54509
Bug ID: 54509
Summary: Cells in shifting rows are not used in
column-referencing formulas.
Product: POI
Version: 3.9
Hardware: PC
OS: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: sylvain.delafoy@gmail.com
Classification: Unclassified
Created attachment 29910
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29910&action=edit
maven projet with an input file and a sample main method.
When shifting rows in an HSSFSheet, formulas such as "=sum(C[1])" do not use
new cells' values.
You need to open the resulting file in excel and edit (F2) the cell in order
for the formula to use the cell's value.
Sample file and code in the attachment.
--
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
[Bug 54509] Cells in shifting rows are not used in
column-referencing formulas.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54509
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
I tried this with latest POI and it did work fine, seems some of the related
fixes since POI 3.9 has fixed this as well.
--
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
[Bug 54509] Cells in shifting rows are not used in
column-referencing formulas.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54509
--- Comment #2 from Sylvain Delafoy <sy...@gmail.com> ---
Looks like the difference comes from the software used to open the file. I
checked my example this morning with Excel 2010 and the latest libreoffice and
both showed 10. Unfortunately, I don't have access to the computer where I
noticed this problem to check excel's version.
However, if I add
System.out.println(new HSSFWorkbook(new
FileInputStream("out.xls")).getSheetAt(0).getRow(0).getCell(0).getNumericCellValue());
and use POI version 3.10.1 or 3.11-beta2 at the end of the test, the output is
7.
However, I wonder if it's a POI bug or not.
PS: My apologies to clean code, there is obviously a lot of stream closing to
be done. If this bug is reopened, I volunteer for writing a clean unit test.
--
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
[Bug 54509] Cells in shifting rows are not used in
column-referencing formulas.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54509
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |---
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
reopen to investigate some more
--
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