Bug 129739

Summary: Undo/Redo don't always update table formulas on Writer
Product: LibreOffice Reporter: Guildem <gdemurge>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: 79045_79045
Priority: medium    
Version: 6.3.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 105948, 122755    
Attachments: Bug test document

Description Guildem 2020-01-02 13:59:05 UTC 
Description:
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:
Version: 6.3.4.2.0+
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 6.3.3.2

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: 7.4.0.0.alpha1+ / 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
Comment 6 Steve271 2024-05-21 03:32:43 UTC 
This bug is still present in:

Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: d0702a3f17c1fbd1b8ffb9ca0b275943e1a1f442
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded


for me specifically: 

I can edit the cell values and undo will remember the values before I changed them. 

If I undo all the changes and then click anywhere outside the table I won't be able to redo the changes (option is grayed out in edit tab and shortcut key won't work).

in my previous step, if I don't click anywhere outside the table I will be able to redo the changes