Bug 160903 - Advanced Filter help page needs description of "criteria" syntax
Summary: Advanced Filter help page needs description of "criteria" syntax
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:24.8.0
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-02 07:47 UTC by Mike Kaganski
Modified: 2024-05-13 19:12 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 2024-05-02 07:47:59 UTC 
https://help.libreoffice.org/24.2/en-US/text/scalc/01/12040300.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/advancedfilterdialog/dialog-action_area1

The criteria used there use the same syntax as those used in database functions [1], or in e.g. SUMIFS [2]. These all need to have consistent description of the criterion syntax - see bug 131995, where the documentation was introduced.

[1] https://help.libreoffice.org/24.2/en-US/text/scalc/01/04060101.html?DbPAR=CALC
[2] https://help.libreoffice.org/24.2/en-US/text/scalc/01/func_sumifs.html?DbPAR=CALC
Comment 1 Commit Notification 2024-05-05 14:46:24 UTC 
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/5217d34ba89beaa113bb30e4eb76b6c2c0a7ee26

tdf#160903 Advanced Filter help page needs description of "criteria" syntax