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.
No cell, nor string, nor pattern is found
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??
User Profile Reset: Yes
OpenGL enabled: Yes
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
*** This bug has been marked as a duplicate of bug 135538 ***