Method and system to associate cell and item metadata
The present invention generally relates to new and improved embodiments of methods and systems for capturing and providing arbitrarily rich data to be stored or manipulated within a spreadsheet. In one embodiment of the present invention, a method for creating spreadsheet metadata comprises receiving an item in a spreadsheet, receiving item metadata about the item, and associating the item metadata with the item to create spreadsheet metadata.
1. A computer-readable storage medium storing computer-executable instructions for executing a computer implemented method for creating spreadsheet metadata, the method comprising:
receiving an item in a cell contained in a spreadsheet;
receiving item metadata about the item;
associating the item metadata with the item to create spreadsheet metadata; and
storing the item in a cell table, wherein the cell table includes an item data table and a metadata table wherein the item data table is divided into a first section and a second section, the first section of the item data table storing location information about the cell and the second section of the item data table storing the item contained in the cell, wherein the metadata table stores information about the spreadsheet and is divided into a first section and a second section, the first section of the metadata table storing cell metadata and the second section of the metadata table storing the item metadata, wherein the cell metadata comprises a cell metadata type section and a cell metadata information section, and wherein the item metadata comprises an item metadata type section and an item metadata information section.
2. The computer-readable storage medium defined in claim 1 , wherein receiving item metadata further comprises:
receiving an input related to the item; and
automatically creating the item metadata incident to the input.
3. The computer-readable storage medium defined in claim 1 , further comprising:
receiving the cell metadata about the one or more cells containing the item; and
associating the cell metadata with the one or more cells.
4. The computer-readable storage medium defined in claim 1 , wherein storing the item in a cell table further comprises:
storing the item metadata with the item in the cell table.
5. The computer-readable storage medium defined in claim 1 , further comprising:
receiving an input to perform an operation on an item: and
altering the performance of the operation in response to item metadata.
6. A computer system for creating spreadsheet metadata, the system comprising:
one or more processors for executing computer executable instructions;
one or more computer readable storage media storing instructions that when executed by any one or more processors perform a method comprising:
receiving an item in a cell contained in a spreadsheet;
receiving item metadata about the item;
associating the item metadata with the item to create spreadsheet metadata; and
storing the item in a cell table, wherein the cell table includes an item data table and a metadata table wherein the item data table is divided into a first section and a second section, the first section of the item data table storing location information about the cell and the second section of the item data table storing the item contained in the cell, wherein the metadata table stores information about the spreadsheet and is divided into a first section and a second section, the first section of the metadata table storing cell metadata and the second section of the metadata table storing the item metadata, wherein the cell metadata comprises a cell metadata type section and a cell metadata information section, and wherein the item metadata comprises an item metadata type section and an item metadata information section.
7. The computer system defined in claim 6 , wherein receiving item metadata further comprises:
receiving an input related to the item; and
automatically creating the item metadata incident to the input.
8. The computer system defined in claim 6 , wherein the method further comprises:
receiving the cell metadata about the one or more cells containing the item; and associating the cell metadata with the one or more cells.
9. The computer system defined in claim 6 , wherein the storing the item in a cell table further comprises:
storing the item metadata with the item in the cell table.
10. The computer-readable storage medium defined in claim 1 , wherein the cell metadata contains information about the cell and wherein the item metadata contains information about the item contained in the cell.
11. A method of performing an operation on data contained in a spreadsheet, the method comprising:
receiving a first data item in one or more cells of a spreadsheet;
receiving metadata about the first item;
associating the metadata with the first item to create spreadsheet data;
storing the first data item and the metadata of the first item in a cell table, wherein the cell table includes an item data table and a metadata table wherein the item data table is divided into a first section and a second section, the first section of the item data table storing location information about the cell and the second section of the item data table storing the item contained in the cell, wherein the metadata table stores information about the spreadsheet and is divided into a first section and a second section, the first section of the metadata table storing cell metadata and the second section of the metadata table storing item metadata, wherein the cell metadata comprises a cell metadata type section and a cell metadata information section, and wherein the item metadata comprises an item metadata type section and an item metadata information section.