https://issues.apache.org/bugzilla/show_bug.cgi?id=53950
Priority: P2
Bug ID: 53950
Assignee: [email protected]
Summary: setForceFormulaRecalculation does not force formula
recalcuation in xlsx documents created with Excel 2010
Severity: normal
Classification: Unclassified
Reporter: [email protected]
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
Created attachment 29430
--> https://issues.apache.org/bugzilla/attachment.cgi?id=29430&action=edit
xlsx document for reproducing issue
The attached xlsx document has been created with Excel 2010. Using the
following code to force formula recalculation does not work, i.e. when the
document is opened the formula value is not updated:
Workbook wb = WorkbookFactory.create(new File("recalc2.xlsx"));
wb.getSheet("Sheet1").setForceFormulaRecalculation(true);
wb.write(new FileOutputStream("out.xlsx"));
setForceFormulaRecalculation seems to work ok with xlsx documents created in
Excel 2007.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
