Bug 134620 - [Calc] [EDITING / FORMATTING] Undoing a find & replace breaks the "automatic calculation"
Summary: [Calc] [EDITING / FORMATTING] Undoing a find & replace breaks the "automatic ...
Status: RESOLVED DUPLICATE of bug 141619
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Find-Search Undo-Redo
  Show dependency treegraph
Reported: 2020-07-07 15:23 UTC by Pierre Marty
Modified: 2024-02-26 10:52 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Testing FIle (9.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-07 15:28 UTC, Pierre Marty
details of the strace command (75.44 KB, text/plain)
2020-07-16 15:02 UTC, Pierre Marty

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre Marty 2020-07-07 15:23:35 UTC
After undoing a "find & replace all" the cells with an automatic result are stuck with the result obtained after the find & replace whereas the undo action has been working.

Steps to Reproduce:
1. Enter 513 in cell A1
2. In cell B1 enter "=A1/12" (it will display 42.75)
3. Hit Ctrl+H
4. Find 513
5. Replace all by 625
6. The value of B1 is now 52.0833333
7. Hit Ctrl+Z

Actual Results:
8. The value of B1 is still 52.0833333

Expected Results:
8. B1 should have a value of 42.75

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Tested on:

Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Pierre Marty 2020-07-07 15:28:41 UTC
Created attachment 162761 [details]
Testing FIle

Here is a file with some examples.
You can try with any value, the bug will always occur.
Comment 2 Pierre Marty 2020-07-07 16:06:19 UTC
Also experimented on:

Build ID: 088b7f419f48f3390aac22587bbd92e9e027d5b1
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 Eike Rathke 2020-07-08 09:18:30 UTC
Confirmed. It lacks one recalculation of the Undo value, entering a new value in A1 after that recalculates.
Comment 4 Eike Rathke 2020-07-08 09:20:49 UTC
Found already in 5.3, don't know if earlier. Not in OOo3.3
Comment 5 Pierre Marty 2020-07-16 15:02:18 UTC
Created attachment 163125 [details]
details of the strace command

After a quick bibisection, the bug seems to be introduced between LO and LO

I'm experiencing some issues while starting the versions between those mentioned above...


$> ./opt/program/soffice --version
LibreOfficeDev 3a2c2d2417101e45fe07cfd8358acf2204a98f3

$> ./opt/program/soffice

[[ LO Loading splashscreen display ]]

javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx

** (soffice:27006): WARNING **: 16:53:04.815: Unknown type: GailWindow

[[ HERE the application stops and the progress bar isn't complete ]]

$> strace ./opt/program/soffice

... [see file attached to more details]
Comment 6 Pierre Marty 2020-07-17 08:35:00 UTC
The bug was introduce in LO
Comment 7 Pierre Marty 2020-08-28 10:05:42 UTC
Hi all,

There is a patch for this issue.

It can be reviwed here:
Comment 8 Aron Budea 2020-08-29 23:04:07 UTC
Bibisect results in repo bibisect-42max, the following range is a single commit in the bibisect repo:
Comment 9 Pierre Marty 2020-08-31 15:15:57 UTC
(In reply to Pierre Marty from comment #7)
> Hi all,
> There is a patch for this issue.
> It can be reviwed here:
> https://gerrit.libreoffice.org/c/core/+/101535

Update at the same link
Comment 10 Kevin Suo 2024-02-19 07:56:24 UTC
Still reproducible in:

Version: (X86_64) / LibreOffice Community
Build ID: 95e6f942b3fa5c6f3e5473ac474a4702ab815502
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN
Calc: threaded

Adding bug 141619 as see also (may be a duplicate, but I am not very sure).
Comment 11 Kevin Suo 2024-02-26 10:49:03 UTC
Following the similar bisect steps as in

I have bisected this bug to the same commit as in bug 141619, i.e.

commit c008dc483f8c6840803983e7e351cec6fdd32070
Author: Kohei Yoshida <kohei.yoshida@gmail.com>
Date:   Fri May 24 11:52:18 2013 -0400

    Switch to using multi_type_vector for cell storage.

Since they  appear to be the same bug behaviour (formular reference > find and replace > undo > auto calculate not updated), I mark this as a duplicate of bug 141619.

*** This bug has been marked as a duplicate of bug 141619 ***