InsertRowBefore does not update named cell references

[William-IRM]

Migrating a really old internal tool from PHPExcel to PhpSpreadsheet, I was surprised and disappointed to discover that while the old PHPExcel correctly updated named cell references when inserting/deleting rows/columns, it doesn't appear that PhpSpreadsheet does the same.

I see that cross-sheet references are also not updated automatically, due to performance concerns. Can I propose a solution? Add an additional (optional?) parameter to the various insert/delete functions to allow the user to define what to check and update. I'm thinking a series of constants, use standard binary operators to combine as desired:

• PHPSPREADSHEET_UPDATE_NONE: for those who know there's no references and want lightning fast inserts/deletes. Useful for cloning a style.
• PHPSPREADSHEET_UPDATE_SAME_SHEET: as the current behaviour.
• PHPSPREADSHEET_UPDATE_OTHER_SHEETS: Specifically only update references in other sheets. Probably not useful on its own, but you never know.
• PHPSPREADSHEET_UPDATE_NAMED_REFERENCES: Specifically only update named cells/ranges.
• PHPSPREADSHEET_UPDATE_ALL: Combination of same sheet, other sheets, and named references.

[oleibman]

I am aware that we don't update references across sheets. However, we do have code to update named ranges. Can you provide a spreadsheet and code to demonstrate the problem that you are having with those? Also let me know the releases of PhpSpreadsheet and Php that you are using.

[William-IRM]

I'll have to fabricate something, my current issue is with a company document I can't make public. Let me do some testing and see if my issue is caused by some quirk of the template I'm populating, but either way the behaviour does not seem to match the old PHPExcel. I'm using PHP 8.3 and PhpSpreadsheet 5.4.0.