Created attachment 131062 [details] Calc file with error When COUNTIF contains an absolute reference and the reference is deleted(causing #REF! error as expected) undoing the deletion that caused the eerror with either Ctrl-Z or the undo arrow does not fix the #REF! error. However, relative references behave as expected. Attached sample. Delete Column A and then undo deletion to replicate. Row 1 contains relative reference as a comparison
Confirmed. Version: 5.2.5.1 (x64) Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Locale: es-ES (es_ES); Calc: group Version: 5.4.0.0.alpha0+ Build ID: 0e0fef10002b46965edad02b3f460a502d9f6595 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-02-08_23:11:53 Locale: es-ES (es_ES); Calc: CL
Regression introduced by: author Kohei Yoshida <kohei.yoshida@gmail.com> 2013-08-06 23:03:47 (GMT) committer Kohei Yoshida <kohei.yoshida@gmail.com> 2013-08-12 23:46:25 (GMT) commit 027f8cd9442aec9c432bfcfc69f7d6e81b760eb5 (patch) tree f6e5ed97b1f9e74f33219d5310b844e768fff55b parent 417d1c2b13cbd70300d2921b5667dfadc7e25895 (diff) Handle shared token array correctly when adjusting formula grouping. Adding Cc: to Kohei Yoshida
I'm looking into this.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=749405af4fc38e0c16dc7e860d23a13dfceb4e40 tdf#105908: restore previously deleted range references upon undo. It will be available in 5.4.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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1ac30cf245454c6f7a777699436722a94a9e349c tdf#105908: add test for this. It will be available in 5.4.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.
Backport on the way: 5.2: https://gerrit.libreoffice.org/#/c/35673/ 5.3: https://gerrit.libreoffice.org/#/c/35672/
Verified Ok. Version: 5.4.0.0.alpha0+ Build ID: a4034d56813b6716ae93d455204079cdd2ff9f6f CPU threads: 4; OS: Windows 6.2; UI render: GL; TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2017-03-26_04:30:46 Locale: es-ES (es_ES); Calc: CL
Thanks for the verification. I'll mark this resolved.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2d9de590d9ebd8740fc0f6d94f5ee98b22377877&h=libreoffice-5-2 tdf#105908: restore previously deleted range references upon undo. It will be available in 5.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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=97ce2a4eb0b2b479d48afe28299ad0ff1d3a264d&h=libreoffice-5-3 tdf#105908: restore previously deleted range references upon undo. It will be available in 5.3.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.