When used the method setForceFormulaRecalculation() on a XSSFSheet, the following error is thrown: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTSheetCalcPr at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTWorksheetImpl.addNewSheetCalcPr(Unknown Source) at org.apache.poi.xssf.usermodel.XSSFSheet.setForceFormulaRecalculation(XSSFSheet.java:1557) I look in to "poi-ooxml-schemas-3.8-beta4....jar" and the class is missing.
Short term, just switch to the full schemas file (ooxml-schemas-1.1) Longer term, any chance you could write a short unit test that uses the recalculation flag? We use the unit tests to decide which bits of the schema to copy over
This seems to be fixed in https://issues.apache.org/bugzilla/show_bug.cgi?id=51785 Please try with the latest build from trunk. Daily builds can be downloaded from here: http://encore.torchbox.com/poi-cvs-build/ *** This bug has been marked as a duplicate of bug 51785 ***