1. Add named range "Test" for A1:A4 in spreadsheet 2. Go to Tools > References > LibreOffice Calc > General 3. Check "Expand references when new columns/rows are inserted" 4. Go to document and put cursor in row 5 5. Insert new row 6. Check named range "Test" > Still points to A1:A4 Should point to A1:A5 (found while working in 4.2.3.1 - should check which version first shows thus bug)
first version that I have that shows the bug is 4.2.0 alpha1
*** Bug 76548 has been marked as a duplicate of this bug. ***
Cor, Just to make sure about one thing, does the range defined in your named range absolute reference of relative? What exact reference do you see in the named range manager dialog? Is it $A$1:$A$4 or A1:A4?
I can handle the absolute reference case, but not of the reference in a named range is relative. But I think in most cases these references are absolute...
And it will also depend on how you add a named range. If you use the name box to set a named range, it will become absolute reference i.e. with $ next to each column / row address.
I'll take it.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a603ddf9adef4373940936f785e918a8c0ea560b fdo#76402: Write unit test for this first. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8582db191b5c88c72e5b16c89a024f897a95a6f1 fdo#76402: Handle range reference expansion in named ranges. 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.
4.2 backport request: https://gerrit.libreoffice.org/8751
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=96ef8a7a03c7b098c71f7ce8540fb61d13eaa298&h=libreoffice-4-2 fdo#76402: Handle range reference expansion in named ranges. It will be available in LibreOffice 4.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.
Fixed. Yay. \(^o^)/
On Thu, 2014-03-27 at 01:35 +0000, wrote: > Comment # 11 on bug 76402 from Kohei Yoshida > Fixed. Yay. \(^o^)/ > > ______________________________________________________________________ Thanks =) Love the ascii art. ATB, Michael.
(In reply to comment #11) > Fixed. Yay. \(^o^)/ :) thanks & sorry that I dod not yet look in your question in comment #3 - but since I saw commits flowing in... ;)