Problem description: I try to replace ' on beginning of a cell content using the regular expression \<' and the programm finds nothing Steps to reproduce: 1. cell content = 'essai 2. search and replace \<' Current behavior: search key not found Expected behavior: found and replaced All was OK on 4.02 Operating System: Windows 7 Version: 4.0.3.1 rc Last worked in: 4.0.2.2 release
I have amended a xlsm file that created by Microsoft office 2007 then saved by Libre office, after that this file cannot be opened by Microsoft office 2007!
\< is not "the beginning of cell content" but a word boundary, citing from the old online help: Only finds the search term if it appears at the beginning of a word. For example, "\<book" finds "bookmark", but not "checkbook". That this worked with ' was a bug.. The beginning of content actually is ^ instead of \< As of 4.0 LibreOffice uses the ICU regular expression engine that in some details has a different syntax (Perl regular expression syntax) and doesn't know \< anymore but instead uses \b, the old \< for convenience is emulated as \b followed by a look-ahead word-char. Anyhow, ^' is the correct syntax to find the ' content at the beginning.
Thanks a lot for this informative response.