You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
- [x] a bug report
- [ ] a feature request
- [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)
What is the expected behavior?
When using clone on a sheet, it should clone it successfully.
What is the current behavior?
When cloning a sheet that contains a table, it throws the error: Error: Spreadsheet objects cannot be serialized
What are the steps to reproduce?
An XLSX file with a table (example attached), load it into PhpSpreadsheet and use clone on the sheet that contains the table.
FixPHPOffice#3820. When cloning a worksheet, special handling is already included for `cellCollection` and `drawingCollection`. It needs to be added for `tableCollection` as well. In theory, `chartCollection` also needs it. However, there are no clone methods for any of the Chart objects, so that will be a substantially larger effort. There is no need to delay this fix waiting for that.
This is:
What is the expected behavior?
When using clone on a sheet, it should clone it successfully.
What is the current behavior?
When cloning a sheet that contains a table, it throws the error: Error: Spreadsheet objects cannot be serialized
What are the steps to reproduce?
An XLSX file with a table (example attached), load it into PhpSpreadsheet and use clone on the sheet that contains the table.
Please provide a Minimal, Complete, and Verifiable example of code that exhibits the issue without relying on an external Excel file or a web server:
Example file:
example.xlsx
What features do you think are causing the issue
Reader
Writer
Styles
Data Validations
Formula Calculations
Charts
AutoFilter
Form Elements
Does an issue affect all spreadsheet file formats? If not, which formats are affected?
XLSX
Which versions of PhpSpreadsheet and PHP are affected?
I'm using 1.28.0, didn't test any other.
The text was updated successfully, but these errors were encountered: