Method and system for automatically resizing tables

• US 5,588,099 A
• Filed: 09/01/1994
• Issued: 12/24/1996
• Est. Priority Date: 09/01/1994
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Marton, Kornel R., Mogilevsky, Alex
• Primary Examiner(s): Jankus, Almis R.
• Application Number:
  US08/299,932
• Time in Patent Office: 845 Days
• Field of Search: 395/139, 395/133, 395/140, 395/141, 395/145-149, 395/155, 395/156, 395/161, 395/117, 395/118, 382/175, 382/229, 364/419.1, 364/419.17, 364/419.19
• US Class Current: 715/273
• CPC Class Codes: G06T 3/40 Scaling of whole images or parts thereof, e.g. expanding or contracting

Abstract

A computer system for automatically resizing a table. A table includes various columns. Each column has a column width and an associated width of the longest data in the column. In a preferred embodiment, the system initially resizes the width of each unwrapped column to the width of its longest data. If the sum of the column widths after resizing is greater than the margin width, then the system proportionally decreases the column width of each column so that the sum of the column width is equal to the margin width. If, however, the sum of the column width is less than the margin width, the system proportionally increases the column width of each wrapped column so that the sum of the column widths is equal to the margin width.

Claims

1. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising the steps of:

for each column in which the column width is greater than the width of the longest data, setting the column width to the width of the longest data; and

when a sum of the column widths of all the columns is greater than a specified width, proportionally decreasing the column width of each column so that the sum of the column widths of all the columns is equal to the specified width.

2. The method of claim 1 wherein the step of proportionally decreasing the column width decreases the column width of each column in proportion to the column width relative to the sum of the column widths of all the columns.

3. The method of claim 1 wherein the step of proportionally decreasing the column width includes the steps of:

determining a spillover amount by subtracting the specified width from the sum of the column widths of all the columns;

determining a total column width by summing the column width of all the columns; and

for each column, setting the column width to the column width minus the column width times the determined spillover amount divided by the determined total column width.

4. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising the steps of:

for each column which contains data and in which the column width is greater than the width of the longest data, setting the column width to the width of the longest data;

when a sum of the column widths of all the columns is greater than a specified width, decreasing the column width of blank columns so that the sum of the column widths of all the columns is equal to the specified width; and

when the decreased column widths of the blank columns are not such that the sum of the column widths of all the columns is equal to the specified width, decreasing the column width of each column so that the sum of the column widths of all the columns is equal to the specified width.

5. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising the steps of:

for each column in which the column width is greater than the width of the longest data, setting the column width to the width of the longest data; and

when a sum of the column widths of all the columns is less than a specified width, proportionally increasing the column width of each column so that the sum of the column widths of all the columns is equal to the specified width.

6. The method of claim 5 wherein the step of proportionally increasing the column width increases the column width of each column in proportion to the column width relative to the sum of the column widths of all the columns.

7. The method of claim 5 wherein the step of proportionally increasing the column width increases the column width to no wider than the width of the longest data.

8. The method of claim 5 wherein the step of proportionally increasing the column width includes the steps of:

determining a shortfall amount by subtracting the sum of the column widths of all the columns from the specified width;

determining a total column width by summing the column width of all the columns in which the column width is less than the width of the longest data; and

for each column in which the column width is less than the width of the longest data, setting the column width to the column width plus the column width times the determined shortfall amount divided by the determined total column width.

9. The method of claim 8 wherein the step of setting the column width includes the step of setting the column width to the minimum of the width of the longest data of the column and the column width plus the column width times the determined shortfall amount divided by the determined total column width.

10. The method of claim 9 including the step of repeating the steps of determining a shortfall amount, determining a total column width, and setting the column width until the determined shortfall amount is equal to zero.

11. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising when a sum of the column widths of all the columns is less than a specified width, proportionally increasing the column width of each column in which the width of the longest data is wider than the column width so that the sum of the column widths of all the columns is equal to the specified width and so that each increased column width is less than or equal to the width of the longest data of the column.

12. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising the steps of:

for each column in which the column width is greater than the width of the longest data, setting the column width to the width of the longest data;

when a sum of the column widths of all the columns is greater than a margin width, proportionally decreasing the column width of each column so that the sum of the column widths of all the columns is equal to the margin width; and

when the sum of the column widths of all the columns is less than the margin width, proportionally increasing the column width of each column so that the sum of the column widths of all the columns is equal to the margin width.

13. The method of claim 12 wherein the step of proportionally decreasing the column width decreases the column width of each column in proportion to the column width relative to the sum of the column widths of all the columns.

