Hello,

Version 5.2.0

Error: Invalid cell coordinate D4 J2

Trace:
#0 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/CellReferenceHelper.php(60): PhpOffice\PhpSpreadsheet\Cell\Coordinate::coordinateFromString('D4 J2') #1 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php(1113): PhpOffice\PhpSpreadsheet\CellReferenceHelper->updateCellReference('D4 J2', false, false, NULL) #2 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php(1004): PhpOffice\PhpSpreadsheet\ReferenceHelper->updateCellRange('B2:D4 J2:L4 F2:...', false, false) #3 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php(338): PhpOffice\PhpSpreadsheet\ReferenceHelper->updateCellReference('B2:D4 J2:L4 F2:...') #4 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php(544): PhpOffice\PhpSpreadsheet\ReferenceHelper->adjustProtectedCells(Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet), 0, 1) #5 /app/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Worksheet.php(2342): PhpOffice\PhpSpreadsheet\ReferenceHelper->insertNewBefore('A2', 0, 1, Object(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet))

Space management as a range separator is not supported by the insertNewBefore function.

I am providing a sample file to reproduce the bug.
bug.xlsx

Code to reproduce:
$spreadsheet = IOFactory::load('{path_to_file}/bug.xlsx'); $worksheet = $spreadsheet->getActiveSheet(); $worksheet->insertNewRowBefore(2);

The subject is related to this MR: #4580