[Libreoffice-bugs] [Bug 112275] Find & Replace all for cell styles in empty cells shows an empty results window

[bugzilla-daemon at bugs.documentfoundation.org]

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

stragu <stephane.guillou at member.fsf.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |stephane.guillou at member.fsf
                   |                            |.org

--- Comment #4 from stragu <stephane.guillou at member.fsf.org> ---
I can reproduce with:

Version: 6.4.0.1
Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

To me, seeing a "search results" window makes sense, because searching is one
part of the whole "Replace All" process: you first need to search and find
matches, then replace them.

The issue is that the window show 0 results, and the style has *not* been
replaced in the sheet. All the cells still have the "Default" style.

You can also try it with one cell (with no cell selection):

1. Assign the "Accent 1" style to a cell
2. Open Find & Replace
3. Tick "Cell Styles"
4. Find "Accent 1" and replace it with "Bad", for example

Nothing happens. But with all my testing, I get seemingly inconsistent results:

* Sometimes, there are no results but the cell selection has moved to the
relevant cells that have the searched style. So they are actually found and
given focus, but they are not listed as matches in the search results??
* Sometimes, selecting an area and searching in "Current selection only" gives
the expected result: style applied to the matches.
* Sometimes, selecting an area and using Replace All will replace for the whole
selection, not the expected matches only.
* Usually, I get 0 results in the "Search results" window, but in some cases, I
get one single match (even though there were more cells than that, and Replace
All replaced the whole of the selection anyway...).

Looks like there's quite a bit to fix with that!

The behaviour is no different in:

Version: 6.3.4.2
Build ID: 1:6.3.4-0ubuntu0.18.04.1~lo2
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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/20200107/5d4ff250/attachment-0001.htm>