Bug 133480 - Make "current selection" persistent in F/R dialogue
Summary: Make "current selection" persistent in F/R dialogue
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Reported: 2020-05-28 16:04 UTC by Geoffrey Skinner
Modified: 2020-06-04 13:00 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Geoffrey Skinner 2020-05-28 16:04:24 UTC
This is similar, but I think a different request than #132031, and perhaps should be classed as a bug

I often work with very large spreadsheets and perform repeated F/R operations. I have frequently been brought to a halt and sometimes have to restart LibreOffice (and lose some amount of recent work) when the current selection box changes to unchecked and I don't spot it. This happens most noticeably (only?) after reverting a change that didn't give me the desired results. The box will change to unchecked even if the same column or row is still selected. If one is doing a F/R operation, the result might be adding a specific string to every single cell in a 4 million cell sheet, which tends to bring my computer to a halt, and doubly so if I attempt to undo the operation. Having the box state persistent -- at least after a reversion -- would make using F/R much safer.

Keywords: EDITING, UI

Steps to Reproduce:
1. Select cells for F/R
2. Open F/R dialogue
3. Perform F/R dialogue, check 'current selection" box and make changes
4. Revert changes
5. Repeat F/R -- same cells are highlighted, but current selection box changes to unchecked
6. Calc locks (and sometimes computer, depending on how many resources are required)
7. When F/R finally completes, revert changes
8. Calc locks (and sometimes computer, depending on how many resources are required)

Actual Results:
Current selection box flips to unchecked and data is changed across entire spreadsheet

Expected Results:
Current selection box stays selected and only selected cells are affected by F/R

Reproducible: Always

User Profile Reset: No

Additional Info:
The same issue is present for both F/R and Find All, but obviously, without the same consequences to the data; Calc does, however, get stuck in the same way. This has been an issue for as long as I've been using Calc
Comment 1 Telesto 2020-05-29 21:34:57 UTC
FWIW: : the performance of F&R is under investigation: bug 126109

And doubly so if I attempt to undo the operation -> which version of LibreOffice do you use.. or is this a long standing issue? If so, please create an additional bug report.. Performance flaws are bugs too ;-)
Comment 2 Heiko Tietze 2020-05-30 08:44:23 UTC
The checkbox status depends on whether you have a selection or not. So if A1:A4 is selected and you undo the replacement it will still be A1:A4. If you select A5:A8, the checkbox will remain checked. It goes off when you click a single cell or a column header (not in case of rows). 

I don't see how we can change this as the behavior is needed.
Comment 3 Heiko Tietze 2020-06-04 13:00:17 UTC
No further input so I'll resolve the ticket as WONTFIX.