Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Have you selected wildcards in Menu/Tools/Options/LibreOffice calc/Calculate - Enable wildcards in formulas.

By default LO uses regular expressions List of regular expressions more powerfull and complex than wildcards, but when xlsx/xls are opened wildcards are enable.

Have you selected wildcards in Menu/Tools/Options/LibreOffice calc/Calculate - Enable wildcards in formulas.formulas?

By default LO uses regular expressions List of regular expressions more powerfull and complex than wildcards, but when xlsx/xls are opened wildcards are enable.

Have you selected wildcards in Menu/Tools/Options/LibreOffice calc/Calculate - Enable wildcards in formulas?

By default LO uses regular expressions List of regular expressions more powerfull and complex than wildcards, but when xlsx/xls are opened wildcards are enable.

Edited 20181202

Looks wildcard are only available for functions not for filters, reported a bug:
CALC: Make available wildcards with Standard and Advanced filters like in find & replace.