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@lists.freedesktop.org
Reporter: maddes+docfoundat...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs