[Libreoffice-bugs] [Bug 113977] Implement REGEXEXTRACT function

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Jan 31 09:17:12 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=113977

--- Comment #6 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
(In reply to Eike Rathke from comment #5)
> (In reply to Dan Dascalescu from comment #4)
> > Google Sheets supports REGEXEXTRACT.
> Out of curiosity: when saving/exporting/downloading such a Google Sheet as
> ODF, what is written as function name?

<table:table-row table:style-name="ro1"><table:table-cell
table:formula="of:=IFERROR(__xludf.dummyfunction("REGEXEXTRACT( A1,
""a."" )");"ab")" office:value-type="string"
office:string-value="ab" calcext:value-type="string">

with a common function looking like
<table:table-cell table:formula="of:=SUM(1;2;3)" office:value-type="string"
office:string-value="6" calcext:value-type="string">

If this function is to be added, we should think about REGEXMATCH and
REGEXREPLACE as well. (I'm interested in giving it a try, but only if there are
more people saying the enhancement is wanted than just Dan Dascalescu and me.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180131/fcbeb1c8/attachment.html>


More information about the Libreoffice-bugs mailing list