Worldwide number format for a spreadsheet program module

• US 6,957,385 B2
• Filed: 01/05/2001
• Issued: 10/18/2005
• Est. Priority Date: 01/05/2001
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Yu, Christopher C., Schmidt, Kenneth E., Chan, Marise, McCord, Barry C., Sukhabut, James
• Primary Examiner(s): Bashore, William
• Assistant Examiner(s): Sain, Gautam
• Application Number:
  US09/755,432
• Publication Number:
  US 20020091731A1
• Time in Patent Office: 1,747 Days
• Field of Search: 707/201, 341/63, 705/10, 715/503, 715/504, 364/715, 704/8, 717/1
• US Class Current: 715/220
• CPC Class Codes: G06F 40/111 Mathematical or scientific formatting; Subscripts; Superscripts
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A worldwide number format for use with a spreadsheet program module is disclosed. The worldwide number format includes a locale specifier comprising a number shape, a calendar type and a locale identification (LCID). The worldwide number format also includes a base number format and a value. The LCID is used to categorize different parts of the world. Primarily, the LCID categorizes different parts of the world by language such as English, German, French, Thai, Arabic, etc. The LCID is used to determine what language to display month names, month abbreviations, weekday names, weekday abbreviations, time designations such as AM/PM, etc. The calendar type supports both Gregorian and non-Gregorian calendars. Calendar type is a value to indicate which calendar should be used to calculate the date from the value. The number shape is a value that indicates what shape in which to represent the number. In other words, number shape refers to the manner of writing numbers and the digit shape to use to represent a number. For example, some countries prefer to see numbers written out.

Claims

1. A computer-implemented method for rendering a number in a spreadsheet program module, comprising the steps of:

determining the value of the number;

reading a worldwide number format of the number wherein the worldwide format includes a locale specifier of the number and a base format of the number; and

using the base format and the locale specifier to render the number therein applying the worldwide number format to the number;

wherein the locale specifier comprises;

a locale identification used to categorize different parts of the world and determine what language in which to render the number independent of regional settings associated with the spreadsheet program module;

a number shape including a number shape value that indicates what shape in which to render the number; and

a calendar type including a calendar type value that indicates which calendar should be used to calculate a date from the value of the number.

2. The method of claim 1 wherein the number shape value indicates that the number is to be rendered as written out text.

3. The method of claim 1, wherein the worldwide number format is stored in association with the value of the number.

4. The method of claim 1, wherein the number shape refers to one of ASCII numbers, Arabic numbers, Chinese numbers, Korean numbers, and Japanese numbers.

5. The method of claim 1, wherein the number shape comprises a hex digit.

6. The method of claim 1, wherein the number shape refers to at least one of a manner of writing numbers and a digit shape in which to render the number.

7. A computer-implemented method for entering a number into a cell in an electronic spreadsheet of a spreadsheet application program module, the method comprising the steps of:

receiving a category indication for the number from a selection via a Category dropdown menu of the Format Cells dialog within the spreadsheet application program module;

receiving a locale identifier only for the number from a selection via a Locale dropdown menu of the Format Cells dialog within the spreadsheet application program module;

cross-referencing the category indication and locale identifier independent of regional format settings to determine a plurality of sample number formats with a plurality of underlying number formats;

displaying the plurality of sample number formats;

receiving an indication of a selection of one of the plurality of sample number formats; and

storing the underlying number format of the selected sample number format in association with a value for the cell, wherein the underlying number format of the selected sample number format and the value for the cell comprise the number.

8. The method of claim 7 wherein the step of displaying the plurality of sample number formats comprises displaying the plurality of sample number formats in a Type menu of the Format Cells dialog.

9. The method of claim 8 wherein the step of receiving an indication of a selection of one of the plurality of sample number formats comprises an indication from the Type menu of the Format Cells dialog.

10. A computer-readable medium having computer-executable instructions for performing the steps recited in claim 7.

11. The method of claim 7, wherein the category indication and the locale identifier determine a calendar type of the number independent of the regional format settings.

12. The method of claim 7, wherein the category indication and the locale identifier determine a number shape of the number independent of the regional format settings.

13. A computer-implemented method for generating a graphical object including a Format Cells dialog box for choosing the number format of a number in an electronic spreadsheet application program module, the method comprising:

generating a Category menu comprising a plurality of number categories to select for the number;

generating a Locale menu comprising a plurality of locales to select as the locale identification for the number independent of at least one of operating system regional settings and a language version of the electronic spreadsheet application program module; and

generating a Type menu comprising a plurality of sample display formats to select to display the number.

14. The method of claim 13 wherein the plurality of sample display formats is generated in response to a selection of one of the plurality of number categories and a selection of one of the plurality of locales.

15. The method of claim 13 wherein each of the plurality of sample display formats has a corresponding underlying number format.

16. The method of claim 15 wherein a selection of one of the plurality of sample display formats causes the corresponding underlying number format of the selected sample display format to be applied to the number independent of at least one of the regional settings and the language version of the electronic spreadsheet application program module.

17. The method of claim 15, wherein the underlying number format includes at least one of a calendar type of the number and a number shape of the number.

18. The method of claim 17, wherein the number shape is determined based on the selection of one of the plurality of number categories and the selection of one of the plurality of locales.

19. The method of claim 17, wherein the calendar type is determined based on the selection of one of the plurality of number categories and the selection of one of the plurality of locales.