Having issues with the most recent release, output doesn't automatically calculate formulas

[allredbm]

The issue I'm having is twofold. I'm using PHP 8.0.3 and, while I don't know which version of PHPSpreadsheet I'm using, it's only a month or two out of date.

The first issue is basically exactly like the issue described here: #456. I have a basic PHP program that instantiates a reader, uses it to read an existing .xlsx file and create a Spreadsheet, instantiates a writer, and uses the Spreadsheet to output a copy of the original. The original spreadsheet has formulas that are designed to automatically calculate when certain other fields are filled, as per usual excel formula behavior. The problem is that the outputted copy does not automatically calculate these formulas like the original does. I saw that the issue above addressed the issue and pushed a solution into the codebase, but that solution doesn't seem to be helping here. I also tried the solution mentioned in this comment (#456 (comment)), but that also did not help as the solution seems to be out of date with how PHPSpreadsheet works now.

The other issue is that, after attempting to update PHPSpreadsheet with Composer in pursuit of a solution to the above problem, I found that my program no longer functions. It outputs a copy of the original spreadsheet, but opening it returns the error "We found a problem with some content" and trying to recover it shows that the first sheet is wiped totally blank.

Is anyone else seeing any of these issues lately? Have any solutions be found?

[oleibman]

Please upload a copy of the spreadsheet where you see this problem.

[allredbm]

Yes, the experience I'm having is different. In my case, after creating the copy, those cells in 6-54 don't refresh automatically.

Can you elaborate on the process you're using in PHP to create the copy? Maybe I'm doing something wrong.

require '../../vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Reader\Xlsx as Reader;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx as Writer;

$fileLocation = [path to file];

ini_set('max_execution_time', 60);

$reader = new Reader();
$spreadsheet = $reader->load($fileLocation );

$writer = new Writer($spreadsheet);
$fileName = "CABLE DOC COPY.xlsx";
$writer->save($fileName);

[oleibman]

I tried your sample code. Had to comment out the ini_set statement. Got the expected results. Used PHP7.4, PhpSpreadsheet 19, Windows 10 (OS probably doesn't matter) to generate the output file, Excel 365 Enterprise to examine the results.

[allredbm]

CADDS CABLE DOC - APP3445 (2).xlsx

This is pretty frustrating. Here's an example of what I'm getting from the same process. If you look at 6-54, you'll see that B2-B5 isn't even calculating the formula, it just presents the formula as a literal string. The rest all precalculate as expected, but all of the cells do not automatically recalculate the formula when the cells they're looking at change.

Also, the version of PHPSpreadsheet I'm using is 1.18

[oleibman]

I fear this will frustrate you even more. I changed E6 and H6 on the first sheet of the file which you just uploaded; as you can see from the screenshot which I hope I will be able to post correctly, they are immediately reflected in B2 on the second sheet (I did auto-size the row-heights on the second sheet before entering anything on the first).

Perhaps the problem occurs only with a specific version of Excel. As I mentioned, mine is Excel 365 (Microsoft 365 apps for enterprise), Version 2107 Build 14228.20324.

[allredbm]

Perhaps it is a version issue. At any rate, it seems like we've hit bottom as far as investigating this. Thanks for helping me diagnose this anyway.