Description: After adding a column into a a document and adjusting the range of a =sum() formula so that it contains the new cell the value of the new cell can be changed without getting a new result in the =sum() cell I already tried "Safe Mode" no success. I also tried it on a different machine with version 5.3.7.2. I'm using the german version so please be gentle if there are some menu captions are translated wrong ;-) You need to follow the "Steps to reproduce" exactly. If you for example use your keyboard in step 6 to alter the range of the sum formula directly the bug will NOT appear. Steps to Reproduce: 1. open scalc.exe 2. add formula =SUM(A1:C1) into cell D1 (Value of Cell D1 is now 0) 3. right click on column header of column D 4. click add new column on the left 5. select the cell with the SUM formula (should be E1 now) and press F2 6. use your mouse to extend the selection so that it covers A1 to D1 inclusiv 7. press enter 8. enter a number(42) in any of the cells which are covered by the SUM formula 9. see that the cell with the SUM formula doesn't get the new correct value. (still displaying 0) Actual Results: The SUM formula is not calculating properly Expected Results: The calculation should be work as normal. After entering the value of a cell which is covered by the SUM formula the SUM formula should be updated with the new value. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no I tried it with OpenGL enabled and disabled it doesn't affect the bug. Helo -> ABout LibreOffice Version: 5.4.2.2 (x64) Build-ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4 CPU-Threads: 8; Betriebssystem:Windows 6.1; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: CL User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0
I can't reproduce. Version: 5.4.3.2 (x64) Build ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group Is autocalculate enable?
Created attachment 138110 [details] Video of my desktop during reproducing the bug
Yes autocalculate is enabled. And even disabling and re- enabling won't help. Pressing F9 (re calculate) sometimes helps. I've attached a video where you can see how I reproduce the bug.
Please test Menu/Help/Restart on Safe mode.
Already tested. (Mentioned in initial description) no success
May be a duplicate a bug 111428? Please check. @Uwe
(In reply to Kevin Suo from comment #6) > May be a duplicate a bug 111428? Please check. @Uwe Hi Kevin, I checked the bug and yes it seems so that my bug is the same as the one you mentioned. And I can confirm that my bug is gone in libo-master64~2017-11-29_23.13.56_LibreOfficeDev_6.1.0.0.alpha0_Win_x64 Version: 6.1.0.0.alpha0+ (x64) Build ID: 42dafb5c7bd218f4d368fbd1113fa4a0fcd7f0cb CPU threads: 8; OS: Windows 6.1; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-11-29_23:13:56 Locale: de-DE (de_DE); Calc: CL This ticket can be closed from my point of view.
*** This bug has been marked as a duplicate of bug 111428 ***