Cell Coordinate splitRange doesn't support space delimeter #1457
Description
This is: a new feature request without affecting existing functionality.
- [ ] a bug report
- [X] 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 range argument accepts a list of coordinates by comma or space
What is the current behavior?
It incorrectly parses the list into an array of invalid coordinates
What are the steps to reproduce?
A client of ours created an Excel spreadsheet with the following Protection rules:
<protectedRanges>
<protectedRange sqref="C14:O15 C161:O1081 C16:H160 J16:O160" name="SheetName1"/>
<protectedRange sqref="I16:I160" name="SheetName2"/>
</protectedRanges>
I don't know what version of Excel was used - likely the latest version.
Which versions of PhpSpreadsheet and PHP are affected?
1.10 onward, perhaps earlier