Mark Baker
Mark Baker
```php $sheet->setCellValue("G30","=IF(ISTEXT(D30);1*E30;D30*E30)"); ``` will not work because you are using `;` as the argument separator for the Excel `IF()` function. You ___must___ use `,` instead. ```php $sheet->setCellValue("G30","=IF(ISTEXT(D30),1*E30,D30*E30)"); ```
The formula as you see it in MS Excel will depend entirely on your locale settings: if somebody with different locale setings opens it, they will see that formula according...
Either install the latest master of PhpSpreadsheet, which will work with psr/simple-cache 3; or downgrade your psr/simple-cache to version 2
No: If you do a composer require without specifying a version, then composer will pick the latest tagged release; it will only install the latest commit against master if there...
Resolved in release `1.25.0`
Temporary workaround for you, because it could take days or weeks to figure out what is happening with this formula: Disable calculating formulae on save by calling the Writer's `setPreCalculateFormulas()`...
The only possible way to calculate a column width is to calculate the values (with formatting) that will be stored in those cells to work out how many characters each...
So why do you think this is a problem with PhpSpreadsheet? And not a problem with Vapor (whatever Vapor is)? Your stack trace shows nothing of PhpSpreadsheet?
Bingo, that works thanks.... is it documented anywhere?
I think it might by approaching time to drop Scrutinizer from the CI pipeline; though I do like the reports that show how code quality, test coverage, etc change from...