Spreadsheet command/function capability from a dynamic-link library

• US 5,437,006 A
• Filed: 01/27/1993
• Issued: 07/25/1995
• Est. Priority Date: 01/27/1993
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Turski, Andrzej
• Primary Examiner(s): Powell, Mark R.
• Assistant Examiner(s): HUYNH, BA
• Application Number:
  US08/009,919
• Time in Patent Office: 909 Days
• Field of Search: 395/155, 395/156, 395/158, 395/160, 395/161, 395/148, 395/149, 395/650, 395/145
• US Class Current: 715/209
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 9/44521 Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
• CPC Class Codes: G06F 9/4484 Executing subprograms

Abstract

A data processing system executes a spreadsheet program that supports callbacks from dynamic-link libraries. The dynamic-link libraries may callback into the spreadsheet program through an entry point provided in the spreadsheet program. These callbacks allow execution of spreadsheet program functions and commands from within the dynamic-link library. The ability to callback to the spreadsheet program from the dynamic-link library results in substantial savings in time and memory space.

Claims

1. In a data processing system having a memory that holds a spreadsheet program and an operating system with a dynamic-link library and a processing means that executes the spreadsheet program and the operating system, a method comprising the computer implemented steps of:

a) executing the spreadsheet program on the processing means;

b) calling the dynamic-link library from the executing spreadsheet program;

c) beginning execution of the dynamic-link library on the processing means;

d) providing an entry point in the spreadsheet program to support a callback from the dynamic-link library to the spreadsheet program to request the spreadsheet program to perform requested activities;

e) making a callback in the dynamic-link library from the dynamic-link library to the entry point in the spreadsheet program in order to perform the requested activities in the spreadsheet program;

f) in response to the callback, performing the requested activities by the spreadsheet program; and

g) completing execution of the dynamic-link library on the processing means.

2. A method as recited in claim 1 wherein the requested activities include a spreadsheet function.

3. A method as recited in claim 1 wherein the requested activities include a spreadsheet command.

4. A method as recited in claim 3, further comprising the steps of providing a hidden macro sheet maintaining information specifying a currently active macro sheet and setting the information to indicate that currently active macro sheet is the hidden macro sheet.

5. A method as recited in claim 3 wherein the spreadsheet program maintains state information that identifies from where the spreadsheet command originated and said method further comprising the step of manipulating the state information maintained by the spreadsheet program to identify that the spreadsheet command originated from within the spreadsheet program.

6. A method as recited in claim 1 wherein the spreadsheet program has a user interface and the step of calling the dynamic-link library from the executing spreadsheet program further comprises the step of generating a request from the user interface to call the dynamic-link library.

7. A method as recited in claim 1 wherein spreadsheet program includes an internal dispatch routine, wherein the step of calling the dynamic-link library further comprises the step of calling the internal dispatch routine a first time and wherein the step of making a callback further comprises the step of calling the internal dispatch program a second time.

8. In a data processing system having a memory holding a dynamic-link library and a processing means executing a spreadsheet program with a spreadsheet macro sheet that is not visible to a user of the spreadsheet program, said spreadsheet program being responsive to commands and maintaining state information that indicates from where the commands originate, a method comprising the steps of:

a) executing the spreadsheet program on the processing means;

b) calling the dynamic-link library from the executing spreadsheet program on the processing means;

c) generating a callback or entry point in the spreadsheet program from the dynamic-link library to execute a selected spreadsheet program command;

d) setting state information maintained by the spreadsheet program to indicate that the callback originated from the spreadsheet macro sheet; and

e) performing the selected spreadsheet program command.

9. A method as recited in claim 8 wherein the step of emulating in the spreadsheet program to give the appearance that the callback originated from the spreadsheet macro sheet, further comprises the step of:

setting the macro sheet as a currently active macro sheet for the spreadsheet program.

10. A method as recited in claim 8 wherein the spreadsheet program maintains state information and the step of emulating the spreadsheet program to give the appearance that the callback originated from the spreadsheet macro sheet, further comprises the step of:

manipulating the state information that is maintained by the spreadsheet program to give the appearance that the callback originated from the spreadsheet macro sheet.

11. A method as recited in claim 10 wherein the state information is maintained by state variables and the step of manipulating state information kept by spreadsheet macro further comprises the step of:

setting the state variables in the spreadsheet program to give the appearance that the callback originated from the spreadsheet macro sheet.