Bug 143438 - Advanced filter documentation needs clarification of order of evaluation of regular expression
Summary: Advanced filter documentation needs clarification of order of evaluation of r...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-07-19 16:49 UTC by Mike Kaganski
Modified: 2021-09-20 09:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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