[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 Eike Rathke changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WONTFIX |--- --- Comment #6 from Eike Rathke --- (In reply to Heiko Tietze from comment #5) > The standard filter provides means to run case sensitive and adding the > option to the auto filter would clutter the widget further. IMHO that's not what is requested.. the original description lacks the mention of "No duplication" that seems to be the actual problem here, which becomes (somewhat) clearer when opening the sample document (which is confusing enough though). I'd rather expect that when filtering is done case insensitive that also uniqueness (no duplication) is case insensitive. Doing so also wouldn't need any new option in the dialog. Reopening. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 Heiko Tietze changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WONTFIX Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #5 from Heiko Tietze --- No further opinion, recommend to resolve WF (and add it to documentation). The standard filter provides means to run case sensitive and adding the option to the auto filter would clutter the widget further. (In reply to Mike Kaganski from comment #2) > Adding Eike to CC Please reopen in case you disagree. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 Heiko Tietze changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #4 from Heiko Tietze --- Quite obvious to me since the list of items shows only lowercase (Foo, foo = foo) unless I check the sensitive option (only for SF). Would not increase the complexity of the AF but just add a note to the documentation. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 --- Comment #3 from Igor --- Excel AdvancedFilter filters unique data case insensitively, including Cyrillic. And the option corresponding to "Case sensitive" is not there. However, numeric data is distinguished as numbers and strings (?). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||6047 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com Keywords||needsUXEval --- Comment #2 from Mike Kaganski --- here is an ambiguity in the feature description that doesn't allow to clearly see if this is a bug or not. The question assumes that "Case sensitive" option of the filters applies to the "No duplications"; but help [1] does not state that; it only tells that (1) Case sensitive "Distinguishes between uppercase and lowercase letters when filtering the data", and (2) No duplication "Excludes duplicate rows in the list of filtered data". So the (1) is only said to apply to the filtering conditions - not to duplication finding? On one hand, this may be seen as "works as designed"; on the other hand, it's likely that users would expect the different behavior. It's interesting what other spreadsheet applications do in this case. Adding Eike to CC; also asking advice of UX team. [1] https://help.libreoffice.org/7.2/en-US/text/scalc/01/12040201.html?&DbPAR=CALC -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 144196] Standard and advanced filters do not work correctly in case insensitive mode
https://bugs.documentfoundation.org/show_bug.cgi?id=144196 --- Comment #1 from Igor --- Created attachment 174650 --> https://bugs.documentfoundation.org/attachment.cgi?id=174650&action=edit Demo file with filtering error The sample file contains the data needed to reproduce the error. The custom utility correctly performs the case-insensitive duplicate removal task. -- You are receiving this mail because: You are the assignee for the bug.