Bug 70782

Summary:	Other: Leave spaces out of consideration in string items that are to be sorted
Product:	LibreOffice	Reporter:	hans.evian
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	cno, heiko.tietze, thomas.lendo
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:	BSA
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	89606, 108386

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?