Bug 64174 - EDITING: Search and replace with regular expression \<' says Search key not found
Summary: EDITING: Search and replace with regular expression \<' says Search key not f...
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-05-03 07:03 UTC by dany franck
Modified: 2013-06-17 06:24 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description dany franck 2013-05-03 07:03:15 UTC
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
Comment 1 yhmyhm 2013-05-29 22:14:50 UTC
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!
Comment 2 Eike Rathke 2013-06-16 14:55:24 UTC
\< 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.
Comment 3 dany franck 2013-06-17 06:24:42 UTC
Thanks a lot for this informative response.