Created attachment 178319 [details] Video capture showing the problem Suppose you have the following text values in a column (the first value is the column header): Name Dialog Dialog DialogControl DialogControl Menu PopupMenu Menu PopupMenu If you apply the AutoFilter to this column and filter only for "Dialog" (by choosing only "Dialog" in the checkboxes), it will show "DialogControl" as well. The same happens if you choose "Menu", which ends up showing "Menu" and "PopupMenu". See the attached video showing this behavior. This happens in LO 7.2.5 and LO 7.3.0. In LO 7.4 it is working fine, hence this is a bug that apparently was patched for 7.4 but needs to be backported to 7.2 and 7.3. System info: Version: 7.2.5.2 / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: threaded Version: 7.3.0.3 / LibreOffice Community Build ID: 30(Build:3) CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.0~rc3-0ubuntu0.21.10.1~lo1 Calc: threaded
Created attachment 178320 [details] Sample ODS file used in the video This is the ODS file used in the video.
Probably user error. @Reporter: Please open document and check Menu ˋTools → Options → LibreOffice Calc → Calculateˊ! If checkbox "Search criteria = and <> must apply to whole cell" is unchecked it#s the intende behavior what you observe.
There is an option in Menu/Tools/Options/LibreOffice/Calc/Calculate - Search criteria = and <> must apply to whole cells. Check it and it works as you expect.
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
Please create a new report bug for the help update.