Variable formatting of values
First Claim
Patent Images
1. A method for displaying different graphical icons for different values, comprising:
- displaying a graphical user interface (GUI) that presents options used to determine formatting for a range of values, comprising;
displaying a style user interface element that is used to receive a selection of a type of visual indicator to apply to the range of values; and
displaying formatting criteria user interface elements that are used to receive formatting criteria selections to apply to type of visual indicator based on values in the range of values, wherein the formatting criteria include a first format of the type of visual indicator correlated to a first value, a second format of the type of visual indicator correlated to a second value, and an interval of varying formats that vary in a spectrum from the first value format to the second value format;
applying the formatting criteria to the selected type of visual indicator and values within the range of values; and
displaying the values after applying the selected type of visual indicator and formatting criteria.
1 Assignment
0 Petitions
Accused Products
Abstract
Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value). Formats can include color-scale backgrounds, in-cell elements (e.g., icons and data bars), and other cell formats that can be varied with a value.
-
Citations
20 Claims
-
1. A method for displaying different graphical icons for different values, comprising:
-
displaying a graphical user interface (GUI) that presents options used to determine formatting for a range of values, comprising; displaying a style user interface element that is used to receive a selection of a type of visual indicator to apply to the range of values; and displaying formatting criteria user interface elements that are used to receive formatting criteria selections to apply to type of visual indicator based on values in the range of values, wherein the formatting criteria include a first format of the type of visual indicator correlated to a first value, a second format of the type of visual indicator correlated to a second value, and an interval of varying formats that vary in a spectrum from the first value format to the second value format; applying the formatting criteria to the selected type of visual indicator and values within the range of values; and displaying the values after applying the selected type of visual indicator and formatting criteria. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A nontransitory computer-readable memory having computer executable instructions for formatting a range of values according to a spectrum of formats, the instructions comprising:
-
displaying a graphical user interface; obtaining formatting criteria for a range of values from the graphical user interface, wherein the formatting criteria includes a first value format correlated to a first value, a second value format correlated to a second value, and an interval of varying formats that vary in a spectrum from the first value format to the second value format; determining whether a respective value for each value in the range of values is between the first value and the second value; and for each respective value between the first value and the second value, applying, to a display of each value, a respective format determined from a correlation of each respective value to a respective format in the spectrum of varying formats. - View Dependent Claims (11, 12, 13, 14, 15, 16)
-
-
17. A system for formatting a range of values according to a spectrum of values, comprising:
-
a processor; and a computer-readable medium having computer executable instructions stored thereon, wherein the computer executable instructions are configured for; displaying a graphical user interface; obtaining formatting criteria for a range of values from the graphical user interface, wherein the formatting criteria includes a first value format correlated to a first value, a second value format correlated to a second value, and an interval of varying formats that vary in a spectrum from the first value format to the second value format; determining whether a respective value for each value in the range of values is between the first value and the second value; and for each respective value between the first value and the second value, applying, to a display of each value, a respective format determined from a correlation of each respective value to a respective format in the spectrum of varying formats. - View Dependent Claims (18, 19, 20)
-
Specification