If you create an excel file with automatic formula recalculation and get a workbook from it, workbook.getForceFormulaRecalculation() returns true while sheet.getForceFormulaRecalculation() returns false on every sheet, while it should return true as well.
Created attachment 35600 [details] JUnit test class. Add JUnit test class.
Can you provide test.xlsx as well? Your test cases do not work without it.
Created attachment 35603 [details] Excel empty file test.xlsx is an excel file created anew with Microsoft Excel. I attach it here for convenience.
This is not how the flags on Workbook and Sheet are intended. They both are just flags which indicate to Excel or any other application that formulas should be re-calculated. These flag are available on sheet- or workbook-level, but they are not related to each other in the binary format. So Apache POI just populates the binary file with these flags as appropriate and there is no handling to "synchronize" those two in any way. Excel then decides based on the set flags, which sheets it will recalculate. Adjusted the javadoc via r1875804 somewhat and added tests that verify the current behavior, but as far as I see we should not change anything here.