oleibman

When I correct the statement "$sheet = $excel->getActiveSheet()" to "$sheet = $spreadsheet->getActiveSheet()", the sheet saves correctly. Do you still see a problem if you make that change?

When I used a different formula `=SOMEERORRORFUNCTION(`, omitting the ending parenthesis, I do get an Exception. When I suppress the throw/trigger, the spreadsheet is generated. However, Excel complains when it...

See PR #3081. I have met you at least part way. It is now configurable, and allows continuation when an exception is thrown in Calculation. It will not attempt to...

Had to replace 3082 with 3091 for some reason. Essentially the same change.

Thanks - that's an interesting idea. Based on PR #2759, it does seem to work, although it took over 9 minutes for Scrutinizer to compile PHP. I can't find any...

After one successful Scrutinizer run, two subsequent runs failed, without any indication of why. Reverted my PR to draft status, and will continue to try from time to time.

Scrutinizer appears to be fixed this morning (2022-09-12). Two successful runs, although one still shows "pending" on the PR even though test is complete.

Issue appears resolved. Closing ticket.

Aside from Mark's comments, there is a bigger issue here - your test case doesn't actually exercise the code in question. That is because the string is already truncated when...

I am not able to duplicate your result: ```php require __DIR__ . '/PhpSpreadsheet' . '/vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $text = str_repeat('Ω', 35000);...