When filtering informations on a pivot table on LibreOffice Calc 5.0.0.5, when set the flag 'Regular Expression' on, the regex doesn't work, when set the flag 'Regular Expression' off, it works ok.
Hi @Rafael, thanks for reporting. I can't reproduce. Please could you attach a sample, remember delete any private/personal information.
Created attachment 117817 [details] REGEX PROBLEM
I see now, but sorry, regular expression doesn't work as you are using it. Wildcards don't work alone and not in the same way than in 123 or excel. Instead only '*' use '.*', search for TEST.* '.' Represents any single character except for a line break or paragraph break. For example, the search term "sh.rt" returns both "shirt" and "short". '*' Finds zero or more of the characters in front of the "*". For example, "Ab*c" finds "Ac", "Abc", "Abbc", "Abbbc", and so on. Please take a look in the help for regular expressions. They are really powerful much more than wildcards. Please if you are not agree, reopen it.