Method and system for ordered resizing columns in a table

• US 7,725,815 B2
• Filed: 12/12/2005
• Issued: 05/25/2010
• Est. Priority Date: 12/12/2005
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Peters, Johan C.
• Primary Examiner(s): RIES, LAURIE ANNE
• Application Number:
  US11/301,972
• Publication Number:
  US 20070136654A1
• Time in Patent Office: 1,625 Days
• Field of Search: 715/764, 715/227, 715/228, 715/243, 715/244, 715/245, 715/246, 715/247, 715/273, 715/793, 715/796, 715/810, 715/815, 715/772
• US Class Current: 715/227
• 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/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A method and system is provided for resizing columns in a table when a table width is changed from a current table width to a new table width. The table may contain data and may be displayed to a user. The table may be resized responsively to the user'"'"'s inputs or other conditions. A new column width is determined for each column in the table based on a column minimum width and a column maximum width associated with each column. Column minimum widths and column maximum widths may be selected to enhance user comprehension of data displayed in the table. Each column may be associated with a variable representing an order, and the columns may be resized in ascending sequence based on the order variable.

Claims

1. A display method for displaying table data in a computing device, columns of the table having been assigned relative priorities between them, the method comprising:

comparing a desired table width to a sum of minimum permissible display widths for all columns of the table;

if the table width exceeds the sum of minimum widths, then in an order determined by a relative priority among the columns;

assigning a new display width to each respective column according to the relative priority and equal to a minimum width defined for the column and a portion of a slack,

wherein the new display width assigned to each column does not exceed a maximum width previously defined for the respective column; and

displaying the table using the assigned display widths of the columns.

2. The method of claim 1, wherein the table width is determined by a size of a display on which the table is rendered.

3. The method of claim 1, wherein the table width is determined from a size of an application window in which the table is rendered.

4. The method of claim 3, further comprising:

repeating the method when the application window is resized.

5. The method of claim 1, wherein the table width is determined from a user input.

6. The method of claim 1, wherein the minimum width, the maximum width and the relative priority of each column is stored in a column properties database.

7. The method of claim 1, wherein the device is a personal computer.

8. The method of claim 1, wherein the device is a personal digital assistant.

9. The method of claim 1, wherein the device is a tablet computer.

10. The method of claim 1, wherein the device is a cellular phone.

11. The method of claim 1, wherein the slack is the difference between the sum of the minimum widths and the table width.

12. The method of claim 11, wherein an original slack represents the slack being initialized to zero.

13. The method of claim 12, wherein the original slack is incremented by a difference between the maximum column width and the minimum column width.

14. The method of claim 13, wherein an available slack is determined for all columns of the table in order to resize the table.

15. The method of claim 14, wherein the available slack is determined as a difference between the display width and the minimum column width.

16. The method of claim 15, wherein the portion of the slack is equal to:

a difference between the minimum and maximum column width multiplied by a quotient of the available slack and the original slack.

17. The method of claim 1, wherein the relative priority is determined by column orders, the column orders being represented by positive integers varying from low to high.

18. The method of claim 17, wherein the columns having low column orders are assigned new display widths first, the width of columns having high column orders being maintained as long as possible.

19. The method of claim 18, wherein if the available slack is zero, the columns having high column orders may be set to not be displayed if the table has insufficient available space.

20. The method of claim 18, wherein the new display width is equal to:

a sum of the minimum column width and difference between the minimum and maximum column width multiplied by a quotient of an available slack for the low order columns and an original slack for the low order columns.

21. A system of resizing columns in a table, comprising:

a terminal;

a browser configured to execute on the terminal; and

a processor, the processor configured to;

compare a desired table width to a sum of minimum permissible display widths for all columns of the table;

if the table width exceeds the sum of minimum widths, then in an order determined by a relative priority among the columns;

assign a new display width to each respective column according to the relative priority and equal to a minimum width defined for the column and a portion of a slack,

wherein the new display width assigned to each column does not exceed a maximum width previously defined for the respective column; and

display the table on the browser using the display widths of the columns.

22. A system of claim 21, wherein the table width is determined by a size of a display on which the table is rendered.

23. A system of claim 21, wherein the table width is determined from a size of an application window in which the table is rendered.

24. A system of claim 23, wherein the processor is further configured to,

repeat the method when the application window is resized.

25. A system of claim 21, wherein the table width is determined from a user input.

26. A system of claim 21, wherein the minimum width, the maximum width and the relative priority of each column is stored in a column properties database.

27. A system of claim 21, wherein the device is a personal computer.

28. A system of claim 21, wherein the device is a personal digital assistant.

29. A system of claim 21, wherein the device is a tablet computer.

30. A system of claim 21, wherein the device is a cellular phone.

31. The method of claim 21, wherein the slack is a difference between the sum of minimum widths and the table width.