references to different sheet get removed on dragging cell. Reference changes to same sheet. Step to produce. 1. enter some value in the cells [sheet1] 2. create some formula using values entered in sheet1 3. create a reference in other sheet[sheet2] using formula referring sheet1 4. move the formula created in sheet1. 5. the formula eg. sheet1.A1 get lost on sheet 2 & become A1 only Sample file attached. first formula cells on sheet2 move yellow cell on sheet 1 now check formula on sheet 2. all reference become lost.
Created attachment 105077 [details] Reference lost on drag
Created attachment 105078 [details] drag1
Created attachment 105079 [details] before drag
Created attachment 105080 [details] drag cell
Created attachment 105081 [details] after drag cell formula
Reproduced with LO 4.3.1.1 - Ubuntu 12.04 x86 Also reproduced from scratch and with cut-paste. Undo not resolved original reference. Not reproduced with LO 4.3.0.4, 4.3.0.0.beta1, 4.2.6.2
I'm working on it.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=75aad687cb5e63a41303aea568bf68b2b5f15d31 resolved fdo#82936 do not clear the 3D flag on refupdate 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/11066 for 4-3 https://gerrit.libreoffice.org/11067 for 4-3-1
Wow..fixed only in a couple minutes.. :) Thanks Eike
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-3-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=756e729f0e8c37143971e83b0e89d9b6ca9d1289&h=libreoffice-4-3-1 resolved fdo#82936 do not clear the 3D flag on refupdate It will be available already in LibreOffice 4.3.1. 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-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5ef430a700e67c4e5029f5af553c0ce8230b6e74&h=libreoffice-4-3 resolved fdo#82936 do not clear the 3D flag on refupdate It will be available in LibreOffice 4.3.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.
Verify fixed with LO 4.3.1.2 - Ubuntu 12.04 x86
*** Bug 85946 has been marked as a duplicate of this bug. ***
This also crept into 4.2.7, the patch is pending review for 4-2 at https://gerrit.libreoffice.org/12304 but there's no 4.2.8 release scheduled.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1b0b80195802dd1e707f07e4825d6847ff810c73&h=libreoffice-4-2 resolved fdo#82936 do not clear the 3D flag on refupdate It will be available in 4.2.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.
Clarification: this last fix will NOT be available in 4.2.7, that was an error of the notification script. If at all the fix would be available in 4.2.8 if that would be released.
(In reply to Eike Rathke from comment #17) > Clarification: this last fix will NOT be available in 4.2.7, that was an > error of the notification script. If at all the fix would be available in > 4.2.8 if that would be released. Thanks Eike for the work here. Ubuntu users are invited to test the 1:4.2.7-0ubuntu2~ppa1 package from https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-4-2 as there will be no more upstream 4.2 release.
Ok, advertizing things ;-) this fix is part of Fedora libreoffice-4.2.7.2-6.fc20
*** Bug 87446 has been marked as a duplicate of this bug. ***
*** Bug 88537 has been marked as a duplicate of this bug. ***