Splitting panes #3601
Description
This is:
- [X] a feature request
What is the expected behavior?
a) recognize split panes when reading files and use this information when writing files
b) provide getters/setters to access split information
What is the current behavior?
Splitting panes is not supported
What features do you think are causing the issue
- Reader
- Writer
Does an issue affect all spreadsheet file formats? If not, which formats are affected?
At least Ods, Xls, Xlsx and Xml are affected
Which versions of PhpSpreadsheet and PHP are affected?
All versions are affected
Splitting is quite similar to freezing - the worksheet is broken up into two or four parts, but there are notable differences:
a) freezing occurs at cell boundaries, splitting at a geometric position (specified in points from the upper left)
b) in freeze mode only the bottom/right pane can be scrolled while the upper/left pane is pinned to its initial state. In split mode the upper/lower panes can be scrolled independently in vertical direction, the left/right panes independently in horizontal direction. All those scroll positions are saved into files.
As far as I can see splitting has no implications on data storage or calculations, so PhpSpreadsheet should not be affected too much. However, it would be good to read/write splitting information if present and to be able to manipulate it in memory.