Using Aspose Cells for Java, version 19.11.9.
Workbook workbook = new Workbook("input.xlsx"); workbook.calculateFormula(); workbook.getSettings().setCalcMode(CalcModeType.MANUAL); workbook.getSettings().setReCalculateOnOpen(false); workbook.save("output.xlsx");
Opening the resulting workbook will show cell
IT Concentration!E11 evaluating to
However, recalculating the workbook using Excel results in a valid value for the cell. We’ve verified this using both Excel 2010 as well as Excel 365.
The input and output files are attached.