[Libreoffice-bugs] [Bug 120270] New: No update to refs to sum cell after undoing change in sum range

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Bug ID: 120270
Summary: No update to refs to sum cell after undoing change in
sum range
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@yahoo.com

Created attachment 145323
--> https://bugs.documentfoundation.org/attachment.cgi?id=145323&action=edit
screenshot showing unchanged state after undo

In some cell B, enter a range sum over cells A1 to An, then enter a reference
to cell B in another cell C. Now enter a value in the summation range say in
Ax, the change will be reflected in the summation cell B and it's reference
cell C. Select cell Ax and move it to another cell outside the sum range, the
change again is reflected in B and C. Now undo the change using the undo menu
option or the Ctrl-Z key binding, the Ax cell gets it's value back, the
summation cell B gets changed to reflect the change in it's range, *but* the
reference cell C does not change to reflect the change!

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@gmx.de

--- Comment #1 from Oliver Brinzing <***@gmx.de> ---
Created attachment 145341
--> https://bugs.documentfoundation.org/attachment.cgi?id=145341&action=edit
test case

i can reproduce with attached spreadsheet:

- open spreadsheet
- drag cell C2 out of the sum range, for example to D2
- C6/C8 will show: 13
- undo: Ctrl + Z
- C6 shows 35, but C8 is 13

a hard recalc Ctrl + Shift + F9 is needed.

notice: no problem using cut & paste

Version: 6.1.2.1 (x64)
Build-ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc:

Version: 6.2.0.0.alpha0+ (x64)
Build ID: bc32f789bb3c079eba9c07275866a7b13f76dbcc
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc: threaded

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
OS|Linux (All) |All

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|6.0.6.2 release |5.4.7.2 release
Hardware|x86-64 (AMD64) |All

--- Comment #2 from Oliver Brinzing <***@gmx.de> ---
already reproducible with:

Version: 5.4.7.2
Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 4; BS: Windows 6.2; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: single

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Version|5.4.7.2 release |4.4.7.2 release

--- Comment #3 from Oliver Brinzing <***@gmx.de> ---
already reproducible with

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

--- Comment #4 from Oliver Brinzing <***@gmx.de> ---
but *not* reproducible with

AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

--- Comment #5 from Oliver Brinzing <***@gmx.de> ---
*not* reproducible with

Version 3.6.7.2 (Build ID: e183d5b)

[b***@bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120270

Oliver Brinzing <***@gmx.de> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |109324


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109324
[Bug 109324] [META] Calculate bugs and enhancements