Issue 78228 - Lists should be sorted numerically rather than alphanumerically
Summary: Lists should be sorted numerically rather than alphanumerically
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: 680m212
Hardware: Mac All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-06-08 12:25 UTC by shaunmcdonald131
Modified: 2019-01-20 08:53 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description shaunmcdonald131 2007-06-08 12:25:32 UTC
Lists that have numbers in them should be sorted numerically instead of alpha
numerically. The problem occurs in various places across the app, and the issue
tracker too. Here's some examples:
Insert > Crossreference > Type Illustration: Illustration 19 should not come
before Illustration 1
"Formatting and Styles" window: Heading 10 should come after Heading 9
File Chooser: If you have a list of files "Picture n.png", where n is a whole
number. Real file choosers will sort this properly. (The Mac OS X Native file
chooser and jEdit file choosers will sort these numerically for any set of files
that only change by the numbers.

Issue Tracker: "Found in version" field: 680m22 should come before 680m211.

This problem is really throwing me off when looking through lists of things.
Comment 1 thorsten.martens 2007-06-11 14:09:51 UTC
TM->requirements: have a look.
Comment 2 Ryan 2019-01-20 05:01:47 UTC
Seriously. It's 2019 and this still isn't fixed. Get on it.
Comment 3 Peter 2019-01-20 08:48:56 UTC
> Issue Tracker: "Found in version" field: 680m22 should come before 680m211.
This is a Bugzilla Issue not an OpenOffice Issue. -> Wrong Bugtracker.

> Real file choosers will sort this properly. (The Mac OS X Native file
> chooser and jEdit file choosers will sort these numerically for any set of files
> that only change by the numbers.
My mac doe not do that. I have 3 files sorted by the following order:
File_21/27/13
File_03/56/10
File_04/16/30

I tried Order by Name and order by Program.

>"Formatting and Styles" window: Heading 10 should come after Heading 9
maybe sort first by length and then by alpha numeric would do the trick. We can not sort numeric as is, because we do not know the Pattern of your File.
Or we could try to find a way to sort by Pattern. but that will not help at places like formats which have fixed patterns..

I note this Issue on the Overview board under UI Issues. It will be fixed when someone has interest in fixing it and not earlier. If you want to get a fix, best way is to do it yourself.
Comment 4 Peter 2019-01-20 08:52:23 UTC
see also https://bz.apache.org/ooo/show_bug.cgi?id=22419