Bug 70782

Summary:	Other: Take spaces (single?) into consideration in string items that are to be sorted
Product:	LibreOffice	Reporter:	hans.evian
Component:	Libreoffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	cno
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:	BSA
i915 platform:		i915 features:

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.