14. The method of claim 12 wherein the step of proportionally increasing the column width increases the column width of each column in proportion to the column width relative to the sum of the column widths of all the columns.

15. The method of claim 12 wherein the step of proportionally increasing the column width increases the column width to no wider than the width of the longest data.

16. A computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the system comprising:

means for setting the column width to the width of the longest data for each column in which the column width is greater than the width of the longest data;

means for proportionally decreasing the column width of each column so that the sum of the column widths of all the columns is equal to a margin width when a sum of the column widths of all the columns is greater than the margin width; and

means for proportionally increasing the column width of each column so that the sum of the column widths of all the columns is equal to the margin width when the sum of the column widths of all the columns is less than the margin width.

17. A computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the system comprising a table resizing program that operates when a sum of the column widths of all the columns is less than a margin width to proportionally increase the column width of each column in which the width of the longest data is wider than the column width so that the sum of the column widths of all the columns is equal to the margin width and so that each increased column width is less than or equal to the width of the longest data of the column.

18. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising:

for each column in which the column width is different than the width of the longest data,

setting the column width to the width of the longest data; and

unwrapping any wrapped data contained in the column; and

when a sum of the column widths of all the columns is less than a specified width, increasing the column width of each blank column so the sum of the column widths of all the columns is equal to the specified width.

19. The method of claim 18 wherein the step of increasing the column width of each blank column increases the column width of each blank column in proportion to the original column width of the blank column relative to the sum of the original column widths of all the blank columns.

20. The method of claim 18 wherein the step of increasing the column width of each blank column comprises:

determining a shortfall amount equal to the specified width less the sum of the column widths of all the columns; and

for each blank column, setting the column width equal to the original column width of the blank column times the determined shortfall amount divided by the sum of the original column widths of all the blank columns.

21. A method in a computer system for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising:

for each column in which the column width is different than the width of the longest data,

setting the column width to the width of the longest data; and

unwrapping any wrapped data contained in the column; and

when a sum of the column widths of all the columns is greater than a specified width,

rewrapping the unwrapped data contained in each column that originally contained wrapped data; and

resetting the column width of each column containing the rewrapped data to the original column width of the column.

22. The method of claim 21 further comprising:

when the sum of the column widths of all the columns is less than the specified width, proportionally increasing the column width of each column containing the rewrapped data so that the sum of the column widths of all the columns is equal to the specified width and so that each increased column width is no wider than the width of the longest data of its respective column.

23. The method of claim 22 wherein the step of proportionally increasing the column width of each column containing the rewrapped data comprises:

(a) determining a shortfall amount equal to the specified width less the sum of the column widths of all the columns; and

(b) for each column containing wrapped data,

determining an increase in the column width of the column equal to the original column width of the column times the determined shortfall amount divided by the sum of the original column widths of all the columns containing wrapped data;

setting the column width of the column equal to the original column width of the column plus the determined increase in the column width of the column; and

when the column width of the column is at least equal to the width of the longest data of the column,

setting the column width of the column to the width of the longest data of the column; and

unwrapping the wrapped data contained in the column; and

(c) when the wrapped data contained in at least one of the columns containing wrapped data is unwrapped in step (b),

setting the column width of each column still containing wrapped data to the original column width of its respective column; and

repeating steps (a) and (b).

24. A computer-readable storage medium upon which is stored a program for controlling a computer system to automatically resize a table, the table having a plurality of columns, each column having a column width and a width of longest data by the steps of:

for each column in which the column width is different than the width of the longest data,

setting the column width to the width of the longest data; and

unwrapping any wrapped data contained in the column; and

when a sum of the column widths of all the columns is greater than a specified width,

rewrapping the unwrapped data contained in each column that originally contained wrapped data; and

resetting the column width of each column containing the rewrapped data to the original column width of the column.

25. The computer-readable storage medium of claim 24 wherein:

when a sum of the column widths of all the columns is less than the specified width, proportionally increasing the column width of each column containing the rewrapped data so that the sum of the column widths of all the columns is equal to the specified width and so that each increased column width is no wider than the width of the longest data of its respective column.

26. A computer-readable storage medium upon which is stored a program for controlling a computer system to perform in accordance with a method for automatically resizing a table, the table having a plurality of columns, each column having a column width and a width of longest data, the method comprising:

for each column in which the column width is different than the width of the longest data,

setting the column width to the width of the longest data; and

unwrapping any wrapped data contained in the column; and

when a sum of the column widths of all the columns is less than a specified width, increasing the column width of each blank column so the sum of the column widths of all the columns is equal to the specified width.