Cell formula not updating. Step to Produce : Method 1. 1. Column having values 20, 10, 25, 30, 10. & Sum in the 6th row. 2. Just cut the 1-5 row cell values, sum cell is become zero. 3. Just undo the operation, Values comes back in cell, but still sum cell is zero. 4. Press f9 in sum cell. No change in the sum value. 5. You need type a value in 1-5 cell to update the sum formula or close & open file again to update. Method 2. 1. Column having values 20, 10, 25, 30, 10. & Sum in the 12th row cell. 2. Copy first 4 values. 3. Paste using un-formated[ Paste special option] in 5-8 cell. 4. No change in the sum value. 5. Press f9 in sum cell. No change in the sum value. 6. You need type a value in 1-8 cell to update the sum formula or close & open file again to update.
Created attachment 92722 [details] Sample document sample document for testing.
Reproducible, tested using Mac OSX 10.9 with LibreOffice Version: 4.3.0.0.alpha0+ Build ID: 8fd7a53d3cf1ed788c705cafb443801203787c9d TinderBox: MacOSX-x86@49-TDF, Branch:master, Time: 2014-01-22_00:10:03 Not reproducible using LibreOffice Versie: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 I'm not that experienced with Calc-matter, so I hope someone else can determine it's a big bug or not :). Marking as regression for sure. Kind regards, Joren
Discussed this one on IRC with Markus and Joel. Marking as Critical HIGHEST. Will affect many users and it's a pretty nasty bug. Thanks for reporting! @Eike: ping :). Looks a nasty one. Kind regards, Joren
Reproducible. Win7x64Ultimate Version: 4.2.0.3 Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0 Version: 4.2.1.0.0+ Build ID: 23221e48495262d0384c9169a0d8a01db8a5dab5 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-01-21_13:02:45 Version: 4.3.0.0.alpha0+ Build ID: 77637324abc193d831bb4a0fa6f9a91ef3601960 TinderBox: Win-x86@39, Branch:master, Time: 2014-01-22_16:19:04 No issue with: Version: 4.1.6.0.0+ Build ID: 873be8f3ff28fd06b531b17d2c7cc41cbc1385e In both cases hard recalc does the job. Maybe the cells aren't set as dirty after undo.
I don't quite get Method 2. My questions are inline. (In reply to comment #0) > Method 2. > > 1. Column having values 20, 10, 25, 30, 10. & Sum in the 12th row cell. Do you mean put values in A1:A5 and put formula "=SUM(A1:A5)" in A12? or is the formula "=SUM(A1:A11)"? > 2. Copy first 4 values. I assume copying A1:A4? > 3. Paste using un-formated[ Paste special option] in 5-8 cell. This I don't get. When I paste-special at this point, I get the dialog containing "Selection", "Operation", "Options", "Shift cells". But your step seems to suggest the other paste special dialog. Could you clarify on this? Method 1, on the other hand, was reproducible, and I have a fix at the ready.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fa11b0842a51b59eb131a084310c177235ebe487 fdo#74014: Write unit test for this first. 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=3032d08226f77505e7105fb7cfb7f4b4741fd3ca fdo#74014: Broadcast cells on undoing of "cut". 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 request: https://gerrit.libreoffice.org/7709
Created attachment 92899 [details] sample option
(In reply to comment #5) > I don't quite get Method 2. My questions are inline. > > (In reply to comment #0) > > > Method 2. > > > > 1. Column having values 20, 10, 25, 30, 10. & Sum in the 12th row cell. > > Do you mean put values in A1:A5 and put formula "=SUM(A1:A5)" in A12? or is > the formula "=SUM(A1:A11)"? > > > 2. Copy first 4 values. > > I assume copying A1:A4? > > > 3. Paste using un-formated[ Paste special option] in 5-8 cell. > > This I don't get. When I paste-special at this point, I get the dialog > containing "Selection", "Operation", "Options", "Shift cells". But your > step seems to suggest the other paste special dialog. > > Could you clarify on this? > > Method 1, on the other hand, was reproducible, and I have a fix at the ready. Picture is attached. Sorry for confusing with menu paste special.
Created attachment 92900 [details] sample 2
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=67cab8548356109d52317c797649ab31585db5ae fdo#74014: Better fix, to re-use existing method. 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-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=26f9a971abe37cee355744da1af76092e0fe11df&h=libreoffice-4-2 fdo#74014: Broadcast cells on undoing of "cut". It will be available in LibreOffice 4.2.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.
(In reply to comment #10) > Picture is attached. Sorry for confusing with menu paste special. Thanks. This distinction is important since the paste icon and the paste dialog have two totally different code paths.
And it's interesting that the bug hits only with "Unformatted text" paste.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8a36879eaf0977448b113c2239014d2e2b7ab258 fdo#74014: More on broadcasting at appropriate places. 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=ccd7953e0042c8063e3cbd8e3a3dd9004c1b4f7e fdo#74014: Add unit test for pasting an unformatted text into cells. 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=f5d8029a456c2c708cbc2b67f2d7875540dff1ab fdo#74014: Broadcast changes during undo and redo after paste. 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.
These additional changes fixed scenario 2, plus undo and redo after that, which was not a part of the original report. Backport request for 4.2 is on-going.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3d869cda8db03820dea8c4ba463eb155d05e933b fdo#74014: Brodcast only when pasting, not during file import. 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-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=383e5543593848cbd1458d5c5dad5e7b7b17ee09&h=libreoffice-4-2 fdo#74014: More on broadcasting at appropriate places. It will be available in LibreOffice 4.2.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.
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=92346fb7714ca7c6a467771d8a8b01305c1b17d1&h=libreoffice-4-2 fdo#74014: Broadcast changes during undo and redo after paste. It will be available in LibreOffice 4.2.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.
k. All fixes are in the 4.2.x branch. I'll mark this fixed.
Sorry Kohei but still reproducible for me with: Win7x64Ult. Version: 4.2.1.0.0+ Build ID: 684a0308dcb847f816967202ba87f536b83dcb4e TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-02-10_23:09:14 With the sample file in comment#1 - Deleting D2:D6 - D16 recalc the sum => 72 - Undo - D16 doesn't recalc remains 72 - F9, D16 recalc the sum => 195
4.2 backport: https://gerrit.libreoffice.org/7989
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aa03bdcb5216ff82de22fc02ffa0746902f64972 fdo#74014: Additional test. 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=182ac74065d8724bf74003cb72928b2cfa7388e9 fdo#74014: Broadcast here.... 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-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=04b11e8d5411f687fb573f94d6ed58ace7c424c4&h=libreoffice-4-2 fdo#74014: Broadcast here.... It will be available in LibreOffice 4.2.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.
Fixed again.
Thanks Kohei. Verified fixed. Win7x64Ultimate Version: 4.2.1.0.0+ Build ID: 58df669ac734f4740cf1112867edb808789aae43 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-02-12_13:26:56
Thanks for swift reponse & fixing the bug. I will install & check the changes. :-)
*** Bug 74756 has been marked as a duplicate of this bug. ***
I can confirm this bug again in LO 4.2.5.2, LO 4.3.0.2 (RC2) and LO 4.4.x (daily build 11th July). Comment #1 by Jaise James perfectly explains the steps to reproduce the issue: it seems to be exactly the same bug. Is it possible the unit test failed? Or it was temporarily disabled during the development process and not enabled again? Also note the Whiteboard is targeting 4.3.0 but the fix isn't currently available.
Works as expected for me with LibreOffice 4.3.1.0.0+ build at home under Ubuntu 14.04 x86-64 According to the help (search "recalculate"), F9 force to recalculate the modified formulas. To force to recalculate all formulas use ctrl+maj+F9 Best regards. JBF
I can still confirm the bug on LO 4.3.0 RC3, which should became the final release. Same with LO 4.4 daily (15th july) and LO 4.2.5.2. Steps to reproduce: 1. Open a new spreadsheet, with A1 = 10, A2 = 20, A3 = 30 2. Set A4 = SUM(A1:A3), so you will see A4 = 60 (A1+A2+A3= 10+20+30 = 60) 3. Delete A2 and A4 will correctly become 40 (A1+A2+A3= 10+0+30 = 40) 4. Undo the change: A2 will become again 20, but A4 remains 40 (!!) 5. Press f9 in A4: no change in the sum value. Press Ctrl+Maiusc+F9: it works and A4 becomes 60 6. Try to undo/redo the change multiple times: one time you will see a correct recalculation, one time not. The Whiteboard however is still targeting 4.3.0.
(In reply to comment #35) Hi Teo91, I think bug with undo after delete (your case) has been reported in Bug 80846. So it's different from this bug.
@ign_christian Thank you, that is the correct bug indeed. I close again this report, reverting it to RESOLVED FIXED.
Removing comma from Whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started [NinjaEdit]