Bug 143438

Summary:	Advanced filter documentation needs clarification of order of evaluation of regular expression
Product:	LibreOffice	Reporter:	Mike Kaganski <mikekaganski>
Component:	Documentation	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	olivier.hallot
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=140613 https://bugs.documentfoundation.org/show_bug.cgi?id=140836
Whiteboard:
Crash report or crash signature:		Regression By:

Description Mike Kaganski 2021-07-19 16:49:04 UTC

Additional filter options help page [1] describes the option of using regular expressions in filter definition. But there's no mention that regular expression match is only attempted when the Value field data can't be converted to number; this is absolutely same as mentioned e.g. for MATCH [2] and the like.

The documentation problem lead to e.g. tdf#140613 and tdf#140836.

[1] https://help.libreoffice.org/7.2/en-US/text/scalc/01/12040201.html?&DbPAR=CALC
[2] https://help.libreoffice.org/7.2/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407