Method of displaying data in a table

• US 20060117051A1
• Filed: 11/21/2005
• Published: 06/01/2006
• Est. Priority Date: 11/26/2004
• Status: Abandoned Application

• Current Assignee: Philip K. Chin
• Original Assignee: Philip K. Chin
• Inventors: Chin, Philip K.
• Application Number:
  US11/284,942
• Publication Number:
  US 20060117051A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/177 of tables; using ruled lines

Abstract

A method and computer-executable program code for displaying data in a table having columns, rows and a plurality of cells defined by the columns and rows. The method involves the steps of creating a first and a second sub-tables positioned one above another or side-by-side. The top sub-table defines a non-scrollable, fixed header, while the bottom table defines a scrollable data table. The top table has a visible part and a hidden part, which contains records copied from a maximum width cell in the top or bottom table corresponding to each individual column. To form a fixed sidebar, the code computer-executable program code adjusts the height of the rows based on the parameters of a maximum height cell in the row.

Claims

1. A method of displaying on a computer-controlled screen, records arranged in a table, said table having columns, rows and a plurality of cells defined by the columns and rows, the method comprising the steps of:

forming a first non-scrollable sub-table for displaying headings of the columns;

forming a second scrollable sub-table for displaying records corresponding to the headings in the first sub-table;

defining maximum size parameters for each column in the first sub-table and the second sub-table based on parameters of a maximum width or height cell within each column;

defining a visible part of the first sub-table to be visible on the computer-controlled screen and a hidden part of the first sub-table that is non-visible on the computer-controlled screen; and

copying data of the maximum parameter cell into a cell within a corresponding column in the hidden part of the first sub-table, thereby defining the width or height parameters of the corresponding column.

2. The method of claim 1, wherein the records to be copied into the hidden first sub-table have a pre-determined height adjusted to a pre-determined geometric attribute value prior to copying the records into the hidden part of the first sub-table.

3. The method of claim 2, wherein the geometric attribute value has the height value of 1 or less.

4. The method of claim 1, wherein a cell width is determined by setting the <

td>

width attribute to a pixel value of the record within the cell.

5. The method of claim 1, wherein a cell width is determined by determining a percentage value of the corresponding column in relation to remainder data table.

6. The method of claim 1, wherein the non-scrollable first sub-table defines a fixed header of the table.

7. The method of claim 1, wherein the first sub-table defines a fixed sidebar of the table.

16. The method of claim 1, wherein the data of the maximum parameter cell copied into a cell within a corresponding column in the hidden part of the first sub-table is representative data of the maximum parameter cell.

8. Computer program code embodied in a computer-readable medium, comprising:

computer-executable program code for defining a set of parameters for a record of the database arranged in a data table having columns, rows and a plurality of cells defined by the columns and rows;

computer-executable program code for determining maximum width or height parameters for each column or row in the data table based on the records to be displayed in a cell having the maximum width or height parameters;

computer-executable program code for establishing a first sub-table defining a non-scrollable part of each column;

computer-executable program code for establishing a second sub-table defining scrollable part of each column;

computer-executable program code for establishing a visible part of the first sub-table and a hidden part of the first sub-table;

computer-executable program code for associating records from the maximum parameter data cell into a cell within a corresponding column in the hidden part of the first sub-table, to thereby define width or height parameters of the corresponding columns or rows in the first sub-table and the second sub-table.

9. The computer program code of claim 8, wherein the records to be associated into the hidden first sub-table have a pre-determined height adjusted to a pre-determined geometric attribute value prior to copying the records into the hidden part of the first sub-table.

10. The computer program code of claim 9, wherein the geometric attribute value has the height value of 1 or less.

11. The computer program code of claim 8, wherein a cell width is determined by setting the <

td>

width attribute to a pixel value of the record within the cell.

12. The computer program code of claim 8, wherein a cell width is determined by determining a percentage value of the corresponding column in relation to remainder data table.

13. The computer program code of claim 8, wherein the non-scrollable first sub-table defines a fixed header of the table.

14. The computer program code of claim 8, wherein the non-scrollable first sub-table defines a fixed sidebar of the table.

15. The computer program code of claim 8, wherein the records to be associated with the hidden first sub-table are copied into hidden part of the first sub-table.

17. A method for creating stationary headers rows in a web page for a table of data that is scrollable, the method comprising:

associating to the stationary header rows of at least one placeholder from the table of data;

placing a placeholder in a corresponding table to cause a column to automatically size to same width as a corresponding originating table cell and column; and

calculating the maximum text width for each cell of data.