https://bugs.freedesktop.org/show_bug.cgi?id=50786
Bug #: 50786
Summary: EDITING: sort or natural sort of text should ignore
spaces
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.3 release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
The sort algorithm (apparently) sorts on ascii values of the characters in text
strings. Consequently, a space character is also considered to be a letter.
However, a space should not have an influence on the sorting order and should
be ignored.
If it is not possible to implement this in the standard sort function (as it
would change the behaviour of a feature that is used quite a lot), then I hope
it can at least be implemented in "natural sort".
An example: Flemish surnames often start with "De" or "Van de" and these names
can be written either with or without spaces. LibreOffice Spreadsheet sorts
these names incorrectly:
DESIRED RESULT:
1stname Surname
Bart Debacker
Peter De Decker
Mark Demol
Rudy De Wilde
Wim Dewilde
ACTUAL RESULT:
1stname Surname
Peter De Decker
Rudy De Wilde
Bart Debacker
Mark Demol
Wim Dewilde
WORKAROUND:
As a workaround, you add a column calculated from the the one to be sorted with
spaces removed (e.g. =SUBSTITUTE(B2," ","") ). However, I find this rather
kludgy.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
