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

            Bug ID: 162176
           Summary: Wildcards in Find and Replace: the position of
                    wildcard given in the string in the Find box is not
                    respected
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 195478
  --> https://bugs.documentfoundation.org/attachment.cgi?id=195478&action=edit
test file using wildcard for formula and testing Find and Replace

With bug 72196 the use of Wildcards has been implemented.
Opening the attachment in
https://bugs.documentfoundation.org/show_bug.cgi?id=38125#c7 shows that it
works correct in formula.

However, Find and Replace does not respect the position of wildcard given in
the string in the Find box.

Added another example to the attachment.
In that file, searching in the range A17:A21 for '*es' (without the quotes)
should have 3 matches.
Searching for 'es*' should have 2 matches.
However both '*es' and 'es*' give 5 matches, where the formula Countif does the
correct thing.

Checked in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d8c694b5d64b05da8c515e4ffe23c4bcc2376b0f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
But maybe, if it is an implementation error (in e.g. the commit mentioned here
https://bugs.documentfoundation.org/show_bug.cgi?id=72196#c14) then it should
be from version 5.2

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to