Issue 105790 - Calc: custom sort order: also provide numbers
Summary: Calc: custom sort order: also provide numbers
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO300m9
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-10 20:58 UTC by nicklevinson
Modified: 2013-12-24 11:08 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description nicklevinson 2009-10-10 20:58:49 UTC
When I install OOo, with the option for custom sort order, I also insert the
following lists: cardinal numbers; ordinal numbers in digits (including _2d_,
_2nd_, _3d_, & _3rd_ (in the U.S., the short ordinals are used by lawyers and
the long ordinals by most others)); and ordinal numbers in words (including
alternative capitalizations).

Rows might be labeled with numbers as words.

Alternatives do not interfere with sorting when the user types their preferred
forms into cells, as long as what they type coincide with what's in the list;
for example, One Two Four Five will sort properly despite the user not typing
Three; as a result, alternatives like 2d may be in the same list with primary
forms like 2nd.

Thirty is an arbitrary cutoff here.

The following 3 lists are here to support copy-and-paste into a patch:

One
Two
Three
Four
Five
Six
Seven
Eight
Nine
Ten
Eleven
Twelve
Thirteen
Fourteen
Fifteen
Sixteen
Seventeen
Eighteen
Nineteen
Twenty
Twenty-One
Twenty-one
Twenty-Two
Twenty-two
Twenty-Three
Twenty-three
Twenty-Four
Twenty-four
Twenty-Five
Twenty-five
Twenty-Six
Twenty-six
Twenty-Seven
Twenty-seven
Twenty-Eight
Twenty-eight
Twenty-Nine
Twenty-nine
Thirty

1st
2d
2nd
3d
3rd
4th
5th
6th
7th
8th
9th
10th
11th
12th
13th
14th
15th
16th
17th
18th
19th
20th
21st
22d
22nd
23d
23rd
24th
25th
26th
27th
28th
29th
30th

First
Second
Third
Fourth
Fifth
Sixth
Seventh
Eighth
Ninth
Tenth
Eleventh
Twelfth
Thirteenth
Fourteenth
Fifteenth
Sixteenth
Seventeenth
Eighteenth
Nineteenth
Twentieth
Twenty-First
Twenty-first
Twenty-Second
Twenty-second
Twenty-Third
Twenty-third
Twenty-Fourth
Twenty-fourth
Twenty-Fifth
Twenty-fifth
Twenty-Sixth
Twenty-sixth
Twenty-Seventh
Twenty-seventh
Twenty-Eighth
Twenty-eighth
Twenty-Ninth
Twenty-ninth
Thirtieth

I use OOo 3.0.0 OOO300m9 (Build 9358) with Fedora 10 Linux and don't plan to
upgrade now, since it's stable and upgrading takes time.

Thank you.

-- 
Nick
Comment 1 Edwin Sharp 2013-12-24 11:08:04 UTC
Useful enhancement.