Created attachment 126881 [details] Range Name Example Windows 10, LibreOffice 5.2.0.4 When inserting rows and/or columns range name references are not updated correctly. In the attached file there is a simple table with the column headings 'Description' and 'Weight' along with a short list. The Table is named 'Fruits_LUT' and the columns 'Fruits' and 'Weight'. Above the table is a simple formula to return the maximum weight. Inserting a column to the left of column A moves the data to the right but the 'Fruits_LUT' range name now covers columns A to C. 'Fruits' now also includes column A. 'Weights' updates correctly. Inserting two rows above the table results in each of the range name references being extended to include the inserted rows.
I think you have enable the option: Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted. Disabling it works as you expect. Resolved as not a bug, please if you are not agree, reopen it.
Yes, you were right, I had the Expand references option ticked. I obviously did that in error and without realising I had done so. Please accept my apologies.
Don't worry, there are a lot of options, everybody ask for the option they like, but with so many makes easy this kind of mistakes. :)
(In reply to m.a.riosv from comment #1) > I think you have enable the option: > Menu/Tools/Options/LibreOffice calc/General - Expand references when new > columns/rows are inserted. > Disabling it works as you expect. > > Resolved as not a bug, please if you are not agree, reopen it. Sorry, but I disagree with this. With option unchecked, no change in named range. That's OK With option checked, ranges must be expanded but not this way : Insert column should expand named range *only if named range had 2 or more columns*. So Fruit_LUT sould expand to A7:C9, while Fruits (A7:A9, only une column) should *not* be expended. Same for insert row, only named range with several rows must be expended.
Hi @GerardF I don't think the same matter. It begins with Win10x64 Version: 5.0.6.2 (x64) Build ID: b3fbfa99158a1030fb79f0ba72b6851afc3c7895-GL last working for me: Version: 4.4.7.2 Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600 Looks like a regression from 4.4 to 5.0
Also in: Version: 5.3.0.0.alpha0+ (x64) Build ID: 327f5cc66f122979943d2c896eb1824791a854c9 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2016-08-18_00:02:16 Locale: es-ES (es_ES); Calc: CL
Adding keyword 'bibisectRequest'.
Taking, bibisect not needed.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6b9804b8f2ca85e9eb42d344d17cfee7a7a9414c Resolves: tdf#101583 references to be expanded must be at least 2 cols/rows It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/30023 for 5-2
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5cfbab03f914946bf9e5813eae707328fda438f9 unit test for tdf#101583, named expression reference expansion It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0230a4eccd3884ef3c3d6b7b4c6d54e5582a1268&h=libreoffice-5-2 Resolves: tdf#101583 references to be expanded must be at least 2 cols/rows It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.