MANAGING EXTENSIBLE VALUE TYPES IN SPREADSHEET CELLS

• US 20090006466A1
• Filed: 06/09/2008
• Published: 01/01/2009
• Est. Priority Date: 12/09/2005
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Becker, Andrew, Chirilov, Joseph Matthew, Duzak, Jeffrey James, Petyon Jones, Simon Loftus, Ellis, Charles D.
• Application Number:
  US12/135,913
• Publication Number:
  US 20090006466A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Individual cells within a spreadsheet may contain an extensible value as defined by an extensible value type. The extensible value type is a third party user defined value type that is incorporated into the spreadsheet as a supported data type. When the extensible value type is defined, an associated set of functions are developed to operate on the type. The spreadsheet manages instances of these extensible values such that they are properly maintained by the spreadsheet application while in use and released from memory when they are no longer in use.

Claims

1. A computer-implemented method for managing extensible values, comprising:

accessing a cell of a spreadsheet that includes many cells;

determining when the cell returns an object that is an instance of an extensible value data type;

wherein the extensible value data type is a third party user defined data type;

maintaining the object in memory when the object is in use by at least one of the cells of the spreadsheet;

wherein the object is maintained in memory by the spreadsheet application; and

releasing the object when the object is no longer in use by the at least one of the cells of the spreadsheet;

wherein the object is released by the spreadsheet application.

2. The computer-implemented method of claim 1, wherein accessing the cell of the spreadsheet comprises determining when the cell includes an extensible value.

3. The computer-implemented method of claim 2, wherein determining when the cell returns the object that is the instance of the extensible value data type comprises determining when the extensible value is required to provide a value for the cell.

4. The computer-implemented method of claim 1, further comprising determining a number of cells of the spreadsheet that are using the object.

5. The computer-implemented method of claim 1, further comprising releasing the object when the number of cells of the spreadsheet that are using the object is zero.

6. The computer-implemented method of claim 1, further comprising utilizing a reference counting method to determine when an object is being used.

7. The computer-implemented method of claim 6, wherein the reference is incremented when calculation of a formula includes the extensible value and when the cell references another cell in the spreadsheet that includes the extensible value.

8. The computer-implemented method of claim 1, wherein the reference is decremented when an intermediate value of the evaluation of the formula evaluation is consumed;

when a formula whose result is the object is released; and

when the result of the evaluation of the formula is released.

9. A computer-readable storage medium having computer-executable instructions for interacting and managing extensible values within a spreadsheet, comprising:

determining when an extensible value defined by an extensible value data type created by a third party developer is included within a cell of the spreadsheet;

determining when an operation involves the extensible value; and

when the operation involves the extensible value;

maintaining an instance of the extensible value in memory when the instance is in use by at least one of the cells of the spreadsheet;

wherein the instance is maintained in memory by the spreadsheet application; and

releasing the instance when the instance is no longer in use by the at least one of the cells of the spreadsheet;

wherein the instance is released by the spreadsheet application.

10. The computer-readable storage medium of claim 9, wherein determining when the operation involves the extensible value comprises determining when the extensible value is used within a formula of the cell.

11. The computer-readable storage medium of claim 9, further comprising determining when at least one of the other cells in the spreadsheet references the extensible value within the cell.

12. The computer-readable storage medium of claim 9, further comprising keeping a count of a number of cells of the spreadsheet that are using the extensible value.

13. The computer-readable storage medium of claim 9, further comprising releasing the instance of the extensible value when no cells of the spreadsheet are using the extensible value.

14. The computer-readable storage medium of claim 9, determining when the operation involves the extensible value comprises determining when the operation is a conditional operation and determining when conditions of the conditional operation are satisfied;

and when the conditions are satisfied determining that the operation involves the extensible value.

15. The computer-readable storage medium of claim 9, further comprising utilizing a reference counting method to determine when the extensible value is being used within the spreadsheet;

wherein the reference is incremented when calculation of a formula includes the extensible value and is incremented when the cell references another cell in the spreadsheet that includes the extensible value.

16. The computer-readable storage medium of claim 9, wherein the reference is decremented when an intermediate value of the evaluation of the formula evaluation is consumed;

when a formula whose result is the object is released; and

when the result of the evaluation of the formula is released.

17. A system for managing extensible values included within a spreadsheet, comprising:

a processor that is configured to perform operations;

a spreadsheet application that is configured to perform steps, comprising;

determining when an extensible value is contained within a cell of the spreadsheet;

wherein the extensible value is defined by a third party user defined extensible value data type;

determining when an operation involves the extensible value; and

when the operation involves the extensible value;

maintaining an instance of the extensible value in memory when the instance is in use by at least one of the cells of the spreadsheet;

wherein the instance is maintained in memory by the spreadsheet application; and

releasing the instance when the instance is no longer in use by the at least one of the cells of the spreadsheet.

18. The system of claim 17, wherein determining when the operation involves the extensible value comprises determining when the extensible value is used in determining a value for the cell;

and wherein maintaining the instance and releasing the instance comprises utilizing a reference counting method to determine when to release the instance.

19. The system of claim 18, wherein utilizing the reference counting method comprises incrementing a reference for the instance when calculation of a formula includes the extensible value and is incrementing the reference when the cell references another cell in the spreadsheet that includes the extensible value.

20. The system of claim 18, wherein utilizing the reference counting method comprises decrementing the reference when an intermediate value of the evaluation of the formula evaluation is consumed;

decrementing the reference when a formula whose result is the object is released; and

decrementing the reference when the result of the evaluation of the formula is released.