System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet

• US 5,893,123 A
• Filed: 06/22/1995
• Issued: 04/06/1999
• Est. Priority Date: 06/22/1995
• Status: Expired due to Fees

• Current Assignee: Uniresido Holdings LLC (Intellectual Ventures LLC)
• Original Assignee: Paul W. Tuinenga
• Inventors: Tuinenga, Paul W.
• Primary Examiner(s): Feild, Joseph H.
• Assistant Examiner(s): Young, John L.
• Application Number:
  US08/493,487
• Time in Patent Office: 1,384 Days
• Field of Search: 707/503, 707/504, 395/680, 395/682
• US Class Current: 715/209
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A system and method integrate a spreadsheet and an externally implemented program. The system includes a set of input cells in the spreadsheet, which contain input data for the external program; a set of transmission functions which reference the input cells; and a set of retrieval functions, which reference the transmission functions. A spreadsheet evaluation sequencer, which is part of the spreadsheet program, schedules execution of the transmission functions whenever input data changes, and schedules execution of the retrieval functions after the transmission functions have been executed, thereby effecting a seamless, two-way link between the spreadsheet and external program.

Claims

1. A system for integrating a spreadsheet program and an external program comprising:

an input cell in said spreadsheet, said input cell containing data used as input by said external program;

a transmission function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said transmission function as part of normal spreadsheet operation if said input cell is changed, said transmission function transmitting the data from said input cell to said external program; and

a retrieval function containing a reference to said transmission function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said transmission function, said retrieval function as part of normal spreadsheet operation retrieving output data from said external program, said output data calculated by said external program based upon said input data from said spreadsheet.

2. The system of claim 1, wherein said transmission function refers indirectly to said input cell.

3. The system of claim 1, wherein said retrieval function refers indirectly to said transmission function.

4. The system of claim 1, wherein said transmission function is implemented within said spreadsheet program.

5. The system of claim 1, wherein said transmission function is contained within a cell in a worksheet within said spreadsheet program.

6. The system of claim 1, wherein said transmission function is contained within a cell in a hidden worksheet within said spreadsheet program.

7. The system of claim 1, wherein said retrieval function is implemented within said spreadsheet program.

8. The system of claim 1, wherein said retrieval function is contained within a cell in a worksheet within said spreadsheet program.

9. The system of claim 1, wherein said transmission function is called as an Object Linking and Embedding Automation method of said external program.

10. The system of claim 1, wherein said retrieval function is called as an Object Linking and Embedding Automation method of said external program.

11. The system of claim 1, wherein said external program is input dependent.

12. The system of claim 1, wherein said external program is an electrical circuit simulator program.

13. The system of claim 1, wherein said transmission function also transmits additional information regarding said input cell to said external program.

14. The system of claim 1, wherein said external program is implemented, in part, as an embeddable document within said spreadsheet.

15. A method for providing spreadsheet-style interface and control for an input dependent external program, comprising the steps of:

providing a spreadsheet containing input data for use by said program;

making a first function call from said spreadsheet program to said external program, said first function call made automatically by said spreadsheet as part of normal spreadsheet operation, said first function call transmitting said new input data to said external program; and

making a second function call from said spreadsheet program to said external program, said second function call automatically occurring after said first function call as part of normal spreadsheet operation, said second function call retrieving output data from said external program, said output data calculated by said external program in response to said input data from said spreadsheet.

16. The method of claim 15, wherein said first function call is originated from a cell in a worksheet within said spreadsheet program.

17. The method of claim 15, wherein said second function call is originated from a cell in a worksheet within said spreadsheet program.

18. The method of claim 15, wherein said first function call is executed by calling an Object Linking and Embedding Automation method of said external program.

19. The method of claim 15, wherein said second function call is executed by calling an Object Linking and Embedding Automation method of said external program.

20. The method of claim 15, wherein said external program is input dependent.

21. The method of claim 15, wherein said external program is implemented, in part, as an embeddable document within said spreadsheet.

22. A system for integrating a spreadsheet program and an external program, comprising:

an input cell in said spreadsheet, said input cell containing data used as input by said external program;

a notification function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said notification function as part of normal spreadsheet operation if said input cell is changed, said notification function notifying said external program that the data from said input cell has changed;

a retrieval function containing a reference to said notification function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said notification function, said retrieval function retrieving output data from said external program as part of normal spreadsheet operation, said output data computed by said external program in response to said input data from said spreadsheet.

23. The system of claim 22, wherein said notification function is called as an Object Linking and Embedding Automation method of said external program.

24. The system of claim 22, wherein said external program is input dependent.

25. The system of claim 22, wherein said notification function also transmits additional information regarding said input cell to said external program.