Bug 114143 - Formula (sum()) in cell is not calculation correct after adding a column and adjusting the range of the sum formula
Summary: Formula (sum()) in cell is not calculation correct after adding a column and ...
Status: RESOLVED DUPLICATE of bug 111428
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-11-29 15:42 UTC by Uwe Graßhoff
Modified: 2017-11-30 13:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Video of my desktop during reproducing the bug (1.29 MB, video/mp4)
2017-11-30 09:46 UTC, Uwe Graßhoff
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Uwe Graßhoff 2017-11-29 15:42:00 UTC
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
Comment 1 m_a_riosv 2017-11-29 22:41:22 UTC
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?
Comment 2 Uwe Graßhoff 2017-11-30 09:46:16 UTC
Created attachment 138110 [details]
Video of my desktop during reproducing the bug
Comment 3 Uwe Graßhoff 2017-11-30 09:47:35 UTC
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.
Comment 4 m_a_riosv 2017-11-30 10:02:37 UTC
Please test Menu/Help/Restart on Safe mode.
Comment 5 Uwe Graßhoff 2017-11-30 10:05:18 UTC
Already tested. (Mentioned in initial description) no success
Comment 6 Kevin Suo 2017-11-30 10:37:59 UTC
May be a duplicate a bug 111428? Please check. @Uwe
Comment 7 Uwe Graßhoff 2017-11-30 12:34:18 UTC
(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.
Comment 8 Kevin Suo 2017-11-30 13:12:21 UTC

*** This bug has been marked as a duplicate of bug 111428 ***