System and method for accessing rich objects via spreadsheets

• US 9,280,532 B2
• Filed: 08/02/2011
• Issued: 03/08/2016
• Est. Priority Date: 08/02/2011
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Cicerone, Derek Michael
• Primary Examiner(s): Stork, Kyle
• Assistant Examiner(s): Jung, Seung
• Application Number:
  US13/196,788
• Publication Number:
  US 20130036346A1
• Time in Patent Office: 1,680 Days
• Field of Search: 715/212, 715/215, 715/217, 715/219, 715/220
• US Class Current: 1/1
• CPC Class Codes: G06F 16/3322 using system suggestions G06F16/3325 takes precedence
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/274 Converting codes to words; Guess-ahead of partial word inputs

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.

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;

transmitting the user input, from the service logic to an input receiving logic in a server, for evaluating the user input with a plurality of data objects in an object model, and returning a data object from the plurality of data objects;

using a first computer, associating the 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, and causing displaying the one or more suggested parameters in association with the second cell;

receiving a second input indicating that a particular suggestion was selected from the one or more suggested parameters;

associating the particular suggestion with the second cell in the portion of the expression;

replacing the first cell reference specified in the expression in the second cell with a reference to the data object associated with the first cell;

based on the expression comprising the reference to the data object and the particular suggestion, determining a value by querying a database at a second computer to obtain the value for the particular suggestion in relation to the data object and causing displaying the value in the second cell.

2. The method of claim 1, wherein, prior to providing the one or more suggested parameters, establishing that the first cell reference specified by the portion of the expression identifies the first cell, the first cell is associated with the data object, and that the data object is related to the one or more suggested parameters.

3. The method of claim 1, further comprising, prior to replacing the first cell reference, performing a collision check to confirm that the particular suggestion, in fact, specifies the first cell reference as opposed to a different type of reference having the same text as the first cell reference.

4. The method of claim 3, wherein performing the collision check comprises determining that the particular suggestion is not associated with metadata indicating that the particular suggestion specifies a different type of expression having the same text as the first cell reference.

5. The method of claim 1, wherein associating the data object with the first cell comprises storing a first object reference corresponding to the data object in the first cell.

6. The method of claim 1, wherein, once the value for the second cell is determined, each time the parameter related to the data object is updated, the value for the second cell is also updated.

7. The method of claim 1, wherein, once the value for the second cell is determined, each time the first cell is updated, the value for the second cell is also updated.

8. The method of claim 1, wherein the data object represents a type of financial instrument associated with an entity traded in a financial market.

10. The method of claim 1, further comprising causing to replace the particular suggestion in the second cell with the value.

11. The method of claim 1, wherein the particular suggestion specifies a call to the database containing trading data of a financial market.

9. A non-transitory computer-readable 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;

transmitting the user input, from the service logic to an input receiving logic in a server, for evaluating the user input with a plurality of data objects in an object model, and returning a data object from the plurality of data objects;

associating, using a first computer, the 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, and causing displaying the one or more suggested parameters in association with the second cell;

receiving a second input indicating that a particular suggestion was selected from the one or more suggested parameters;

associating the particular suggestion with the second cell in the portion of the expression;

replacing the first cell reference specified in the expression in the second cell with a reference to the data object associated with the first cell;

based on the expression comprising the reference to the data object and the particular suggestion, determining a value by querying a database at a second computer to obtain the value for the particular suggestion in relation to the data object and causing displaying the value in the second cell.

12. The non-transitory computer-readable medium of claim 9, wherein, prior to providing the one or more suggested parameters, establishing that the first cell reference specified by the portion of the expression identifies the first cell, the first cell is associated with the data object, and that the data object is related to the one or more suggested parameters.

13. The non-transitory computer-readable medium of claim 9, further comprising, prior to replacing the first cell reference, performing a collision check to confirm that the particular suggestion, in fact, specifies the first cell reference as opposed to a different type of reference having the same text as the first cell reference.

14. The non-transitory computer-readable medium of claim 13, wherein performing the collision check comprises determining that the particular suggestion is not associated with metadata indicating that the particular suggestion specifies a different type of expression having the same text as the first cell reference.

15. The non-transitory computer-readable medium of claim 9, wherein associating the data object with the first cell comprises storing a first object reference corresponding to the data object in the first cell.

16. The non-transitory computer-readable medium of claim 9, wherein, once the value for the second cell is determined, each time the parameter related to the data object is updated, the value for the second cell is also updated.

17. The non-transitory computer-readable medium of claim 9, wherein, once the value for the second cell is determined, each time the first cell is updated, the value for the second cell is also updated.

18. The non-transitory computer-readable medium of claim 9, wherein the data object represents a type of financial instrument associated with an entity traded in a financial market.

19. The non-transitory computer-readable medium of claim 9, further storing additional instructions which, when executed cause replacing the particular suggestion in the second cell with the value.

20. The non-transitory computer-readable medium of claim 9, wherein the particular suggestion specifies a call to the database containing trading data of a financial market.

21. A computer system, comprising:

a first computing device that includes a memory and a processor configured to;

receive a user input from a first cell of a spreadsheet via a service logic;

transmit the user input, from the service logic to an input receiving logic in a server, for evaluating the user input with a plurality of data objects in an object model, and return a data object from the plurality of data objects;

associate the 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;

receive 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, retrieve the one or more parameters associated with the data object of the first cell as suggestions, and cause displaying the one or more suggested parameters in association with the second cell;

receive a second input indicating that a particular suggestion was selected from the one or more suggested parameters;

associate the particular suggestion with the second cell in the portion of the expression;

replace the first cell reference specified in the expression in the second cell with a reference to the data object associated with the first cell;

based on the expression comprising the reference to the data object and the particular suggestion, determine a value by querying a database at a second computer to obtain the value for the particular suggestion in relation to the data object and cause displaying the value in the second cell.

22. The computer system of claim 21, wherein the processor is further configured to cause replacing the particular suggestion in the second cell with the value.

23. The computer system of claim 21, wherein the particular suggestion specifies a call to the database containing trading data of a financial market.