How to deal with memory explosion in PhpSpreadsheet or when writing in a cell that has not changed

Aug 24, 2020 PHP

When error occurs due to # writeCellFormula, Cell, Coordinate relationship

Apparently, PhpSpreadsheet solves the formula and saves the file. However, it seems that if you write a complicated expression, it will become an infinite loop, it will not be able to calculate well and it will fall. Even if it works well on Excel.

At that time (for XlsxWriter)

$writer->setPreCalculateFormulas(false);

It seems that you can skip the pre-calculation process by adding.

https://phpspreadsheet.readthedocs.io/en/latest/topics/reading-and-writing-to-file/ I found this while reading here.

I hope that it will be for the comrades who got hooked up in the same way next time.