Sorting a table by rows or columns in response to interactive prompting with a dialog box graphical icon

• US 5,396,621 A
• Filed: 05/10/1991
• Issued: 03/07/1995
• Est. Priority Date: 05/10/1991
• Status: Expired due to Term

• Current Assignee: Apple Inc.
• Original Assignee: Claris Corp (Apple Inc.)
• Inventors: MacGregor, Kathryn, Waymire, Elisabeth A.
• Primary Examiner(s): Kulik, Paul V.
• Assistant Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US07/698,293
• Time in Patent Office: 1,397 Days
• Field of Search: 364/300, 364/408, 364/900, 395/600, 395/161
• US Class Current: 715/809
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 715/975 Pop-up dialog box for entry

Abstract

An improved apparatus and method for sorting of information in a computerized spreadsheet or the like. The improved system provides for display of a graphical indication in the form of an icon indicative of the sort type, either by rows or by columns, which the data will be sorted in when a sort operation is performed.

Claims

1. A computer implemented method for sorting of information in a computer system comprising the steps of:

(a) said computer displaying said information on a computer controlled displayed device, said information comprising N rows and M columns of data;

(b) said computer displaying a dialog box on said computer controlled display device, said dialog box allowing said computer to accept from a user an indication of a sort type, where said type indicates whether said information is to be sorted by rows or by columns;

(c) said computer displaying on said computer controlled display device a graphical indication of said sort type, wherein said graphical indication comprises, in the case of a sort by rows, a graphical icon illustrating a grid having rows and columns and further having an indicator visually joining at least a first and a second of said rows;

(d) said computer receiving an input from a user to select a sort type; and

(e) said computer sorting said information.

2. A computer implemented method for sorting of information in a computer system comprising the steps of:

(a) said computer displaying said information on a computer controlled display device, said information comprising N rows and M columns of data;

(b) said computer displaying a dialog box on said computer controlled display device, said dialog box allowing said computer to accept from a user an indication of a sort type, where said sort type indicates whether said information is to be sorted by rows or by columns;

(c) said computer displaying on said computer controlled display device a graphical indication of said sort type, wherein said graphical indication comprises, in the case of a sort by columns, a graphical icon illustrating a grid having rows and columns and further having an indicator visually joining at least a first and a second of said columns;

(d) said computer receiving an input from a user to select a sort type; and

(e) said computer sorting said information.

3. The method as recited by claim 2 further comprising the step of selecting said information as a range of cells.

4. The method as recited by claim 2 further comprising the step of selecting a sort key for performing said sort operation.

5. The method as recited by claim 4 wherein said step of selecting a key may be accomplished by selecting a row in the case of a sort by column and by selecting a column in the case of a sort by row.

6. A computer implemented method for selecting a sort type in a sorting operation on a compute system, where said sort types comprise sorting by rows or sorting by columns, the method comprising the steps of:

(a) said computer displaying information on a computer controlled display device, said information comprising data organized into cells which cells are displayed in rows and columns on a display of said computer system;

(b) said computer displaying a dialog box on said computer controlled display device, said dialog box allowing said computer to accept from a user an indication of a sort type, where said sort type is an indication of whether said information is to be sorted by rows or by columns;

(c) said computer displaying on said computer controlled display device a graphical indication of said sort type, wherein said graphical indication comprises, in the case of a sort by rows, a graphical icon illustrating a grid having rows and columns and further having an indicator visually joining at least a first and a second of said rows; and

(d) said computer accepting an input from said user to allow selection of a sort type.

7. The method as recited by claim 6 wherein said graphical indication comprises, in the case of a sort by columns, a graphical icon illustrating a grid having rows and columns and further an indicator visually joining at least a first and a second of said columns.

8. In a computer system having a memory for storing information comprised of a plurality of cells of data a display for displaying said cells of data in a format comprising N rows and M columns, and a processor for sorting said information where said information may be selectively sorted by rows or by columns, an improved method for selecting whether said information is to be sorted by rows or by columns comprising the steps of:

(a) displaying on a compute controlled display device a prompt to prompt a user to select whether said data is to be sorted by rows or by columns;

(b) said said computer accepting an input to from said user to allow selection of a sort by rows or by columns; and

(c) displaying on said computer controlled display device a graphical representation indicative of whether the user has selected to sort by rows or by columns, wherein said graphical representation comprise, in the case of a sort by rows, a graphical indicator having a grid and an indicator means coupling a first row of said grid with a second row of said grid.

9. The method as recited by claim 8 wherein said graphical representation comprises, in the case of a sort by columns, a graphical indicator having a grid and an indicator means coupling a first column of said grid with a second column of said grid.

10. In a computer system having a memory for storing information comprised of a plurality of cells of data, a display for displaying said cells of data in a format comprising N rows and M columns, and a processor for sorting said information where said information may be selectively sorted by rows or by columns, an improved method for selecting whether said information is to be sorted by rows or by columns comprising the steps of:

(a) said computer displaying a prompt allowing a user to select whether said data is to be sorted by rows or by columns;

(b) said computer allowing a user to input to said computer an indication of whether to sort by rows or by columns; and

(c) said computer displaying representation illustrating graphically sorting by rows or by columns, wherein said representation comprises a first graphical icon illustrating a grid having rows and columns and further having an arrow with its tail at a first row and its head at a second row and a second graphical icon illustrating a grid having rows and columns and further having an indicator visually joining at least a first and a second of said columns.

11. A computer system comprising:

(a) data storage means for storing a plurality of cells of data, said data organized into N rows of cells by M columns of cells;

(b) processing means for sorting said plurality of cells; and

(c) display means for displaying a graphical indication of a sort type, where said sort type indicates whether said plurality of cells are to be sorted by rows or by columns, wherein said graphical indication comprises, in the case of a sort by rows, a graphical indicator having a grid and an indicator means coupling a first row of said grid with a second row of said grid.

12. The method as recited by Claim 11 wherein said graphical indication comprises, in the case of a sort by columns, a graphical indicator having a grid and an indicator means coupling a first column of said grid with a second column of said grid.