Step to produce. Document having 3 sheets. Document having sheet 1 having reference to sheet 2 cell. delete sheet 2. #ref will come in sheet 1. If undo sheet 2, there is no change in #ref. Expected behavior sheet 1 cell have the value.
Created attachment 95502 [details] Sample document sample document
confirmed on LO4.2.1.1 Fedora 20. I just modified one of my docs. Originally this formula exists in sheet 3: =Sheet4.D24+Sheet4.D25 remove sheet 4 and this becomes: =#REF!.D24+#REF!.D25 restore sheet 4 with CTRL-Z and the formula remains unchanged. Is this a bug or an unavoidable "feature"?
reproducible with LO 4.2.1.1 (Win 8.1)
.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c9058f25e97b58a05eb25b7b769f6406423186b6 fdo#75977: Write 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: 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=18909ddb30db7ca9416ee2bfb0503753e877f002 fdo#75977: Clear sheet deleted flags for affected references when undoing. 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/8564
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=3da21555accb654a3185bdac5532304ac6ce5b34&h=libreoffice-4-2 fdo#75977: Clear sheet deleted flags for affected references when undoing. 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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.