[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 Rafael Lima changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||7520 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 --- Comment #5 from m.a.riosv --- Please create a new report bug for the help update. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 --- Comment #4 from Rafael Lima --- 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=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?=CALC=UNIX -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 m.a.riosv changed: What|Removed |Added Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |RESOLVED --- Comment #3 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 Rainer Bielefeld Retired changed: What|Removed |Added CC||LibreOffice@bielefeldundbus ||s.de --- Comment #2 from Rainer Bielefeld Retired --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 Rafael Lima changed: What|Removed |Added Blocks||103512 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103512 [Bug 103512] [META] AutoFilter-related bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147475] AutoFilter: Search filter not working when choosing to show specific entries
https://bugs.documentfoundation.org/show_bug.cgi?id=147475 --- Comment #1 from Rafael Lima --- Created attachment 178320 --> https://bugs.documentfoundation.org/attachment.cgi?id=178320=edit Sample ODS file used in the video This is the ODS file used in the video. -- You are receiving this mail because: You are the assignee for the bug.