[Libreoffice-bugs] [Bug 139886] New: CALC: "Replace All" in "Current selection only" changes selection in the table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139886

            Bug ID: 139886
           Summary: CALC: "Replace All" in "Current selection only"
                    changes selection in the table
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bugreporter at public-files.de

Given a table with the following content starting from cell A1 down to A6:

A
A
B
C
A
B

Select area A1 to A5 (!!! don't select A6 !!!).

-> Edit -> Find and Replace...

-> Find: A
-> Replace: X
-> [x] Current selection only
-> "Replace All"

The values in the cells A1, A2, A5 changed to "X".

Optionally one gets now a "Search Results" dialog that shows the cells hit by
the replace: $A$1, $A$2, $A$5

Note: The selection in the table has changed to only these cells, too!

Close the "Search Results" dialog (not the "Find & Replace" dialog!)

Note: Sometimes now the mark in "[ ] Current selection only" has gone! But I
cannot reproduce under which circumstances.

>From now on there are two options:

Option 1:
---------
-> Find: B
-> Replace: Y
-> [x] Current selection only (!!!)
-> "Replace All"

leads to the message "Search key not found" above the "Replace" input field
even though cell A3 should be found regarding to my initial selection (which I
didn't change so far).

Option 2:
---------
-> Find: B
-> Replace: Y
-> [ ] Current selection only (!!!)
-> "Replace All"

would change the value in cell A3 -- but in cell A6, too, even though cell A6
doesn't belong to my initial selection (which I didn't change so far).

The "Search Results" dialog shows the cells hit by the replace: $A$3, $A$6.

Note: The selection in the table has changed to only these cells again!


There are two reasons to report this behaviour:

1) Maybe users are not aware of the change of selection at all -- maybe they
lose track of it since the selected area is quite large. If they just change
the values in the "Find & Replace" dialog and proceed without re-establishing
the selection they will probably get a non-intended result.

2) The need to re-establish the selection means to leave the "Find & Replace"
dialog which is even uncomfortable whatever the selection is sized and gets
more uncomfortable if the selection is huge.


Best regards
Ian S.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210124/36f11640/attachment.htm>