Auto sizing of fields for displaying computer forms

• US 6,055,550 A
• Filed: 03/21/1996
• Issued: 04/25/2000
• Est. Priority Date: 03/21/1996
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle Corporation
• Inventors: Wallack, Peter
• Primary Examiner(s): Hong, Stephen S.
• Application Number:
  US08/618,848
• Time in Patent Office: 1,496 Days
• Field of Search: 395/766, 395/768, 395/769, 395/770, 395/771, 395/780, 395/781, 395/782, 395/783, 395/340, 395/342, 345/55, 345/59, 345/340, 345/342, 707/508, 707/505, 707/506, 707/507, 707/509, 707/510, 707/518, 707/519, 707/520, 707/521
• US Class Current: 715/229
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

An auto resizing of fields system is disclosed that permits resizing a selected group of cells on a computer generated form. The selected group of cells are aligned, such as in a column, on a computer generated form. Data for the computer form is contained on records that may be stored at remote data sources. To auto size a selected group of cells, sample records are selected, and for each record selected, a display size large enough to display data without obstruction in the corresponding cell is calculated. From the display sizes calculated, a single optimal size for all cells in the group of cells is determined. Based on the optimal size, the group of cells are resized, and additional cells, which are visible on the computer generated form, are also resized to reflect the resizing of the group of cells. A technique for calculating an optimal width for a selected column on a form is also disclosed.

Claims

1. A method for configuring cell sizes of a computer generated form to optimize display of data from a persistent data source, said method comprising the steps of:

accessing a persistent datastore to read a sample of records from a database, said sample of records being less than the total number of records in said database and said sample of records being selected, through a statistical algorithm, so as to generally represent all of said records in said database, said database stores data for a plurality of cells for display as a computer generated form, said data for each record comprising a length;

determining a single optimal size from said length of data in said sample of records to display said data on said computer generated form; and

thereafter, rendering said computer generated form on an output display with data from said records displayed in said cells sized to said optimal size, whereby said computer generated form is optimized based on data in said sample of records.

2. The method as set forth in claim 1, wherein the step of determining a single optimal size comprises the steps of:

calculating a plurality of display sizes from said length of data in said sample of records, wherein a display size comprises a size large enough to display, without obstruction, data in a corresponding cell;

comparing said display sizes from each record sampled to determine a largest display size; and

selecting for said single optimal size said largest display size.

3. The method as set forth in claim 2, further comprising the steps of:

selecting a predetermined minimum size; and

selecting for said single optimal size said predetermined minimum size if said predetermined minimum size is greater than said largest display size.

4. The method as set forth in claim 1, wherein said cells are aligned in a column on said computer generated form.

5. The method as set forth in claim 1, wherein the step of determining a single optimal size comprises the step of calculating a width, based on a predetermined height, to display data in a corresponding cell.

6. The method as set forth in claim 1, wherein said data for display in said cells comprises textual data.

7. The method as set forth in claim 1, wherein said data for display in said cells comprises widgets.

8. The method as set forth in claim 1, further comprising the steps of:

providing an input mechanism that permits a user to select at least one group of cells and to select a resizing function; and

resizing said group of cells selected in response to user selection of said resizing function from said input mechanism.

9. The method as set forth in claim 1, wherein said database of records are stored in a remote persistent datastore.

10. A computer readable medium having a set of instructions stored therein, which when executed by a computer, causes the computer to configure cell sizes of a computer generated form to optimize display of data from a persistent data source, by performing the steps of:

accessing a persistent datastore to read a sample of records from a database, said sample of records being less than the total number of records in said database and said sample of records being selected, through a statistical algorithm, so as to generally represent all of said records in said database, said database stores data for a plurality of cells for display as a computer generated form, said data for each record comprising a length;

determining a single optimal size from said length of data in said sample of records to display said data on said computer generated form; and

thereafter, rendering said computer generated form on an output display with data from said records displayed in said cells sized to said optimal size, whereby said computer generated form is optimized based on data in said sample of records.

11. The computer readable medium as set forth in claim 10, wherein the step of determining a single optimal size comprises the steps of:

calculating a plurality of display sizes from said length of data in said sample of records, wherein a display size comprises a size large enough to display, without obstruction, data in a corresponding cell;

comparing said display sizes from each record sampled to determine a largest display size; and

selecting for said single optimal size said largest display size.

12. The computer readable medium as set forth in claim 11, further comprising the steps of:

selecting a predetermined minimum size; and

selecting for said single optimal size said predetermined minimum size if said predetermined minimum size is greater than said largest display size.

13. The computer readable medium as set forth in claim 10, wherein said cells are aligned in a column on said computer generated form.

14. The computer readable medium as set forth in claim 10, wherein the step of determining a single optimal size comprises the step of calculating a width, based on a predetermined height, to display data in a corresponding cell.

15. The computer readable medium as set forth in claim 10, wherein said data for display in said cells comprises textual data.

16. The computer readable medium as set forth in claim 10, wherein said data for display in said cells comprises widgets.

17. The computer readable medium as set forth in claim 10, further comprising the steps of:

providing an input mechanism that permits a user to select at least one group of cells and to select a resizing function; and

resizing said group of cells selected in response to user selection of said resizing function from said input mechanism.

18. The computer readable medium as set forth in claim 10, wherein said database of records are stored in a remote persistent datastore.

19. A computer system comprising:

a persistent datastore for storing a database of a plurality of records of data for display within cells on a computer generated form, said data for each record comprising a length;

processor unit for accessing said persistent datastore to read a sample of records from said database, said sample of records being less than the total number of records in said database and said sample of records being selected, through a statistical algorithm, so as to generally represent all of said records in said database, and for determining a single optimal size from said length of data in said sample of records to display said data on said computer generated form; and

an output display for displaying said computer generated form with data from said records displayed in said cells sized to said optimal size, whereby said computer generated form is optimized based on data in said sample of records.