Sizeable window for tabular and graphical representation of data

• US 5,847,706 A
• Filed: 11/30/1995
• Issued: 12/08/1998
• Est. Priority Date: 11/30/1995
• Status: Expired due to Term

• Current Assignee: Viavi Solutions, Inc. (Lumentum Holdings Inc.)
• Original Assignee: Hewlett Packard Company (HP Inc.)
• Inventors: Kingsley, Paul Michael
• Primary Examiner(s): Kim, Matthew M.
• Assistant Examiner(s): dela Torre, Crescelle N.
• Application Number:
  US08/564,849
• Time in Patent Office: 1,104 Days
• Field of Search: 395/342, 395/339, 395/340, 395/341, 395/343, 345/119, 345/342, 345/339, 345/340, 345/341, 345/343, 345/118
• US Class Current: 715/788
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G09G 5/14 Display of multiple viewports

Abstract

A system and method for resizing a window, containing a first display for displaying first data in a first format and a second display for displaying second data in a second format, to a height and a width, thereby creating a resized window. The system determines whether the first display can be drawn to a first scale thereby ensuring that the first display will fit within the resized window. If the first display will fit within the resized window, then the system draws the first display to the first scale. The system draws to a second scale the second display to a remaining area of the resized window after the first display is drawn. The second scale will consist of the entire window if the first display cannot be drawn to the first scale. The invention resizes the first display and the second display within the resized window to ensure a useful presentation of data.

Claims

1. A computer system for resizing a window containing a first display for displaying a first data in a tabular format and a second display for displaying a second data in a graphical format, to a height and a width thereby creating a resized window, comprising:

first drawing means for drawing within the resized window a resized first display to a first scale having a first height and a first width that fits within the resized window with said first data in the tabular format rescaled to conform to said resized first display, said resized first display drawn only when said first height is greater than a predetermined minimum height threshold representing a height below which the first data is considered to be unreadable in the tabular format; and

second drawing means for drawing a resized second display within the resized window to a second scale having a second height and a second width to fill the height and a remaining width of the resized window, wherein the second data in the graphical format is rescaled to conform to said resized second display.

2. A computer system according to claim 1, wherein said computer system further comprising:

zoom determining means for determining if the resized window is zoomed; and

zoom drawing means for drawing a zoomed view of the first display and the second display to the resized window if said zoom determining means determines that the resized window is zoomed.

3. A computer system according to claim 1,

wherein said tabular format comprises a tabular representation of the first data in a spreadsheet, wherein said spreadsheet comprises a plurality of rows, and

wherein said graphical format comprises a graphical representation of one or more data values in said spreadsheet.

4. A computer system according to claim 3, wherein said first drawing means comprises means for drawing the first display to a constant width, and

wherein said first drawing means does not draw the first display when the width of the resized window is less than said constant width.

5. A computer system according to claim 3, wherein said first drawing means comprises:

means for proportionally adjusting said rows of said spreadsheet to fit within said first height of said resized first display.

6. A computer system according to claim 3, wherein said minimum height threshold is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size.

7. A computer system according to claim 6, wherein said given font style and size are constant and said required number of pixels are constant.

8. A computer system according to claim 6, wherein said given font style and size are not constant and further wherein said required number of pixels are dynamically determined.

9. A method for resizing a window on a computer screen, the window containing a first display for displaying first data in a tabular format and a second display for displaying second data in a graphical format, the resized window having a height and a width, the resized first display having a first width and a first height and the resized second display having a second width and a second height, the method comprising the steps of:

(a) determining whether the resized first display has a first height that is greater than a predetermined minimum height threshold representing a height below which the first data is unreadable when displayed in said tabular format;

(b) drawing to said first scale the first display when said step (a) determines that said first height is greater than said predetermined minimum height threshold;

(c) resealing the first data in the tabular format to conform to the resized first display when said step (b) is performed;

(d) drawing a resized second display within the resized window to a second scale having a second height and a second width to fill the height and a remaining width of the resized window after said steps (b) and (c) are performed; and

