Ask Your Question
1

libreoffice calc wildcard advanced filter

asked 2018-11-23 14:41:45 +0200

fck gravatar image

updated 2018-11-27 18:48:25 +0200

EasyTrieve gravatar image

I cannot get calc to filter with the following wildcad condition : "Hom*" (Not with the quotes). When I filter with "Home" it would work fine.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-11-23 23:06:33 +0200

m.a.riosv gravatar image

updated 2018-12-02 02:52:01 +0200

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.

edit flag offensive delete link more

Comments

Thanks for response. Both "Calculate - Enable wildcards in formulas" and "Search criteria = and <> must apply .." are set as recommended for Excel compatibility. No lines are show. When remove wildcards and filter for say Paul, it works. It works in old xls.

Below is the is my test data and filter a". Agent Product Amount
Paul AA 10
Jan BB 20
Pieter CC 30
Frans BB 40
FILTER
Agent Product Amount *a

Agent Product Amount

fck gravatar imagefck ( 2018-12-01 17:27:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-11-23 14:41:45 +0200

Seen: 110 times

Last updated: Dec 02 '18