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.dela...@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-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
