Issues on EC2 Server running PHP 8.1

[sverdon]

Been using PHPSpreadsheet for a while now and recently migrated our website to an AWS EC2 instance running PHP 8.1 (previously 7.4).

I'm now running into issues using the same functions I had been using previously on the new server. For example, this is some code that works without problem on the old server, but on the new the server times out every time (loading an Excel template, changing some values, then writing to a new file):

// Load Template
$template = 'template.xlsx';
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($template);

// Update Values
$spreadsheet->getSheetByName('sheet1')->setCellValue('AJ1', $some_value);

// Write Values to another sheet
$spreadsheet->getSheetByName('sheet2')->fromArray($values_array, NULL, 'A2');

// Save file
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, "Xlsx");
$writer->save('test.xlsx);

Any idea why this may be failing in a new environment? My thought was that it must be the upgrade to 8.1, but I don't see any reason that the core functions should change. This is the error I get:

PHP Fatal error: Maximum execution time of 120 seconds exceeded in /srv/www/wordpress/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/Coordinate.php on line 414

One thing to note is that I have verified that everything is installed and working properly, since I can run the 'Hello World' example in the documentation without issue.

Thoughts?

[sverdon]

It appears its just an issue with the particular .xlsx template I'm using. I'm able to edit and save other files just fine.

This particular file is protected by a password-- I'm assuming that's why it's having trouble writing and saving it? In the past I was able to write to protected files without issue though, so I'm not sure why I'm having issues now.

[sverdon]

Turned out to be an issue with a specific column that contained a complex formula while loading in the file. Was able to tweak the formula and managed to load the file succesfully-- albeit taking 30+ sec.

Not sure if there's a solution built into PHPSpreadSheet for ignoring columns like that when loading in the template in order to speed things up.