Description: I attach an example file but you can build your own. Reproducible every time for me. A sum depending on cells themselves sum does not recalculate, when defined from a dragged formula. Steps to Reproduce: 1. Put random numbers in a corner - in the example A1 to C4. 2. Below the first column, calculate the sum then drag right to do the same for all columns (cells A5-D5) 3. Right of the first line, calculate the line sum then drag down to do the same for all lines including the last, "summed" line (cells D1-D5). I get 182 in D5. 4. Just below, copy exactly D5 ie "=SUM(A5:C5)". I get 182 too. (or replace steps 1-4 by opening the attached spreadsheet) 5. Select a line (eg 3) and hit "delete". Cells in line 3 are now empty. Actual Results: Totals recalculate EXCEPT for cell D5 (who depends on A5-C5), staying at 182. F9 solves the problem. Interestingly enough cell D6 (that was manually edited instead of dragging the formulas down) works just fine, updating to 132. Also interestingly, inserting an empty line between lines 4 & 5 prior to deleting line 3 makes it work correctly. Expected Results: Both cells D5 & D6 should recalculate when deleting a line above - only D6 does. Reproducible: Always User Profile Reset: No Additional Info: Didn't reset my user profile but same problem on a different, new machine. I put the severity as "normal" but personally for me, it is major - I can't trust my calculations anymore and need to recalculate everything whenever I change something. User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
Created attachment 131284 [details] example of described bug
On Win7 with LO 5.3.0.3, I could reproduce this. Remark: you must empty the line not delete it because in this case, the sum is ok. I increase priority because it concerns several envs and it gives wrong results by just calling sum function.
I also could reproduce this with a brand new file by using the same method as described by the reporter.
I could also reproduce this with brand new profile with or without OpenCL disabled.
Bug 104824 - Wrong SUM calculating I Guess, the above bug has some relation with this. If the origin of "Wrong sum calculating" is the because recalculate doesn't work well then it is a major issue because recalc wasn't working in file mentioned in Bug 104824. https://gerrit.libreoffice.org/#/c/32880/
(In reply to Fakabbir amin from comment #5) > Bug 104824 - Wrong SUM calculating > I Guess, the above bug has some relation with this. Absolutely not related.
Arul Michael committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c882c60f54cc90740a674eed8c47bde0e9959652 tdf#106051 Notify listeners on top and bottom of split formula group 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.
Arul Michael committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f55f0b57b1f206763e97065f6121fcb55c53e53d&h=libreoffice-5-3 tdf#106051 Notify listeners on top and bottom of split formula group It will be available in 5.3.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.
(In reply to Commit Notification from comment #8) > Arul Michael committed a patch related to this issue. > It has been pushed to "libreoffice-5-3": > > http://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=f55f0b57b1f206763e97065f6121fcb55c53e53d&h=libreoffice-5-3 Works fine in Version: 6.0.0.0.alpha0+ Build ID: 959be1b5a9cd522394dba9366686a1256588223b CPU threads: 4; OS: Linux 4.10; UI render: GL; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-07-11_00:18:59 Locale: nl-NL (nl_NL.UTF-8); Calc: group Thanks for fixing Arul!
This issue still exists in Version: 5.3.4.2.
Just upgraded to 5.4.4.2 and happy to report that the problem seems to be resolved.
I have upgraded to 5.4.5.1 and still auto sum does not work!