Bug 129739 - Undo/Redo don't always update table formulas on Writer
Summary: Undo/Redo don't always update table formulas on Writer
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Undo-Redo Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2020-01-02 13:59 UTC by Guildem
Modified: 2022-05-26 14:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Bug test document (10.43 KB, application/vnd.oasis.opendocument.text)
2020-01-02 15:45 UTC, Guildem

Note You need to log in before you can comment on or make changes to this bug.
Description Guildem 2020-01-02 13:59:05 UTC
If a document contains a table with formulas (ex: lines of numbers and a final line with a formula =sum(...) ), and some number is changed, then undo/redo, the formulas using this number aren't always updated.

The undo/redo are fired by shortcut or Edit menu.

Steps to Reproduce:
1. create a writer document with a table
2. add numbers to the table and a sum formula of those numbers at the end
3. change a number (formula is updated), then undo/redo the change (formula stays the same)

Actual Results:
On the undo/redo, sometimes only formula is updated, sometimes only edited number is updated.

Expected Results:
On the undo/redo, formula and edited number should be updated.

Reproducible: Sometimes

User Profile Reset: No

OpenGL enabled: Yes

Additional Info:
Build ID: 6.3.4-1
Threads CPU : 8; OS : Linux 5.3; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 1 Roman Kuznetsov 2020-01-02 15:35:38 UTC
Guildem, please attach a file with example of your table
Comment 2 Guildem 2020-01-02 15:45:21 UTC
Created attachment 156904 [details]
Bug test document

Document to test bug, with internal instructions.
Comment 3 Roman Kuznetsov 2020-01-02 16:10:12 UTC
confirm in

Undo should remember values
Comment 4 QA Administrators 2022-01-02 03:55:33 UTC Comment hidden (obsolete)
Comment 5 Ezinne 2022-05-26 14:42:11 UTC
The formula result is not updated immediately after I click undo or when I change the value. 

It is updated, in both cases, when I click on another cell.

Version: / LibreOffice Community
Build ID: 7ee7e966bd123fc571144b08bc07b1536a2e23e9
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded