https://bugs.documentfoundation.org/show_bug.cgi?id=147475
--- Comment #4 from Rafael Lima <[email protected]> --- I am glad this is NOTABUG. However, I had no idea that the option "Search criteria = and <> must apply to whole cells" would change the way the filter is applied in AutoFilter. I always thought this option only applied to database functions, as stated in the help page [1], where it says that the option "Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly." There's no information about this option being applied to the AutoFilter. The same goes for help pages [2] and [3] that should mention the effect that this option may have. The reason why I ended up having this "bug" is because some time ago I was documenting DB functions and I disabled the aforementioned option to test its effects, then I forgot to re-enable it. Is it OK if I reopen this bug and send it to Documentation so we can improve the help pages related to the AutoFilter ?? [1] https://help.libreoffice.org/7.3/en-US/text/shared/optionen/01060500.html?System=UNIX&DbPAR=CALC [2] https://help.libreoffice.org/7.3/en-US/text/scalc/guide/autofilter.html?DbPAR=CALC#bm_id3156423 [3] https://help.libreoffice.org/7.3/en-US/text/scalc/01/12040100.html?&DbPAR=CALC&System=UNIX -- You are receiving this mail because: You are the assignee for the bug.
