Download it now!
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: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks:
 
Reported: 2020-07-07 15:23 UTC by Pierre Marty
Modified: 2020-08-31 15:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


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

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
Description:
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:

Version: 6.4.5.2
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:

Version: 7.1.0.0.alpha0+
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 4.0.6.2 and LO 5.1.1.3.

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

------------

$> ./opt/program/soffice --version
LibreOfficeDev 4.1.0.0.beta1 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 4.2.0.0.beta1.
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:
https://gerrit.libreoffice.org/c/core/+/101535
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:
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=ac84ffb3c90bb5788608eadf2177f587021daaad..4c99a427ee4adaeddb2682c192384bad21d9d09b
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