[Libreoffice-bugs] [Bug 119488] New: [feature reuqest] Provide REGEXSEARCH/REGEXEXTRACT function to avoid performance issues

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119488
           Summary: [feature reuqest] Provide REGEXSEARCH/REGEXEXTRACT
                    function to avoid performance issues
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: maddes+docfoundation at maddes.net

If a document uses a lot of SEARCH and VLOOKUP functions, then enabling regular
expressions globally in a Calc document leads to an extreme performance hit.
Most of the time it turns out that only the SEARCH function needs RegEx support
to get a value, while the VLOOKUPs just search for that found value.

Providing a REGEXSEARCH function, as done by Google Docs' REGEXEXTRACT [1],
would help to keep the performance hit low, as RegEx would only be used when
necessary. THis would also avoid additional escaping in VLOOKUPs.

Thanks for reading
Maddes

[1] https://support.google.com/docs/answer/3098244

-- 
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/20180824/c03c1551/attachment-0001.html>