Value-driven visualization primitives for tabular data of spreadsheets

• US 9,665,554 B2
• Filed: 11/05/2012
• Issued: 05/30/2017
• Est. Priority Date: 09/02/2009
• Status: Expired due to Fees

• Current Assignee: NRI R&D Patent Licensing, LLC (Advanced Touchscreen and Gesture Technologies, LLC)
• Original Assignee: NRI R&D Patent Licensing, LLC (Advanced Touchscreen and Gesture Technologies, LLC)
• Inventors: Ludwig, Lester F.
• Primary Examiner(s): Debrow, James J
• Application Number:
  US13/669,431
• Publication Number:
  US 20130185619A1
• Time in Patent Office: 1,667 Days
• Field of Search: 715212
• 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

A method comprising obtaining a plurality of values from tabular data, computing a plurality of visual parameters, responsive to an associated data value, each visual parameter determined according to one or more of a user-specified selection of cells, a user-specified color visual effect, a user-specified range of color variation, and a corresponding user-specified range of data values, automatically calculating one or more variations of the color visual effect, controlling the color visual effect rendered on at least a portion of the tabular data responsive to the at least one visual parameter, and rendering the color effect within the cells of the portion of the tabular data to visually supplement the display of the portion of the tabular data responsive to at least one data value comprised by the user specified selection of cells.

Claims

1. A method for multiple parameter visualization of tabular data of an electronic spreadsheet, the electronic spreadsheet comprising cells arranged in rows and columns, each cell comprising an associated data value, the method comprising:

obtaining a plurality of data values from the tabular data;

computing a plurality of visual parameters, each responsive to an associated one of the a plurality of data values, wherein each visual parameter is a number within a range of numbers and is determined according to;

a user-specified selection of cells,

a user-specified color visual effect,

a user-specified range of color variation, the color variation comprising a plurality of at least two automatically-generated colors within the range that are not specified by the user, and

a corresponding user-specified range of data values;

automatically calculating one or more variations of the color visual effect, without requiring user specification, each variation color visual effect responsive to at least one data value comprised by the user specified selection of cells;

controlling the color visual effect rendered on at least a portion of the tabular data responsive to at least one visual parameter; and

rendering the color visual effect within the cells of the portion of the tabular data to visually supplement the display of the portion of the tabular data responsive to at least one data value comprised by the user specified selection of cells,

wherein the color employed in the color visual effect automatically varies over the user-specified range of color visual effect variation without having to be specified by the user,

wherein the color value of each color visual effect imposed in a cell is not solely determined by the data value comprised by that cell, and

wherein each cell according displays a data value comprised by that cell and a color effect representing information not solely determined by the data value comprised by that cell.

2. The method of claim 1 wherein the color visual effect comprises controlling a color of a font.

3. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising a font style of the selected tabular data.

4. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising a number of displayed decimal places of the selected tabular data.

5. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising a thickness a border of the selected tabular data.

6. The method of claim 5 wherein the border encompasses the selected tabular data.

7. The method of claim 1 wherein the color visual effect additionally comprises displaying a background texture of the selected tabular data.

8. The method of claim 1 wherein the color visual effect additionally comprises aligning the at least one data value within the selected tabular data.

9. The method of claim 1 wherein the color visual effect additionally comprises appending a symbol to the at least one data value displayed in the selected tabular data.

10. The method of claim 1 wherein the color visual effect is applied to the at least one of the row and the column of the selected tabular data.

11. The method of claim 1 wherein the color visual effect comprises controlling a color of a background comprised by the selected tabular data.

12. The method of claim 1 wherein the color visual effect comprises controlling a color of a border comprised by the selected tabular data.

13. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising a font size of the selected tabular data.

14. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising a font embellishment of the selected tabular data.

15. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising displaying a symbol in the selected tabular data.

16. The method of claim 1 wherein the color visual effect is supplemented with another visual effect comprising displaying an image in the selected tabular.

17. The method of claim 1, wherein each visual parameter is additionally determined according a user-specified numerically calculated mathematical function, the mathematical function operating on at least one of the data values comprised by the user-specified selection of cells.

18. The method of claim 1, wherein the portion of the tabular data overlaps the user-specified selection of cells.

19. The method of claim 1, wherein the portion of the tabular data does not overlap the user-specified selection of cells.