Regular expressions in LibreOffice calc do not work

Regular expressions in LibreOffice Calc → Special filters do not work for me. If I use simple strings as a filter, I get correct results with the special filter. I have activated the regular expressions in “Tools → Options → LibreOffice Calc → Calculate”.
I use .*e$ as a filter to filter all records that contain a value in the column with an “e” character at the end, but I get an empty hit list. In this formula
, the regular expressions work for me. What can I do to use the regular expressions in LibreOffice Calc in special filters?



2024-03-29 09 41 15

1 Like

SumIf.ods (9.3 KB)

OK, this is how it actually works if I explicitly activate the regular expressions in the filter dialog :slightly_smiling_face: Thank you! :boom: