[Libreoffice-bugs] [Bug 120013] New: Cut/Paste doesn't force auto recalc; running totals incorrect

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

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

Bug ID: 120013
Summary: Cut/Paste doesn't force auto recalc; running totals
incorrect
Product: LibreOffice
Version: 6.0.1.1 release
Hardware: x86-64 (AMD64)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@gmail.com

Description:
In several circumstances, a cut-and-paste from one row to another doesn't
invoke an automatic recalc, leaving total columns incorrect until manual recalc
is performed. Problem reproducible and example spreadsheet attached.

Steps to Reproduce:
1. See attached spreadsheet
2. Highlight cells A8-D8
3. Cut cells using keyboard shortcut
4. Paste into cells A4-D4 using keyboard shortcut - do not hit return after
paste
5. Click on any other cell in spreadsheet.
6. Note total column E is incorrect.
7. Force manual recalc with shift-F9 (or whatever is your shortcut).
8. Note totals are now correct.

Actual Results:
Column E totals are not correct until recalc is forced.

Expected Results:
Column E totals should be correct after paste even without recalc.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
using

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

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

--- Comment #1 from David Ruggiero <***@gmail.com> ---
Created attachment 145073
--> https://bugs.documentfoundation.org/attachment.cgi?id=145073&action=edit
Example .ods spreadsheet file to illustrate bug.

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

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

--- Comment #2 from David Ruggiero <***@gmail.com> ---
Note this bug is very similar to the report in <a
href="https://bugs.documentfoundation.org/show_bug.cgi?id=99322">Bug 99322</a>,
which was already reported as fixed.

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

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

--- Comment #3 from David Ruggiero <***@gmail.com> ---
Note that if <return> is hit after the paste, *some* totals are updated in the
running total column (E) - but not all. Behavior is different...but display is
still incorrect until a manual recalc is performed.

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

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

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

What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |***@gmx.de
OS|Mac OS X (All) |All
Ever confirmed|0 |1

--- Comment #4 from Oliver Brinzing <***@gmx.de> ---
i can confirm this issue with:

Version: 6.1.1.2 (x64)
Build-ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
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: 7595fce391ba2aca49db87c93006302d0c2a64f2
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: de-DE (de_DE); Calc: threaded

E4 is 2200 but should be 1200

a full hard recalc Shift+Ctrl+F9 is needed to update the spreadsheet

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

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

--- Comment #5 from Oliver Brinzing <***@gmx.de> ---
some remarks:

- copy cell range A8:D8 to A4 will work

- after removing all $ from formula's in row 3
it will work even with cut and paste

i think this issus maybe has the same root cause as reported in:

Lonely SUM formula fails to update, and thus can lead
to a treacherously wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=119623

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

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

--- Comment #6 from David Ruggiero <***@gmail.com> ---
Updating on my own comment #3 -

- If <return> is not hit after the paste, running total column appears to be
incorrect from the same row that the paste happened into, onwards.

- If <return> IS hit after the paste, running total column appears to be
recalculated only up until the same row as the *cut* occurred from; it's wrong
after that.

- Either way a force recalc is needed to insure correct results are displayed
fully.


I agree the $ static references are the key here. We often use running total
columns (eg A$1:A${n} where 'n' is the current row) and see this same behavior
often when using them.

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

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

--- Comment #7 from David Ruggiero <***@gmail.com> ---
Sorry, last paragraph should have read:

I agree the $ static references are the key here. We often use running total
columns (eg A$1:A{nn} where 'nn' is the current row) and see this same behavior
often when using them.

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

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

David Ruggiero <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|Cut/Paste doesn't force |Cut/Paste doesn't initiate
|auto recalc; running totals |recalc of some/all affected
|incorrect |cells if absolute
| |references are used

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

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

David Ruggiero <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Summary|Cut/Paste doesn't initiate |After cut/paste, cells with
|recalc of some/all affected |absolute references are not
|cells if absolute |recalculated; displayed
|references are used |results are wrong until
| |manual recalc performed

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

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
Hardware|x86-64 (AMD64) |All
Keywords| |bibisectRequest, regression
Version|6.0.1.1 release |5.1 all versions
CC| |***@libreoffice.org

--- Comment #8 from Xisco Faulí <***@libreoffice.org> ---
Reproduced back to

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.10; Render: default;

but not in

Version: 5.0.0.0.alpha1+
Build ID: 0db96caf0fcce09b87621c11b584a6d81cc7df86
Locale: ca-ES (ca_ES.UTF-8)

it needs to be bisected with 5-1 repo

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

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

Xisco Faulí <***@libreoffice.org> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=12
| |0660

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

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
CC| |***@redhat.com,
| |***@suomi24.fi
Keywords|bibisectRequest |bibisected, bisected

--- Comment #9 from Buovjaga <***@suomi24.fi> ---
Bisected with win32-5.1 to
https://cgit.freedesktop.org/libreoffice/core/commit/?id=2f6a06856ad8df0c11a112d1e457b408e9a7af1d
tdf#90694 reset group area listeners when splitting group

Adding Cc: to Eike Rathke

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

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

--- Comment #10 from Oliver Brinzing <***@gmx.de> ---
(In reply to Oliver Brinzing from comment #5)

Post by b***@bugs.documentfoundation.org
Lonely SUM formula fails to update, and thus can lead
to a treacherously wrong result
https://bugs.documentfoundation.org/show_bug.cgi?id=119623

i have to correct me: bug 119623 is fixed on current master,
but this issue is still reproducible

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

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

Aron Budea <***@caesar.elte.hu> changed:

What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.documentfounda
| |tion.org/show_bug.cgi?id=90
| |694

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

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

Korrawit Pruegsanusak <***@gmail.com> changed:

What |Removed |Added
----------------------------------------------------------------------------
Attachment #145073|application/octet-stream |application/vnd.oasis.opend
mime type| |ocument.spreadsheet

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

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

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

What |Removed |Added
----------------------------------------------------------------------------
Version|5.1 all versions |4.4.7.2 release

--- Comment #11 from Oliver Brinzing <***@gmx.de> ---
(In reply to Buovjaga from comment #9)

Post by b***@bugs.documentfoundation.org
Bisected with win32-5.1 to
https://cgit.freedesktop.org/libreoffice/core/commit/
?id=2f6a06856ad8df0c11a112d1e457b408e9a7af1d

i can confirm this issue *already* with

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_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=120013

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

Version 3.6.7.2 (Build ID: e183d5b)