PhpSpreadsheet
PhpSpreadsheet copied to clipboard
PHPOffice
A pure PHP library for reading and writing spreadsheet files
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...
This is: - [x] a bugfix - [ ] a new feature - [ ] refactoring - [ ] additional unit tests Checklist: - [x] Changes are covered by unit...
I've been having an issue where trying to read an XLSX file was throwing a `SimpleXMLElement::xpath(): Undefined namespace prefix` ``` [2025-06-09 00:56:18] local.ERROR: SimpleXMLElement::xpath(): Undefined namespace prefix {"userId":"1","exception":"[object] (ErrorException(code: 0):...
Users enter dates in format `(DD/MM/YYYY)`, but when reading with `PhpSpreadsheet`, dates come out in American format `(MM/DD/YYYY)`. Using setReadDataOnly(true) disables all formatting, which isn’t ideal because I want to...
This is: - [ ] a bugfix - [ ] a new feature - [x] refactoring - [ ] additional unit tests Checklist: - [ ] Changes are covered by...
After a very long delay, PR #3528 has been moved to ready status, and will be installed soon, warts and all. And it has warts aplenty. It fixes some problem,...
# The bug Calling `Callculation::resizeMatricesExtend()` with matrices of different sizes overwrites **all** rows in the smaller matrix with the value found in the last row. I haven't found the expected...
Hi, I am loading an excel file that has a table with a name of "Test—Only" the `dash` is an `em-dash` which should be allowed as table name in excel....
```php $sheet1->setCellValue('E1', '="THIS IS E1"'); ``` Writer converts formula to `="THIS IS [.E1]"`. The substitution would be correct for, say, `=G1`. This seems like it could be very tricky to...
We have a cell in the example.xlsx sheet containing a total sum as a formula: E1 = IF(SUM(A1:B1) = SUM(C1:D1), "true", "false"), where: A1 = 1.1, B1 = 2.7, C1...
