Storing objects in a spreadsheet
First Claim
1. A method for embedding an external object in a spreadsheet cell of a spreadsheet object, the method comprising the steps of:
- receiving an object function as an input into a spreadsheet cell of a spreadsheet object to embed an external object in the spreadsheet cell, wherein the object function includes 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 receiving the object function as the input into the spreadsheet cell and a determination that the object function is valid and has a proper syntax; and
recalculating the spreadsheet cell, in response to a determination that the external object is functional.
2 Assignments
0 Petitions
Accused Products
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.
99 Citations
21 Claims
-
1. A method for embedding an external object in a spreadsheet cell of a spreadsheet object, the method comprising the steps of:
-
receiving an object function as an input into a spreadsheet cell of a spreadsheet object to embed an external object in the spreadsheet cell, wherein the object function includes 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 receiving the object function as the input into the spreadsheet cell and a determination that the object function is valid and has a proper syntax; and
recalculating the spreadsheet cell, in response to a determination that the external object is functional. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
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; and
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. A computer system having a graphical user interface including a display and a user interface selection device, the computer system comprising:
-
a spreadsheet component receiving an object function as an input into a cell of a spreadsheet object to embed an external object in the spreadsheet cell, wherein the object function includes an external object identifier 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 a data type of the external object in order to store an embedded object in the cell of the spreadsheet object wherein at least one data type comprises an object data type; and
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. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20, 21)
-
Specification