(e) resealing the second data in the graphical format within the second display to conform to said resized second display.

10. A method according to claim 9, further comprising the steps of:

(f) determining, prior to said step (a), whether the resized window is zoomed; and

(g) drawing, prior to said step (a) and after said step (d), a zoomed view of the first resized display and the second resized display to the resized window when said step (d) determines that the resized window is zoomed.

11. A method according to claim 9, wherein said minimum height threshold is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size.

12. A method according to claim 11, wherein said given font style and size are constant and said required number of pixels are constant.

13. A method according to claim 9, wherein said first width is a constant width, the method further comprising the steps of:

(f) determining, prior to said step (b), whether said constant width is less than or equal to the width of the resized window;

wherein said step (b) further includes the step of;

(1) drawing the first resized display to said constant width when said step (d) determines that said constant width is less than or equal to said resized window width.

14. A method according to claim 9, wherein said tabular format includes a plurality of rows of data, and wherein said step (b) comprises the step of:

(1) proportionally adjusting a plurality of rows of the first display to fit within the height of the resized window.

15. A computer program product for use with a windows environment, including a computer usable medium having computer readable program code means embodied in said medium for enabling a computer to resize a window containing a first display for displaying first data in a tabular format and a second display for displaying second data in a graphical format, to a height and a width thereby creating a resized window, said computer program product comprising:

first computer readable program code means for drawing within the resized window a resized first display to a first scale having a first height and a first width that fits within the resized window with said first data in the tabular format resealed to conform to said resized first display, said resized first display drawn only when said first height is greater than a predetermined minimum height threshold representing a height below which the first data is considered to be unreadable in the tabular format; and

second computer readable program code means for drawing a resized second display within the resized window to a second scale having a second height and a second width to fill the height and a remaining width of the resized window, wherein the second data in the graphical format is resealed to conform to said resized second display.

16. A computer program product according to claim 15, wherein said minimum height threshold is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size.

17. A computer program product according to claim 16, wherein said given font style and size are constant and said required number of pixels are constant.

18. A computer program product according to claim 15, wherein said computer program product further comprises:

third computer readable program code means for enabling a computer to determine if the resized window is zoomed; and

fourth computer readable program code means for enabling a computer to draw a zoomed view of the first display and the second display to the resized window if said third computer readable program code means determines that the resized window is zoomed.

19. A computer program product according to claim 15,

wherein said tabular format comprises a tabular representation of the first data in a spreadsheet, wherein said spreadsheet comprising a plurality of rows, and

wherein said graphical format comprises a graphical representation of one or more data values in said spreadsheet.

20. A computer program product according to claim 19, wherein said first drawing means comprises means for drawing the first display to a constant width, and

wherein said first drawing means does not draw the first display when the width of the resized window is less than said constant width.

21. A computer program product according to claim 19, wherein said second computer readable program code means comprises means for enabling a computer to proportionally adjusting said rows of said spreadsheet to fit within said first height of said resized first display.

22. A computer program product for use with a windows environment, said computer program product comprising:

a computer usable medium having computer readable program code method steps embodied in said medium for resizing a window on a computer screen, the window containing a first display for displaying first data in a tabular format and a second display for displaying second data in a graphical format, the resized window having a height and a width, the resized first display having a first width and a first height and the resized second display having a second width and a second height, the method steps comprising the steps of;

(a) determining whether the resized first display has a first height that is greater than a predetermined minimum height threshold representing a height below which the data is unreadable when displayed in said tabular format;

(b) drawing to said first scale the first display when said step (a) determines that said first height is greater than said predetermined minimum height threshold;

(c) resealing the first data in the tabular format to conform to the resized first display when said step (b) is performed;

(d) drawing a resized second display within the resized window to a second scale having a second height and a second width to fill the height and a remaining width of the resized window after said steps (b) and (c) are performed; and

(e) resealing the second data in the graphical format within the second display to conform to said resized second display.

