When deleting a row, some of affected cells are not recalculated and contain incorrect values. Steps to reproduce: 1. Open a new spreadsheet. 2. Type number 1 to A1, formula "=A1" to B1 and "=B1" to C1. 3. Delete entire column A. Observed: Cell A1 (former B1) gets #REF! value, whereas 1 remains in B1 (former C1). Expected: Both A1 and B1 cells should have #REF! value. The issue does not appear if A1 cell is deleted only (not entire column) or if an entire row is deleted (if we use A1, A2, A3 instead of A1, B1, C1). Tested in 4.2 series (from beta 2 to 4.2.5 RC1), 4.3 beta2 and 4.3 RC1. Previous series are not affected. Severity set to major as this leads to incorrect values in a spreadsheet.
Hi I close "duplicate" as bug 59108 Feel free to reopen with more information if necessary Regards Pierre-Yves *** This bug has been marked as a duplicate of bug 59108 ***
Hi, reopening - this is a different issues. Bug 59108 wants to preserve values instead of #REF!, here I want the cell to be recalculated as #REF! instead of numeric value. Maybe I should have added that you can see the problem if you recalculate the sheet (Ctrl+Shift+F9) - after that, value 1 in B1 changes to the correct #REF! (Note also that 59108 was reported against 4.0.3, this one appeared in 4.2.)
> Observed: Cell A1 (former B1) gets #REF! value, whereas 1 remains in B1 > (former C1). Confirm same behavior in LO 4.2.5.2 - Ubuntu 12.04 x86. Not happen in 4.1.6.2 and 4.0.6.2
Bibisect result: source-hash-8499e78ca03c792f4fa2650e02b519094ba0baa8 commit 8499e78ca03c792f4fa2650e02b519094ba0baa8 Author: Caolán McNamara <caolanm@redhat.com> AuthorDate: Thu Jul 25 16:01:13 2013 +0100 Commit: Caolán McNamara <caolanm@redhat.com> CommitDate: Thu Jul 25 16:08:01 2013 +0100 Related: fdo#61544 convert language page from box to grid grid compress better than boxes if there isn't enough available space Change-Id: I35b433b89a29159a33fc9edb646e46b371747a57 :100644 100644 28f5d06d73a1be6ffa14981fa5c85369334b42f3 69df816431adccb1d94d7239031fa72b51b69fd9 M ccache.log :100644 100644 e90dd416081e52bf1f529e5cc252b740762fb67f fb3eed5f2df90e38291b7693863d22a51ae5f909 M commitmsg :100644 100644 f3412ea896c81e0e5e7c7c5b20da51801f5732d1 b37aff13469762597fe8e71b9eec6543077c6320 M dev-install.log :100644 100644 20c900e22a8115c31e67f895acbe3ec11c432314 a6d96513f1e560f38ad6b20e13ae9c5ddb619132 M make.log :040000 040000 956ae0b2d085e2de7f912e234fe22cb51b2e3f29 14c94892e549a813ae539489d88273f18ad79631 M opt # bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e # good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932 git bisect start 'latest' 'oldest' # good: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb git bisect good e02439a3d6297a1f5334fa558ddec5ef4212c574 # bad: [4850941efe43ae800be5c76e1102ab80ac2c085d] source-hash-980a6e552502f02f12c15bfb1c9f8e6269499f4b git bisect bad 4850941efe43ae800be5c76e1102ab80ac2c085d # skip: [a043626b542eb8314218d7439534dce2fc325304] source-hash-9379a922c07df3cdb7d567cc88dfaaa39ead3681 git bisect skip a043626b542eb8314218d7439534dce2fc325304 # skip: [aba65c3e4c0df07e4909aeefb758cdb688242bf6] source-hash-827524abfb4b577d08276fde40929a9adfb7ff1a git bisect skip aba65c3e4c0df07e4909aeefb758cdb688242bf6 # skip: [aba65c3e4c0df07e4909aeefb758cdb688242bf6] source-hash-827524abfb4b577d08276fde40929a9adfb7ff1a git bisect skip aba65c3e4c0df07e4909aeefb758cdb688242bf6 # bad: [c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31] source-hash-c69ed33628ec0b7abf6296539cf280d6c4265930 git bisect bad c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31 # bad: [c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31] source-hash-c69ed33628ec0b7abf6296539cf280d6c4265930 git bisect bad c81a8a0dcfc1ed095a80e4485c89dd0fcaf73f31 # bad: [1d4980621741d3050a5fe61b247c157d769988f2] source-hash-89d01a7d8028ddb765e02c116d202a2435894217 git bisect bad 1d4980621741d3050a5fe61b247c157d769988f2 # bad: [ba096f438393091574da98fe7b8e6b05182a8971] source-hash-8499e78ca03c792f4fa2650e02b519094ba0baa8 git bisect bad ba096f438393091574da98fe7b8e6b05182a8971 # good: [9daa289e178460daaafa4b3911031df5b8736218] source-hash-704292996a3731a61339b1a4a5c90c9403aa095f git bisect good 9daa289e178460daaafa4b3911031df5b8736218 # good: [34eab3946c46bb7273ba4ca395db9c4421dd232f] source-hash-e962805b31074d6b6a2ed0db6452769448337553 git bisect good 34eab3946c46bb7273ba4ca395db9c4421dd232f # good: [a8577b9049e085140768f97f7d4ff555a8a447cb] source-hash-98ded3e42011b060368899018c07cbd32e7993f1 git bisect good a8577b9049e085140768f97f7d4ff555a8a447cb # good: [da4ad98ef394c644bb0aa80161ff599330862e7c] source-hash-570fe620e9d573cfc9fc260e6518563c6a6c1a3c git bisect good da4ad98ef394c644bb0aa80161ff599330862e7c # good: [2d9baecf3ce2ea1ec8bea3e842eed595061eeef6] source-hash-ff51a2b64571a8d72ff4d8a8181d17cf98c42e69 git bisect good 2d9baecf3ce2ea1ec8bea3e842eed595061eeef6 # first bad commit: [ba096f438393091574da98fe7b8e6b05182a8971] source-hash-8499e78ca03c792f4fa2650e02b519094ba0baa8
I'm on it.
fixed on master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=7fef943114b9184e69c8c714bf158116b8d9caf7 4.3 backport on gerrit: https://gerrit.libreoffice.org/12014
Checked in master; it works now as expected. Thanks a lot for fixing this!
Pushed to 4-3 http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-3&id=b35c51d15189835bd388411f9ab4baefacd7b460
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]