PHPExcel generated excel file not auto-calculating formula

Question

Issue

Our web application generates Excel spreadsheets using the PHPExcel library. Normally we are able to open the Excel file, select 'Enable Editing', and then it auto-calculates the formulas on the sheet. However this month (April 2018), I've been getting reports that the sheet no longer calculates automatically.

I need to find a solution on how to get these sheets to automatically calculate again upon opening the file.

Answer 1

By recalculating on the server side, it might be somewhat better even if it won't be a solution.

$writer     = PHPExcel_IOFactory::createWriter($excel, self::EXCEL_TYPE);
$writer->setPreCalculateFormulas();
$writer->save($tempfile);

I hope this helps you.