Storing objects in a spreadsheet

• US 20020091871A1
• Filed: 01/05/2001
• Published: 07/11/2002
• Est. Priority Date: 01/05/2001
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Cahill, Jason, Allen, Jason
• Granted Patent: US 6,779,151 B2
• Time in Patent Office: Days
• US Class Current: 719/315
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A spreadsheet application provides a rich programming and modeling environment. The spreadsheet application of the present invention does this by recognizing a new “object” data type in addition to the conventional spreadsheet data types: numbers, text, date, Boolean, and error. The object data type can be used to create an instance of an external object and store the object in a cell of a spreadsheet. Once an object has been created in a spreadsheet, the object can be invoked or accessed from any other cell or formula in the spreadsheet. The spreadsheet application of the present invention provides several special object functions that operate to enable a user to create and invoke an object. A user can directly call functions from objects that are installed on a local or remote machine, by integrating an object function within a spreadsheet formula. Thus, the user is provided with a tool for integrating outside data services into a spreadsheet and may take advantage of pre-existing objects.

Claims

1. A method for embedding an external object in a spreadsheet cell of a spreadsheet object, the method comprising the steps of:

receiving as input, an object function having an external object identifier;

parsing the object function to determine whether the object function is valid and has a proper syntax;

accessing the external object identified by the external object identifier, to determine whether the external object is functional;

storing an embedded object in the spreadsheet cell, in response to a determination that the object function is valid and has a proper syntax;

recalculating the spreadsheet cell, in response to a determination that the external object is functional.

2. A computer readable medium having stored thereon computer-executable instructions for performing the method of claim 1.

3. The method of claim 1, wherein the object function is a CREATEOBJECT function.

4. The method of claim 1, wherein the object function is a HOST function.

5. The method of claim 1, wherein the object function is a XMLDOM function.

6. The method of claim 1 further comprising the steps of:

receiving as input a reference object function identifying the embedded object and a property of the embedded object;

storing the reference object function in a second spreadsheet cell;

determining the value of a property of the embedded object and storing the value of the property in association with the second spreadsheet cell.

7. The method of claim 1, wherein the step of accessing the external object is accomplished by use of a component management system.

8. The method of claim 7, wherein the component management system has a brokering interface and an automation interface.

9. The method of claim 1 further comprising the step of registering the spreadsheet object with a notification interface to receive a notification when the external object is modified.

10. The method of claim 9, further comprising the step of recalculating the spreadsheet cell in response to receiving a notification that the external object has been modified.

11. In a computer system having a graphical user interface including a display and a user interface selection device, a spreadsheet component having an object function for invoking an external object, the spreadsheet component comprising:

a formula parser component operative to compare the object function to a function library to determine whether the object function conforms to a predefined syntax contained in a library entry associated with the object function and operative to determine whether the object function properly identifies the external object;

a recalculation component operative to invoke the external object identified by the object function, in response to a determination that the object function conforms to the predefined syntax and properly identifies the external object.

12. The spreadsheet component of claim 11, wherein invoking the external object comprises storing an embedded object in a cell of the spreadsheet object.

13. The spreadsheet component of claim 12, wherein the spreadsheet component further comprises a reference object function identifying the embedded object and a property of the embedded object.

14. The spreadsheet component of claim 13, wherein the spreadsheet component is operative to store a value of the property in association with a second spreadsheet cell..

15. The spreadsheet component of claim 11, wherein invoking the external object comprises retrieving information from the external object and storing the information in a cell of the spreadsheet object.

16. The spreadsheet component of claim 11, wherein the object function is a CREATEOBJECT function.

17. The spreadsheet component of claim 11, wherein the object function is a HOST function.

18. The spreadsheet component of claim 11, wherein the object function is an XMLDOM function.

19. The spreadsheet component of claim 11, wherein invoking the external object is accomplished by use of a component management system.

20. The spreadsheet component of claim 19, wherein the component management system has a brokering interface and an automation interface.

21. The spreadsheet component of claim 11, wherein invoking the external object comprises registering the spreadsheet object with a notification interface to receive a notification when the external object is modified.