How to undo find and replace?

[librelibre99]

Hi,

I used “find and replace” to change 25 cells in a Calc document. I made a mistake: I forgot to check “entire cells”, hence several cells I did not mean to replace were replaced.

How do I undo this? Using “Undo” reverted the changes one by one, and only up to ~8.

Version: 7.3.3.2 / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Thanks

[EarnestAl]

That is odd.

• If I use Find and Replace > Replace All to change 41 instances then a single Ctrl+Z undoes all replacements.
• If I replace individually for 30+ instances then the same number of Ctrl+Z undoes them all.

In the event of a mishap I find closing without saving (or File > Reload) returns me to my last save, from where I can normally remember what to add back.

[EDIT]
Following the method given in this Help link, Undo I see that I have 100 Undo steps available which I guess is default…

[librelibre99]

Hi EarnestAl,

Thank you for your reply. I don’t know how to explain this, but this Undo feature is working today. I could swear it wasn’t working yesterday. What is more, In the Edit Menu, Undo, Redo, and Repeat list, after a colon, what type of action they will perform (e.g. Undo: Replace). I had never seen this before!

In any case, it’s working. Thank you very much!

[erAck]

@librelibre99

What is more, In the Edit Menu, Undo, Redo, and Repeat list, after a colon, what type of action they will perform (e.g. Undo: Replace). I had never seen this before!

It’s there for ages.