This is: - [X] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) You may need to do a full composer install from the new composer.lock; or to manually reinstall ph...

This is: - [X ] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? The ability to subclass the library classes to add/enhance functio...

This is: - [x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? Array formulae should be written to an XLSX file so that the value...

This is: - [x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? A simple formula on Sheet1 referencing a named cell on Sheet2 shoul...

This is: - [x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? Nested IF+MROUND formula: =IF(MROUND(IF(B4<2200,2.24,(B4*1.2)/10...

This is: - [X] a bug report What is the expected behavior? According to your EOL policy, I expect PhpSpreadsheet to run on PHP 7.4 until June 2023. What is the current behavior? Currently, a fresh install fails due to a dependency problem with zipstream-php. They removed PHP 7 support as of 2.3.0 (...

We are testing the 1.27.0 version on PHP 8.2. When enabling all the errors, we get this error: Deprecated: Implicit conversion from float 26.2 to int loses precision in /var/www/vhosts/inc/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/StringTable.php on line 45 This is some code:...

We are testing the 1.27.0 version on PHP 8.2. When enabling all the errors, we get this error: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppre...

This is: - [X] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? To load the xlsx file What is the current behavior? ErrorException:...

This is: - [ x] a bug report - [ ] a feature request - [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) What is the expected behavior? install on php 8.1 for use What is the current behavior? Package p...