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

            Bug ID: 145856
           Summary: The ^ expression is not matching anything in Find and
                    Replace
           Product: LibreOffice
           Version: 7.2.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
When trying to put anything at the beginning of each string selected, doing a
Find And Replace with ^, is not working. It does not match anything.
It's weird as the $ expression is working fine for putting anything at the end
of each string.
Why Calc is not matching anything? ^ is as valid as $, or am I wrong?

I'm using Linux Fedora 35 but it's not working in Windows 10 either. I just
tested it.

Steps to Reproduce:
1.Type Ctrl+H to open "find and replace"
2.In the "Find" field type '^' (regular expression for matching beginning of
string) and in the "Replace" field put anything you want to put at the
beginning of each filled cell
3.In "Other Options" activate "Regular Expressions"
4. Press the "Find Next" button, you will see that Calc is not able to find
anything. This is a bug, as ^ is a valid regular expression that matches a
beginning of string. If you try with $, you will notice that Calc will match
all the end of strings. So Calc is misbehaving with ^ as regular expression
pattern. 

Actual Results:
No cell, nor string, nor pattern is found

Expected Results:
It should have matched all filled cells, as ^ is a valid regular expression for
beginning of string. Please, notice that $ works good when trying to match end
of string. So, why is ^ not working??


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.2.2.2
Build ID: 20(Build:2)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

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

Reply via email to