Created attachment 95200 [details] Links source file Having external links to other spreadsheets, when deleting or inserting rows above those, changes the references in the links. The issue begin with 4.2 series. Win7x64Ultimate Version: 4.2.0.4 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71 Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f Version: 4.2.3.0.0+ Build ID: 9a32be03681a595ce075e6fc6d6c60494a70a2fb TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-04_16:12:48 Version: 4.3.0.0.alpha0+ Build ID: 4402efc18ae16e279d55858946d2c8b8972f3f9f TinderBox: Win-x86@39, Branch:master, Time: 2014-03-04_00:54:43 Last working. Version: 4.1.6.0.0+ Build ID: ff2704d22bab86d9e58df812bc01482cfb4bb26 Attached source links file.
Created attachment 95201 [details] Sample file with links to an external file. Sample file with links to the file in the report.
Ah - almost closed this as not a bug but realized my mistake. Thank you for reporting this issue! I have been able to confirm the issue on: Version: 4.3.0.0.alpha0 Date: Tue Feb 25 19:58:48 2014 +0100 Platform :Ubuntu 13.10 DE: GNOME3 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem I am marking as: New (confirmed) Major - loss of data by changing formulas Highest - default is high but bumped up due to regression MAB4.2 regression + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Set the missing version number. Best regards. JBF
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=149b580900214c477f8eaf9dd51342796d27b296 fdo#75815: Write 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=dd7787ed75e33b65ebee2a6c0aa152efded6f1b8 fdo#75815: Adjust external references here too. 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: https://gerrit.libreoffice.org/8529
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=57ba6cf00b3258838ef6ec75ce7c1c7c38ade751&h=libreoffice-4-2 fdo#75815: Adjust external references here too. It will be available in LibreOffice 4.2.3. 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.