Bug 160903

Summary:	Advanced Filter help page needs description of "criteria" syntax
Product:	LibreOffice	Reporter:	Mike Kaganski <mikekaganski>
Component:	Documentation	Assignee:	Olivier Hallot <olivier.hallot>
Status:	RESOLVED FIXED
Severity:	normal	CC:	olivier.hallot
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=131995 https://bugs.documentfoundation.org/show_bug.cgi?id=160902
Whiteboard:	target:24.8.0
Crash report or crash signature:		Regression By:

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