Summary: | sorting in calc can't be focused on letters alone | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | foxtrot <w.helm> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | enhancement | CC: | himajin100000, libreoffice-ux-advise |
Priority: | medium | Keywords: | needsUXEval |
Version: | 6.0 all versions | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=125363 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108386 |
Description
foxtrot
2020-07-12 13:02:27 UTC
https://unicode-org.github.io/icu-docs/apidoc/dev/icu4c/ucol_8h.html#a583fbe7fc4a850e2fcc692e766d2826c UCOL_ALTERNATE_HANDLING is UCOL_NON_IGNORABLE ? er... what? More meaningful use case for ignoring spaces is in bug 50786. Names may be combined like "Mac Donald", "De Broukere", "von Guttenberg" etc. Would make this ticket a duplicate not least since Calc is not a text processing tool. If you paste the table into Writer and sort with Key Type = Phone book the result is what you expect. Aha... I understand, what you mean, but I don't agree. It's in both cases far from text processing. Names and - in my case - song titles in a table are both "data" of the type "character". Your example of "von der Lippe" is to be solved by an additional column for "von der" - a prefix that isn't relevant for sorting. I do something similar in another table with movie titles, where I have a column for the article at the beginning of a movie title, that is not relevant for sorting (the sixth sense, the italian job...) (and I even do some calculation there... sure not with the names). But both Flemish family names and song titles can't be parted like this or cleared in another useful way but considering only letters. And this setting/ option would now already cover two use cases (three, if we count movie titles, too), and who knows how many more... (In reply to foxtrot from comment #4) > Aha... I understand, what you mean, but I don't agree. Hope you agree with making it a duplicate. Other ticket will receive more attention - and I'm going to change the summary from "ignore spaces" to "introduce phone book sort algorithm". *** This bug has been marked as a duplicate of bug 50786 *** sure, it's a duplicate |