<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <p> <div> <b><a class="bz_bug_link bz_status_NEW " title="NEW - Implement REGEXEXTRACT function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113977#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Implement REGEXEXTRACT function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113977">bug 113977</a> from <span class="vcard"><a class="email" href="mailto:winfrieddonkers@libreoffice.org" title="Winfried Donkers <winfrieddonkers@libreoffice.org>"> <span class="fn">Winfried Donkers</span></a> </span></b> <pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=113977#c5">comment #5</a>) <span class="quote">> (In reply to Dan Dascalescu from <a href="show_bug.cgi?id=113977#c4">comment #4</a>) > > Google Sheets supports REGEXEXTRACT. > Out of curiosity: when saving/exporting/downloading such a Google Sheet as > ODF, what is written as function name?</span > <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.)</pre> </div> </p> <hr> <span>You are receiving this mail because:</span> <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>