Created attachment 96740 [details]
A short sample with erroneous references ("Tabelle 2") after inserting multiple lines at once.
Reference adjustment is erroneous when multiple lines are inserted at once. See attached document.
Steps to reproduce:
1. "Tabelle 1" contains the starting point.
2. "Tabelle 2" is a copy of "Tabelle 1"; then I inserted lines 2 to 6 at once.
3. "Tabelle 3" is the same, but lines 2 to 6 inserted individually.
"Tabelle 2" is erroneous, since the references aren't adjusted the right way.
"Tabelle 2" should look exactly as "Tabelle 3".
Linux Mint 16 64-bit (Ubuntu)
Oracle Java 8
Operating System: Linux (Other)
Version: 126.96.36.199 release
Hi andre, thanks for reporting.
Version 188.8.131.52 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)
Version: 184.108.40.206 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f
Version: 220.127.116.11.0+ Build ID: d6bc8ed3356d88231cca0306790f300517b7fae2
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-28_16:43:41
Version: 18.104.22.168.alpha0+ Build ID: b6a43bcbbf9e9a5655fd36fd4c8ef72d585f67b0
TinderBox: Win-x86@39, Branch:master, Time: 2014-03-30_06:16:21
Versión 22.214.171.124 (ID de compilación: e183d5b)
The issue seems to be, that when there is a multi cell range the first address is not updated, while inserting more than one row a time, no different if it's a relative or absolute address, but when the group of rows to insert begin above or in the same row and ends beyond the cell where the range is.
Added to MAB 4.2
*** Bug 77647 has been marked as a duplicate of this bug. ***
bug 77647 is only from 4.2.0 the issue and was in 4.1.5 correct!!
I just tested it with the latests of 4.0 and 4.1 and it seems to work fine with those versions.
Actually this *is* a duplicate of Bug 77647. After fixing that one this bug no longer is reproducible.
*** This bug has been marked as a duplicate of bug 77647 ***
Kohei Yoshida committed a patch related to this issue.
It has been pushed to "master":
fdo#76912: Write a test for this.
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:
Affected users are encouraged to test the fix and report feedback.
I just wrote a test for this, but no separate fix is necessary.