Created attachment 190365 [details] Sheet with autofilter and entries "CP" and "Mi-CP" on the column B Hi, When I use the autofilter with the words "CP" and "Mi-CP" listed, and I choose "CP", the result returns all the entries with CP inside so I have "CP" and "Mi-CP" entries. I should obtain only "CP" entries not "Mi-CP" entries. When I choose "Mi-CP", only the "Mi-CP" entries are returned : no problem here. See the attachment. Regards, ThierryM
The problem exist too with "CP" and "MiCP". It's not a dash beetween words problem.
LibreOffice searches on the entire cell, no matter the position. For more detailed searches, there is: Filter by condition Standard filter In condition 'Begins with'
Created attachment 190387 [details] Pictures of the bug
It's not the research the problem. It's when I select only the choice "CP" (see the picture attached), the "Mi-CP" entries are displayed therefore I didn't select the "Mi-CP" choise.
Forgive me, now I understand what you are talking about. The behavior is controlled by the option: Menu/Tools/Options/LibreOffice Calc/Calculate – Search criteria = and <> must apply to whole cells. Change it and the filter works as you expect.
Rethinking about, seems like a bug, that the selection in the filter it's confuse and unclear, perhaps it should always apply to the whole cell in the filter. Or in some way lets us know something about. Asking for UX team point of view.
Thanks a lot m.a.riosv ! I didn't know this option that resolve my problem. But, yes this filter mode is not clear. Maybe with an option in the context menu of the autofilter to choose the filter mode ? Regards.
(In reply to m.a.riosv from comment #6) > (the whole cell option) should always apply Eike, are you aware of a reason why it has been disabled? I'm a bit concerned of users who expect the opposite.
(In reply to Heiko Tietze from comment #8) > (In reply to m.a.riosv from comment #6) > > (the whole cell option) should always apply > Eike, are you aware of a reason why it has been disabled? > I'm a bit concerned of users who expect the opposite. I think AutoFilter should be independent of that option (which applies to comparison operators), selecting an entry it's unexpected it operates as a "contains" filter, but I don't know why it is coupled nor if and when that was changed or not nor if there was a reason to do so or which. To find out maybe request a bibisecting.
We discussed the topic in the design meeting. The solution is to always filter the entire cell aka exact match. If users expect fuzziness it is possible to search in the autofilter popup for "CP" which preselects all *CP* items. I could imagine this to be an easyhack.