I am not sure if it is the same than Bug 81659. Sorry, if duplicate. 1. Turn on: "Expand references when new columns/rows are inserted" 2. Add 1 to A1 on Sheet1 3. Add formula =SUM(A1:A1) into B1 4. Add second sheet 5. Go to line number 2 in second sheet 6. Insert Rows 7. Look at formula in B1 in sheet 1. It has changed to =SUM(A1:A2) I expect formulas in sheet 1 to stay unchanged when inserting rows into sheet 2 because sheet 2 is not in the scope of the formulas reference
Hi @Klaus, thanks for reporting. Reproducible: Win7x64 Versión: 4.2.0.0.beta1 Id. de compilación: f4ca7b35f580827ad2c69ea6d29f7c9b48ebbac7 Version: 4.2.8.0.0+ Build ID: 1fc1d0d7d38bb16832d0d78d78682ed2d5f8716f Version: 4.4.1.1 Build ID: b5ac74bf8683a92078a2bc8aff97d4b436af63cb Version: 4.5.0.0.alpha0+ Build ID: 5210de1c91db64c7d4d99fdda95031b384577219 TinderBox: Win-x86@39, Branch:master, Time: 2015-02-17_03:14:23 Last working. Versión: 4.1.6.2 Id. de compilación: 40ff705089295be5be0aae9b15123f687c05b0a
Probably a duplicate of bug 81659, I'll investigate.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5803c76f318b2a8b655bf83a8257f60cd112ac71 Resolves: tdf#89484 check that sheet reference is within selected sheets It will be available in 4.5.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.
Different bug 81659.
Pending review https://gerrit.libreoffice.org/14609 for 4-4 https://gerrit.libreoffice.org/14610 for 4-3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a0712e79a53c057e4a337c5b8570262dc5a33de&h=libreoffice-4-3 Resolves: tdf#89484 check that sheet reference is within selected sheets It will be available in 4.3.7. 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-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d0b7506b135fd7edd986376a5174a88159ca2f80&h=libreoffice-4-4 Resolves: tdf#89484 check that sheet reference is within selected sheets It will be available in 4.4.2. 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.
Thank you Eike (and also to all the others who are maybe unvisible behind the scenes doing a good job) for fixing this so quickly. I am really looking forward to 4.4.2