Bug 91598 - Undo can lead to wrong results from formulas
Summary: Undo can lead to wrong results from formulas
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-25 05:45 UTC by sworddragon2
Modified: 2016-09-27 04:54 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description sworddragon2 2015-05-25 05:45:09 UTC
Similar to https://bugs.documentfoundation.org/show_bug.cgi?id=77559 I'm also noticing that using Undo in Calc can lead to wrong data. Here are the steps to reproduce:

1. Open a new Calc document.
2. Write in A1 "5".
3. Write in A2 "10".
4. Write in A3 "20".
5. Write in B2 "=SUM(A$1:A2)".
6. Write in B3 "=SUM(A$1:A3)".
7. Make a right click on row 3 and select "Insert Rows Above".
8. Select A4 and B4 and copy it.
9. Select A3 and paste the cells.
10. Undo the last action.


B4 shows now 55 while it should show 35.
Comment 1 Jean-Baptiste Faure 2015-05-25 06:29:58 UTC
Reproducible for me with Version: 4.4.4.0.0+
Build ID: 26c6602c9036e12e0d228b6f5377f47fde5a530f
Ubuntu_15.04_x86-64
Locale : fr_FR.UTF-8

If you continue:
10. Undo the last action.
11. Undo the previous the last action
12. Redo
13. Redo
14. Undo: should be the same as 10. This time it works as expected.

Best regards. JBF
Comment 2 QA Administrators 2016-09-20 09:46:20 UTC Comment hidden (obsolete)
Comment 3 Jean-Baptiste Faure 2016-09-27 04:54:49 UTC
Not reproducible anymore in LO 5.2.3.0+ and current master, both built at home under Ubuntu 16.04 x86-64.

Closing as WorksForMe. Please, feel free to reopen if you disagree.

Best regards. JBF