PhpExcel icon indicating copy to clipboard operation
PhpExcel copied to clipboard

calculate cell formulas by default

Open arteq opened this issue 7 years ago • 0 comments

The 'setPreCalculateFormulas(true)' is needed to save the file with calculated forumulas. Without it if you have cell with formula ex. '=A1+A2' or `=SUM(A1:A2)' the result will be always zero until you reenter/recalculate the cell value once opened in Excel. Took me some time to figure this out, I belive it's the desired behavior for 99% developers who use any kind of formulas in generated spreadsheet so I'd make turned on by default.

arteq avatar Feb 12 '18 17:02 arteq