How do I match a beginning of the cell in find-replace dialog of Calc?
In regexp mode, I’d expect ^ to match that, but it does not work:
The doc does not give any hints: List of Regular Expressions - LibreOffice Help
How do I match a beginning of the cell in find-replace dialog of Calc?
In regexp mode, I’d expect ^ to match that, but it does not work:
The doc does not give any hints: List of Regular Expressions - LibreOffice Help
In regexp mode, ^ works. If it does not work for you, please provide details.
^.
→ ''&
Thanks, it works. But isn’t it weird? One can use an end-of-line anchor directly, $, but for beginning of line one must to carry a group,
No, it isn’t weird. When looking for $
, the result (the characters in the line that might be replaced) is the trailing newline, which may be removed (it’s for Writer; in Calc, it’s also searchable - possibly because the machinery is common for the components). For the beginning of the line, there’s nothing real that is represented by ^
which can be the result of the search.