Bug 70782 - Other: Leave spaces out of consideration in string items that are to be sorted
Summary: Other: Leave spaces out of consideration in string items that are to be sorted
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: TableofContents-Indexes Sorting
  Show dependency treegraph
 
Reported: 2013-10-22 21:33 UTC by hans.evian
Modified: 2020-12-08 13:54 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description hans.evian 2013-10-22 21:33:31 UTC
Problem description: Items in a book index of 6000 items

aa b,  
aa c,
aa-b,  
aa-c,
aaab,  
aab,
aac,
so sorted, must appear instead as

aaab, 
aa b,  
aa-b,  
aab,
aa c,
aa-c,
aac

answered Oct 14 '13
oweng gravatar says

I can't see anything in the options for enabling this type of sorting. Presumably you are looking to duplicate the difference between Letter by letter and Word by word sorting as supported by Adobe InDesign (shown here). The ICU collation engine used by LO does appear to support the ability to ignore punctuation, which would seem to be similar, however the lack of options may mean this functionality is not exposed to the user.

Operating System: All
Version: unspecified
Comment 1 Cor Nouws 2013-10-23 04:48:15 UTC
Hi Hans,

thanks for the idea -change the summary a bit. Hope it's OK.
I guess it's for Writer and Calc?

best,
Cor
Comment 2 hans.evian 2013-10-23 18:26:12 UTC
Thanks, Cor.

Yes, Writer and Calc.
May I suggest these words:

Leave spaces (single?) out of consideration in string items that are to be sorted

or, better:

Sort strings ignoring punctuation

instead of "Take spaces (single?) into consideration in string items that are to be sorted"

Cheers
Ken McAllister (real name)
Comment 3 Cor Nouws 2013-10-23 21:31:41 UTC
Hi Ken,


Your English is probably better then mine..

(In reply to comment #2)

> Leave spaces (single?) out of consideration in string items that are to be
> sorted
> 
> or, better:
> 
> Sort strings ignoring punctuation

is punctuation just spaces?
I thought more, and starting to discuss about dots, commas ... is a whole different story?

Cheers - Cor
Comment 4 Thomas Lendo 2019-08-19 19:08:20 UTC
Changed summary to suggestion in comment 2.

Sometimes such proposed behavior is better than the actual one. In other cases it's not. Now it's tricky to find the right way for most users.
Comment 5 Heiko Tietze 2020-12-08 13:54:04 UTC
Duplicate of bug 50786?