System and method for formatting a cell in response to data stored in a separate location
A data cell included in a document supporting cell structured data is conditionally formatted according to data that is stored in a separate location from the document. A user is allowed to select from a drop-down menu of related data sets a particular data set for conditionally formatting the data cell. The data cell is formatted according to the data set and the condition without requiring that the data set be stored locally in the document.
1. A computer-readable medium excluding all signals having stored thereon a data structure, comprising:
data cells comprising data that are stored in a first location in a spreadsheet or document;
data sets stored externally in a second location other than in the spreadsheet or document and that is different from the spreadsheet or document, wherein at least one of the data sets stored in the second location is related to at least one of the data cells stored in the first location in the spreadsheet or document but are not the same values displayed in a different format; and
a user interface instantiated in response to a user selection to format the data of the at least one data cell in the first location, wherein the user interface displays one or more options of data sets, including displaying at least one option of the data sets that is stored in the second location other than the spreadsheet or document and that is related to the at least one data cells cell in the first location such that a user selection of one of the data sets results in the at least one data cells cell in the first location in the spreadsheet or document being formatted using-based on values from the selected data set from other than the spreadsheet or document without changing a value of the at least one data cell in the first location.
2. The computer-readable medium of claim 1 , wherein the user interface further includes a formatting type selection that is applied to the formatting of the data cell in response to a user selecting the formatting type selection.
3. The computer-readable medium of claim 2 , wherein the formatting type selection provides a visual indication reflecting the data set while avoiding storing the data set within the first location.
4. The computer-readable medium of claim 1 , wherein the formatting type selection includes at least one of a color scheme, a data bar, and an icon indicator.
5. The computer-readable medium of claim 1 , wherein the user interface applies a condition to the formatting of the data cell, wherein the condition defines the applicability of the related data set to the data cell.
6. The computer-readable medium of claim 5 , wherein the condition is one of: a Boolean condition and a range-based condition.
7. The computer-readable medium of claim 1 , wherein relationships between the data sets and the data cell is managed by a server.
8. The computer-readable medium of claim 1 , wherein the data cell is displayed within the spreadsheet.
9. A computer-readable storage medium excluding all signals storing computer-executable instructions for formatting data cells in response to data stored in a separate location, comprising:
displaying data cells comprising data, wherein the data of the data cells are stored in a first location in a spreadsheet or document;
accessing data sets stored externally in a second location other than in the spreadsheet or document, and
instantiating a user interface used to format the data of at least one of the data cells according to a formatting dependency on one of the data sets, wherein the user interface displays one or more options of the accessed data sets, including displaying at least one option of the data sets that is stored in the second location other than the spreadsheet or document such that a user selection of one of the data sets results in at least one of the displayed data cells in the first location in the spreadsheet or document being formatted based on values from the selected data set from other than the spreadsheet or document without changing a value of the at least one data cell in the first location.
10. The computer-readable medium of claim 9 , wherein the user interface further includes a formatting type selection that is applied to the formatting of the data cells in response to a user selecting the formatting type selection.
11. The computer-readable medium of claim 10 , wherein the formatting type selection provides a visual indication reflecting the data set while avoiding storing the data set within the first location.
12. The computer-readable medium of claim 9 , wherein the formatting type selection includes at least one of a color scheme, a data bar, and an icon indicator.
13. The computer-readable medium of claim 9 , wherein the user interface applies a condition to the formatting of the data cells, wherein the condition defines the applicability of the related data set to the data cells.
14. The computer-readable medium of claim 13 , wherein the condition is one of: a Boolean condition and a range-based condition.
15. The computer-readable medium of claim 9 , wherein relationships between the data sets and the data cells is managed by a server.
16. A method for formatting a cell in response to a data set stored in a separate location, comprising:
displaying a data cell comprising data, wherein the data of the data cell is stored in a first location in a spreadsheet or document;
accessing data sets stored externally in a second location other than in the spreadsheet or document that comprise different data, and
instantiating a user interface used to format the data of the data cell, wherein the user interface displays one or more options of the accessed data sets, including displaying at least one option of the data sets that is stored in the second location other than the spreadsheet or document such that a user selection of one of the data sets results in the displayed data of the data cell in the first location in the spreadsheet or document being formatted based on values from the selected data set from other than the spreadsheet or document without storing the different data of the one or more data sets within the data cell in the spreadsheet or document and without changing a value of the at least one data cell in the first location.
17. The method of claim 16 , wherein the user interface further includes a formatting type selection that is applied to the formatting of the data cells in response to a user selecting the formatting type selection.
18. The method of claim 17 , wherein the formatting type selection provides a visual indication reflecting the data set while avoiding storing the data set within the first location.
19. The method of claim 16 , wherein the formatting type selection includes at least one of a color scheme, a data bar, and an icon indicator.
20. The method of claim 16 , wherein the user interface applies a condition to the formatting of the data cells, wherein the condition defines the applicability of the related data set to the data cell.