You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/01/19 17:34:43 UTC
[Issue 126049] New: Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
https://issues.apache.org/ooo/show_bug.cgi?id=126049
Issue ID: 126049
Issue Type: DEFECT
Summary: Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: jesse@kindwall.me
I have a bunch of strings that look something like this stored in several cells
in a spreadsheet:
"Thing-1!!!/Thing-2!!!/Thing-3/Thing-4!!!"
I want to make sure every numbered Thing ends with three exclamation marks, and
as you can see above, they are missing from Thing-3. So I attempt a regex
Search/Replace with a lookbehind like this:
Search for
(?<=-\d)/
Replace with
!!!/
So that should find all forward slashes that are immediately preceded by a
hyphen and a single digit, then replace only the slash with three exclamation
marks and another slash.
Tried this exact scenario in OpenOffice Writer and it worked. However using the
exact same search string and regex in OpenOffice Calc, I get "Search key not
found."
Similarly, if I try to search the same string with this regex:
Thi(?=ng)
It matches the first three letters of each "Thing" in Writer, but in Calc I
again get "Search key not found."
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126049] Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126049
jesse@kindwall.me changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|All |Windows 7
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126049] Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126049
hanya <ha...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #3 from hanya <ha...@gmail.com> ---
The problem cause was reported in issue 126050.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126049] Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126049
hanya <ha...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |hanya.runo@gmail.com
--- Comment #1 from hanya <ha...@gmail.com> ---
Both cases works on AOO 4.1.1, Xubuntu 14.04 64bit.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126049] Regex Search/Replace in Calc does not support
lookbehinds/lookaheads
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126049
--- Comment #2 from jesse@kindwall.me ---
Ok, for some reason its working for me now. I've been trying for the last
several hours to pin down what circumstances caused this to fail for me before,
but I've had no luck.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.