Patent US5437006A successfully refreshed from Google Patents.
US5437006A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Spreadsheet command/function capability from a dynamic-link library
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1993-01-27
•
Granted: 1995-07-25
•
Expires: 2013-01-27
Abstract
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.
Inventors
- 👤 Andrzej Turski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 13:50
CPC Classifications
G; G06; G06F; G06F9/00; G06F9/06; G06F9/44; G06F9/445; G06F9/44521; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06F9/448; G06F9/4482; G06F9/4484
Claims Analysis
Total Claims: 13
Claim 1
Independent Claim
159 words
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.
Claim 2
Dependent Claim
159 words
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.
Claim 3
Dependent Claim
15 words
A method as recited in claim 1 wherein the requested activities include a spreadsheet function.
Claim 4
Dependent Claim
15 words
A method as recited in claim 1 wherein the requested activities include a spreadsheet command.
Claim 5
Dependent Claim
41 words
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.
Claim 6
Dependent Claim
51 words
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.
Claim 7
Dependent Claim
45 words
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.
Claim 8
Dependent Claim
57 words
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.
Claim 9
Dependent Claim
133 words
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.
Claim 10
Dependent Claim
133 words
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.
Claim 11
Dependent Claim
48 words
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.
Claim 12
Dependent Claim
64 words
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.
Claim 13
Dependent Claim
53 words
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.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1998-07-24 | 1999-01-23 | 1999-07-25 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2002-07-24 | 2003-01-23 | 2003-07-25 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2006-07-24 | 2007-01-23 | 2007-07-25 | $7700.00 | Window Closed / Lapsed |