Bug 54175 - Behavior of references should always be the same, moving or inserting or deleting cells/columns/rows, in any place where references are used.
Summary: Behavior of references should always be the same, moving or inserting or dele...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Reference
  Show dependency tree / graph
 
Reported: 2012-08-28 23:29 UTC by m_a_riosv
Modified: 2017-07-09 21:16 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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