23. A computer program product according to claim 22, wherein said minimum height threshold is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size.

24. A computer program product according to claim 22, wherein said first width is a constant width, the method further comprising the step of:

(f) determining, prior to said step (b), whether said constant width is less than or equal to the width of the resized window;

wherein said step (b) further includes the step of;

(1) drawing the first resized display to said constant width when said step (d) determines that said constant width is less than or equal to said resized window width.

25. A computer program product according to claim 22, wherein said tabular format includes a plurality of rows of data, and wherein said step (b) comprises the step of:

(1) proportionally adjusting a plurality of rows of the first display to fit within the height of the resized window.

26. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform the means for resizing a window containing a first display for displaying a first data in a tabular format and a second display for displaying a second data in a graphical format, to a height and a width thereby creating a resized window, said program storage device comprising:

first drawing means for drawing within the resized window a resized first display to a first scale having a first height and a first width that fits within the resized window with said first data in the tabular format resealed to conform to said resized first display, said resized first display drawn only when said first height is greater than a predetermined minimum height threshold representing a height below which the first data is considered to be unreadable in the tabular format; and

second drawing means for drawing a resized second display within the resized window to a second scale having a second height and a second width to fill the height and a remaining width of the resized window, wherein the second data in the graphical format is resealed to conform to said resized second display.

27. A program storage device according to claim 26, wherein said minimum height threshold is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size.

28. A program storage device according to claim 27, wherein said given font style and size are constant and said required number of pixels are constant.

29. A program storage device according to claim 26,

wherein said tabular format comprises a tabular representation of the first data in a spreadsheet, wherein said spreadsheet comprising a plurality of rows, and

wherein said graphical format comprises a graphical representation of one or more data values in said spreadsheet.

30. A program storage device according to claim 29, wherein said first drawing means comprises means for drawing the first display to a constant width, and

wherein said first drawing means does not draw the first display when the width of the resized window is less than said constant width.

31. A program storage device according to claim 29, wherein said first drawing means comprises:

means for proportionally adjusting said rows of said spreadsheet to fit within said first height of said resized first display.

32. A computer system for resizing a window containing a first display for displaying a first data in a first format and a second display for displaying a second data in a second format, to a height and a width thereby creating a resized window, comprising:

first drawing means for drawing within the resized window a resized first display to a first scale having a first height and a first width that fits within the resized window with said first data rescaled to conform to said resized first display, said resized first display drawn only when at least one of said first height and said first width is greater than a predetermined minimum height and width threshold, respectively, representing a dimension below which the first data is considered to be unreadable in said first format, said minimum height threshold being calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size; and

second drawing means for drawing a resized second display within the resized window to a second scale having a second height and a second width to fill a remaining height and width of the resized window, wherein the second data is rescaled to conform to said resized second display.

33. A computer system according to claim 32,

wherein said first format comprises a tabular representation of the first data in a spreadsheet, wherein said spreadsheet comprising a plurality of rows, and

wherein said second format comprises a graphical representation of one or more data values in said spreadsheet.

34. A method for resizing a window on a computer screen, the window containing a first display for displaying first data in a first format and a second display for displaying second data in a second format, the resized window having a height and a width, the resized first display having a first width and a first height and the resized second display having a second width and a second height, the method comprising the steps of:

(a) determining whether the resized first display has at least one of a first height or first width that is greater than a predetermined minimum height and width threshold, respectively, representing a dimension below which the data is unreadable when displayed in said first format, said minimum height threshold being is calculated from a number of visible rows multiplied by a number of pixels that a row requires to be readable for a given font style and size;

(b) drawing to said first scale the first display when said step (a) determines that said at least one of a first height or width is greater than said respective threshold;

(c) resealing the first data in the first format to conform to the resized first display when said step (b) is performed;

(d) drawing a resized second display within the resized window to a second scale having a second height and a second width to fill a remaining height and width of the resized window after said steps (b) and (c) are performed; and

(e) rescaling the second data in the second format within the second display to conform to said resized second display.