To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105790 Issue #|105790 Summary|Calc: custom sort order: also provide numbers Component|Spreadsheet Version|OOO300m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P5 Subcomponent|editing Assigned to|spreadsheet Reported by|nicklevinson
------- Additional comments from nicklevin...@openoffice.org Sat Oct 10 19:58:49 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org