https://bz.apache.org/bugzilla/show_bug.cgi?id=63845
Bug ID: 63845
Summary: Forumla not evaluated in 4.1.0
Product: POI
Version: 4.1.0-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: jo...@muehlencord.de
Target Milestone: ---
Created attachment 36826
--> https://bz.apache.org/bugzilla/attachment.cgi?id=36826&action=edit
file created using 4.1.0, cell formulas are not calculated when opening the
file
Cell formulas are not evaluated when created with 4.1.0
E.g. cell.setCellFormula("SUM(A3:A5)"); opens as "0" when opening the excel
file. Same source code compiled with 4.0.1 works and shows correct value when
opening.
If editing the formula (F2) sheet and Enter w/o any change, the formula will be
updated to the correct value. Trying to force call formula calculation from
menu does not help to update the cell value.
Same error / same behavior occurs when copying existing cells to new cells.
In the attached example cell A11 is the cell.setCellFormlua mentioned above.
Column D is copied from column A using the FormulaParser for the formula cells.
As mentioned, the same code works for 4.0.1 but is broken in 4.1.0
--
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
