[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #10 from Robert Lacroix --- I think a more general approach would be to allow regular expression matching to ignore parts of a sort string. Calc is already most of the way there since the Find and Replace feature has regular expression matching as an option. For people who don't know how to use regular expressions, add a modifiable list of common patterns to choose from, similar to what we have for date formats. Ignoring spaces would simply be one of these selectable predefined patterns. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #9 from Heiko Tietze --- (In reply to Eike Rathke from comment #7) > I don't know what you tried. Me neither anymore. When I tried first Calc sorted differently to Writer with PB-mode enabled. Anyway, if this mode would take spaces into consideration I imagine it's a solution to both issues and a valuable enhancement. But feel free to resolve/reopen tickets. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #8 from foxtrot --- The point is: I never talked about "phone book", My issue was linked to this as a "duplicate". I just would like to sort those titles right. Would you sort them the way the algorithm does? The algorithm would sort it right, if it just considered letters - that's my point. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #7 from Eike Rathke --- I don't know what you tried. If I use the 4 example lines of that bug description copied twice to Writer, selecting each section and sorting with German (Germany) but one Alphanumeric and one Phone book algorithm I get identical results for both: I want... I'm gonna... Ich habe... In der... Same in Calc. I also don't see why there should be any difference because AFAIK the German phone book algorithm is about the position of Umlauts, not blanks or apostrophes. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #6 from Heiko Tietze --- (In reply to Eike Rathke from comment #4) > Calc already offers different algorithms... Tested the duplicate bug 134747 and sorting in Calc never resulted in this "phone book" order that Writer can do, which is expected by foxtrot. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #5 from foxtrot --- It's not only for literal phone book sorting or "ignoring spaces" - my issue (134747) was marked as a duplicate of this, and it's actually "only consider letters", as I try to sort various text data, like song titles that also can contain punctuation marks. So there is more than just sorting locale names... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 --- Comment #4 from Eike Rathke --- Calc already offers different algorithms if the locale defines such, see for example {de-DE} German (Germany) (or other German), "Alphanumeric" and "Phone book". The {nl-BE} Dutch (Belgium) locale does not define additional algorithms. I currently don't know if there is a specific phonebook collation order offered for nl-BE in ICU or if the general phonebook could be used. Is that (ignoring spaces) a thing in the Netherlands as well? Apart from that I doubt it's a general "ignore spaces" thing but depends on the prefix "De" or "Van de" or such. Natural Sort is a specific handling of numbers within text and not suited to implement wild alternatives. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 50786] Phone Book sort algorithm
https://bugs.documentfoundation.org/show_bug.cgi?id=50786 Heiko Tietze changed: What|Removed |Added Summary|Phone Book search algorithm |Phone Book sort algorithm -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs