Method and system to associate cell and item metadata

• US 7,693,860 B2
• Filed: 03/18/2005
• Issued: 04/06/2010
• Est. Priority Date: 03/18/2005
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Babanov, Alexander A., Ellis, Charles D., Dickerman, Howard J., Hawking, Robert G.
• Primary Examiner(s): Pham; Khanh B
• Assistant Examiner(s): CHEEMA, AZAM M
• Application Number:
  US11/083,492
• Publication Number:
  US 20060212469A1
• Time in Patent Office: 1,845 Days
• Field of Search: None
• US Class Current: 715/212
• CPC Class Codes: G06F 40/169 Annotation, e.g. comment data or footnotes
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

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.

Claims

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.

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.

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.

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.