Bug 54175

Summary: Behavior of references should always be the same, moving or inserting or deleting cells/columns/rows, in any place where references are used.
Product: LibreOffice Reporter: m_a_riosv <miguelangelrv>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: cno, ilmari.lauhakangas
Priority: medium    
Version: unspecified   
Hardware: Other   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=92419
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108917    

Description m_a_riosv 2012-08-28 23:29:33 UTC 
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.
Comment 1 Xisco Faulí 2017-03-02 10:14:09 UTC 
Dear Reporter,
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.
Comment 2 m_a_riosv 2017-03-02 10:37:14 UTC 
The issue with Consolidate is there.
Version: 5.3.1.1 (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
Comment 3 m_a_riosv 2017-03-02 10:38:15 UTC 
Hi Xisco, is there a regular test about this matter?
Comment 4 Buovjaga 2017-03-04 18:47:39 UTC 
Sounds like a good enhancement -> NEW