Applying a filter to a text column using the "form based filter", LIKE A* AND LIKE *e does match entries starting with A and ending with e. The actual filter string applied to the form is: ( "Name" LIKE 'A%' AND "Name" LIKE '%e' ) When going back to the UI of the form based filter, the active filter condition reads: LIKE A* AND *e which of course is wrong and needs to be fixed by the user after editing the active filter.
Could confirm the buggy behavior. Version: 25.8.4.2 (X86_64) Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Also confirmed with LO 7.4.7.2 on the same system. Seems it never works…
For what it's worth, OpenOffice does it right.