IMHO, the behavior of references must be always the same, in
cells, functions, names ranges, data ranges, moving or inserting or deleting
cells/columns/rows, in any place in the spreadsheet where references are used.
For example in Menu/Data/Consolidate, the consolidate ranges don't change even when inserting a row/column in it.
This hidden behavior, what you can't know where it happens, are the worst in spreadsheet beside hidden regressions. Because you can get different results than expected, without knowing it.
Maybe not easy to implement but a target for sooner than later.
And it can make life easier for developers.
it seems this request was filled long time ago.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
The issue with Consolidate is there.
Version: 18.104.22.168 (x64)
Build ID: 72fee18f394a980128dc111963f2eefb05998eeb
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new;
Locale: es-ES (es_ES); Calc: group
Hi Xisco, is there a regular test about this matter?
Sounds like a good enhancement -> NEW