SYSTEM AND METHOD FOR ACCESSING RICH OBJECTS VIA SPREADSHEETS
First Claim
1. A method for providing access to a data object from within a spreadsheet included in a spreadsheet application, the method comprising:
- receiving a user input from a first cell of the spreadsheet via a service logic;
using a first computer, associating a data object with the first cell of the spreadsheet, wherein the data object has one or more parameters, and the first cell is identified by a first cell reference in a computer display device coupled to the first computer;
receiving a first input for a second cell of the spreadsheet, wherein the first input includes a portion of an expression and includes the first cell reference identifying the first cell;
in response to receiving the first input, retrieving the one or more parameters associated with the data object of the first cell as suggestions;
receiving a second input indicating that a particular suggestion was selected from the one or more parameters;
querying a database at a second computer to obtain a value for the particular suggestion in relation to the data object and causing displaying the value in the second cell.
7 Assignments
0 Petitions
Accused Products
Abstract
One embodiment of the present invention sets forth a method for providing access to a data object from within a spreadsheet included in a spreadsheet application. The method includes associating the data object with a first cell of the spreadsheet, wherein the data object is related to a parameter, and the first cell is identified by a cell reference, receiving an input that is related to a second cell of the spreadsheet and includes an expression that specifies the parameter and the first cell reference, and replacing the first cell reference specified by the expression with the data object, wherein a value for the second cell may be determined by applying the parameter to the data object specified in the expression.
72 Citations
20 Claims
-
1. A method for providing access to a data object from within a spreadsheet included in a spreadsheet application, the method comprising:
-
receiving a user input from a first cell of the spreadsheet via a service logic; using a first computer, associating a data object with the first cell of the spreadsheet, wherein the data object has one or more parameters, and the first cell is identified by a first cell reference in a computer display device coupled to the first computer; receiving a first input for a second cell of the spreadsheet, wherein the first input includes a portion of an expression and includes the first cell reference identifying the first cell; in response to receiving the first input, retrieving the one or more parameters associated with the data object of the first cell as suggestions; receiving a second input indicating that a particular suggestion was selected from the one or more parameters; querying a database at a second computer to obtain a value for the particular suggestion in relation to the data object and causing displaying the value in the second cell. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A non-transitory computer-readable storage medium storing instructions that, when executed by a processor, cause the processor to provide access to a data object from within a spreadsheet included in a spreadsheet application, by performing the steps of:
-
receiving a user input from a first cell of the spreadsheet via a service logic; using a first computer, associating a data object with the first cell of the spreadsheet, wherein the data object has one or more parameters, and the first cell is identified by a first cell reference in a computer display device coupled to the first computer; receiving a first input for a second cell of the spreadsheet, wherein the first input includes a portion of an expression and includes the first cell reference identifying the first cell; in response to receiving the first input, retrieving the one or more parameters associated with the data object of the first cell as suggestions; receiving a second input indicating that a particular suggestion was selected from the one or more parameters; querying a database at a second computer to obtain a value for the particular suggestion in relation to the data object and causing displaying the value in the second cell. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer system providing access to a data object from within a spreadsheet included in a spreadsheet application, comprising:
-
a first computing device that includes a memory and a processor configured to; receiving a user input from a first cell of the spreadsheet via a service logic; using a first computer, associating a data object with the first cell of the spreadsheet, wherein the data object has one or more parameters, and the first cell is identified by a first cell reference in a computer display device coupled to the first computer; receiving a first input for a second cell of the spreadsheet, wherein the first input includes a portion of an expression and includes the first cell reference identifying the first cell; in response to receiving the first input, retrieving the one or more parameters associated with the data object of the first cell as suggestions; receiving a second input indicating that a particular suggestion was selected from the one or more parameters; querying a database at a second computer to obtain a value for the particular suggestion in relation to the data object and causing displaying the value in the second cell. - View Dependent Claims (18, 19, 20)
-
Specification