Bug 61864 - Workbook.setForceFormulaRecalculation not working as expected
Summary: Workbook.setForceFormulaRecalculation not working as expected
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on: 61700
Blocks:
  Show dependency tree
 
Reported: 2017-12-06 11:54 UTC by Luca
Modified: 2017-12-27 21:29 UTC (History)
0 users



Attachments
JUnit test class. (2.61 KB, text/plain)
2017-12-11 08:50 UTC, Luca
Details
Excel empty file (8.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-12-11 14:26 UTC, Luca
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Luca 2017-12-06 11:54:26 UTC
Workbook.setForceFormulaRecalculation always sets ForceFormulaRecalculation at false. Create and excel file, open a workbook on it and run the followng lines:

System.out.println(wb.getForceFormulaRecalculation());
wb.setForceFormulaRecalculation(true);
System.out.println(wb.getForceFormulaRecalculation());
wb.setForceFormulaRecalculation(false);
System.out.println(wb.getForceFormulaRecalculation()); 

First output will depend on file settings, other two outputs will be both false.
Comment 1 Luca 2017-12-11 08:50:39 UTC
Created attachment 35601 [details]
JUnit test class.

Add JUnit test class.
Comment 2 Luca 2017-12-11 14:26:00 UTC
Created attachment 35604 [details]
Excel empty file

test.xlsx is an excel file created anew with Microsoft Excel. I attach it here for convenience.