Folded tables: a method of viewing wide tables with reduced need for horizontal scrolling

• US 6,313,848 B1
• Filed: 01/06/1999
• Issued: 11/06/2001
• Est. Priority Date: 01/06/1999
• Status: Expired due to Term

• Current Assignee: Avaya Incorporated
• Original Assignee: Avaya Technology Corporation Miami Lakes FLA US
• Inventors: Hoag, LaVerne L.
• Primary Examiner(s): Luu, Matthew
• Assistant Examiner(s): HARRISON, CHANTE E
• Application Number:
  US09/226,755
• Time in Patent Office: 1,035 Days
• Field of Search: 345/112, 345/115, 345/118, 345/121, 345/123, 345/131, 345/133, 345/334, 345/339-342, 345/358, 345/467, 345/354, 345/348, 345/302, 345/333, 707/509
• US Class Current: 345/684
• CPC Class Codes: G06F 40/114 Pagination
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G09G 5/14 Display of multiple viewports
• CPC Class Codes: Y10S 715/973 Scroll tool, e.g. window scroll bar

Abstract

A method for displaying, in a window on a computer display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window. The method includes the steps of determining the width of each column, determining the height of each row, and determining the dynamic height and width of the workspace available for the display of tabular data within said window. The method further includes the step of dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data. The method also includes the step of dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments, and displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane.

Claims

1. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane.

2. The method of claim 1 wherein said tabular data is stored in local data storage.

3. The method of claim 1 wherein said tabular data is stored in networked data storage.

10. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to change the height of a given row;

b. for each pane that displays said row, changing the height of said row, and redisplaying the rows or partial rows that will fit within the height of each pane.

11. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to select a given row;

b. for each pane that displays said row, selecting said row.

12. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to cut a given row;

b. for each pane that displays said row, cutting said row.

13. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to copy a given row;

b. for each pane that displays said row, copying said row.

14. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to paste at a given row;

b. for each pane that displays said row, pasting at said row.

15. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to delete a given row;

b. for each pane that displays said row, deleting said row.

16. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to hide a given row;

b. designating said row as hidden;

c. for each pane that displays said row, hiding said row.

17. The method of claim 1 wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of:

a. receiving a user command to unhide a given row;

b. if said row is designated as hidden, removing from said row its designation as hidden, and for each pane that displays a row adjoining said row, displaying said row.

18. A computer programmed to operate the method of claim 1.

19. Magnetic media on which is recorded a program adapted to operate a computer according to the method of claim 1.

4. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein said tabular data is stored in networked data storage; and

wherein said networked data is stored on a server which is accessed over the Internet.

5. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein the step of dividing tabular data into table segments includes the steps of;

a. creating a table segment comprising the first non-header, non-hidden column;

b. iteratively adding each additional non-hidden column in sequence to the most recently created table segment, if adding said additional column to the most recently created table segment would not cause the sum of the widths of all columns in the most recently created table segment plus the width of the header column to exceed the width of the workspace;

otherwise, creating a new table segment and adding said additional column to the newly created table segment.

6. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein the step of dividing said workspace into panes further includes, if there are more rows than will completely fit in each pane, displaying a vertical scroll bar along the right edge of the window, and reducing the width of said workspace by the width of said vertical scroll bar.

7. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of;

a. if one column has been designated as a header, displaying said header as the first column of each pane;

b. if one row has been designated as a header, displaying said header as the first row of each pane;

c. for each pane, displaying each row that is not designated a header and is not designated hidden, if said row will fit within the remaining height of each pane.

8. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, said method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of;

a. if one column has been designated as a header, displaying said header as the first column of each pane;

b. if one row has been designated as a header, displaying said header as the first row of each pane;

c. for each pane, displaying each row that is not designated a header and is not designated hidden, if said row will fit within the remaining height of each pane; and

wherein a row that will partially fit within the remaining height of each pane is partially displayed in each pane.

9. A method of operating a digital computer to display and manipulate, in a window on a display screen, tabular data arranged in rows and columns, wherein the sum of the widths of the columns is greater than the width of the workspace available within the window, s a id method comprising the computer-implemented steps of:

a. determining the width of each column;

b. determining the height of each row;

c. determining the dynamic height and width of the workspace available for the display of tabular data within said window;

d. dividing said tabular data into table segments, each table segment comprising one or more columns of said tabular data;

e. dividing said workspace into panes, each pane having a height determined by dividing the height of the window by the number of table segments;

f. displaying within each pane all of the columns of a table segment and one or more rows, wherein different columns are displayed in each pane and the same rows are displayed in each pane;

wherein the step of displaying within each pane all of the columns of a table segment and one or more rows includes the steps of;

a. receiving a user command to scroll vertically in a specified direction;

b. determining if the panes can be scrolled in the specified direction;

c. if the direction of scroll is upward, then for each pane, and for each displayed row that is not designated a header or hidden, displaying in place of said row the sequentially following row that is not designated a header or hidden, if it will fit within the height of the pane; and

d. if the direction of scroll is downward, then for each pane, and for each displayed row that is not designated a header or hidden, displaying in place of said row the sequentially preceding row that is not designated a header or hidden, if it will fit within the height of the pane.