Method, system, and apparatus for providing access to asynchronous data in a spreadsheet application program

• US 7,047,484 B1
• Filed: 10/18/2001
• Issued: 05/16/2006
• Est. Priority Date: 10/18/2001
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Becker, Andrew J., Allen, Jason P., Cahill, Jason M., Bedford, Jesse R., Slepak, Aleksandr M., Ahlers, Timothy
• Primary Examiner(s): Bashore, William
• Assistant Examiner(s): HUYNH, THU V
• Application Number:
  US09/982,122
• Time in Patent Office: 1,671 Days
• Field of Search: 715/503, 715/504, 715/505, 709/203, 709/231, 719/315, 719/318
• US Class Current: 715/201
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A method, system, and apparatus for providing access to asynchronous data in a spreadsheet application program is provided. When a request is received to utilize an asynchronous data element in a spreadsheet, the spreadsheet application program instructs an asynchronous data server to provide updated values for the asynchronous data element. When the asynchronous data server program receives an updated value, it notifies the spreadsheet application program that a changed value for the data element is available. The next time the spreadsheet application program has idle processing time following a notification that an update is available, the spreadsheet application program determines whether a notification has been received from the asynchronous data server program. If an update is available, the spreadsheet application program contacts the asynchronous data server and requests the update. In response, the asynchronous data server program transmits the update to the spreadsheet application program.

Claims

1. A method for providing access to asynchronous data in a spreadsheet application program, comprising:

receiving a request at said spreadsheet application program to access an asynchronous data element available from an asynchronous data source;

exposing an interface at said spreadsheet application program for receiving a notification that a changed value for said data element is available;

notifying an asynchronous data server that said spreadsheet application program should be notified at said interface in the event that a changed value for said data element is available;

determining whether a notification has been received at said interface indicating that a changed value for said data element is available;

in response to determining that the notification has been received at said interface, said interface at said spreadsheet application program configured to receive said notification when said spreadsheet application program cannot receive the changed value because it is busy recalculating a spreadsheet, contacting said asynchronous data server and requesting said changed value for said data element; and

receiving said changed value for said data element from said asynchronous data server at said spreadsheet application program.

2. The method of claim 1, further comprising:

recalculating a spreadsheet that includes said changed data value in response to receiving said changed value for said data element.

3. The method of claim 2, wherein said recalculation is limited to cells contained in said spreadsheet that depend upon said changed data value.

4. The method of claim 1, wherein said notification from said asynchronous data server indicating that a changed value for said data element is available is received asynchronously.

5. The method of claim 1, wherein said request at said spreadsheet application program to access an asynchronous data element is received through a worksheet time data function provided by said spreadsheet application program.

6. A computer-controlled apparatus capable of performing the method of claim 5.

7. The method of claim 1, further comprising:

maintaining a throttle interval value defining when said determination should be made regarding whether a notification has been received at said interface indicating that a changed value for said data element is available.

8. The method of claim 7, further comprising:

determining whether said throttle interval value is set for a manual update mode prior to determining whether a notification has been received at said interface indicating that a changed value for said data element is available; and

in response to determining that said throttle interval value is set for said manual update mode, determining whether a notification has been received at said interface indicating that a changed value for said data element is available only in response to a manual request.

9. A computer-controlled apparatus capable of performing the method of claim 8.

10. The method of claim 7, further comprising:

determining whether said throttle interval value is set for a constant update mode prior to determining whether a notification has been received at said interface indicating that a changed value for said data element is available; and

in response to determining that said throttle interval value is set for said constant update mode, determining whether a notification has been received at said interface indicating that a changed value for said data element is available whenever said spreadsheet application program is idle.

11. A computer-controlled apparatus capable of performing the method of claim 10.

12. The method of claim 7, further comprising:

determining whether said throttle interval value is set to wait a predetermined amount of time prior to determining whether a notification has been received at said interface indicating that a changed value for said data element is available; and

in response to determining that said throttle interval value is set to wait a predetermined amount of time, determining whether a notification has been received at said interface indicating that a changed value for said data element is available only after waiting said predetermined amount of time.

13. A computer-controlled apparatus capable of performing the method of claim 12.

14. A computer-controlled apparatus capable of performing the method of claim 7.

15. The method of claim 1, further comprising:

determining whether a heartbeat value has elapsed since a previous update was received from said asynchronous data server in response to determining that no notification has been received at said interface; and

restarting said asynchronous data server in response to determining that said heartbeat value has elapsed.

16. A computer-controlled apparatus capable of performing the method of claim 15.

17. A computer-controlled apparatus capable of performing the method of claim 1.

18. A computer system for providing access to asynchronous data in a spreadsheet application program, comprising:

a spreadsheet application program operative to receive a request to access an asynchronous data element, to expose an interface at said spreadsheet application program for communicating with an asynchronous data server, and to notify said asynchronous data server that notifications should be provided at said interface in the event that a changed value for said data element is received, said interface at said spreadsheet application program configured to receive said notifications when said spreadsheet application program cannot receive the changed value because it is busy recalculating a spreadsheet; and

an asynchronous data server operative to receive said data element from an asynchronous data source, to receive said notification request from said spreadsheet application program, to determine whether a value for said data element has changed, and to asynchronously notify said spreadsheet application program at said interface in response to determining that said data value has changed.

19. The computer system of claim 18, wherein said spreadsheet application program is further operative to receive said notification from said asynchronous data server at said interface and, in response to receiving said notification, to contact said asynchronous data server and request said changed value for said data element.

20. The computer system of claim 19, wherein said spreadsheet application program is further operative to incorporate said changed value for said data element into a spreadsheet and to recalculate said spreadsheet based upon only said changed value.

21. A computer-readable medium comprising computer-executable instructions which, when executed by the computer, cause the computer to:

maintain an interface for use by a spreadsheet application program through which a notification is received indicating that an asynchronous data server has an asynchronous data value available for said spreadsheet application program, said interface at the spreadsheet application program configured to receive said notification when said spreadsheet application program cannot receive the changed value because it is busy recalculating a spreadsheet; and

to

maintain an interface at said asynchronous data server for communicating with said spreadsheet application program, said interface maintained at said asynchronous data server supporting a refresh data method which, when called by said spreadsheet application program, causes the asynchronous data server to transmit said asynchronous data value to said spreadsheet application program.

22. The computer-readable medium of claim 21, wherein said interface maintained at said asynchronous data server further supports a connect data method that may be called by said spreadsheet application program to request a new asynchronous data value from said asynchronous data server.

23. The computer-readable medium of claim 21, wherein said interface maintained at said asynchronous data server further supports a disconnect data method that may be called by said spreadsheet application program to inform said asynchronous data server that said spreadsheet application program no longer requires a notification indicating that said asynchronous data server has a data value available for said spreadsheet application program.

24. The computer-readable medium of claim 21, wherein said interface maintained at said asynchronous data server further supports a heartbeat method that may be called by said spreadsheet application program to determine whether said asynchronous data server is active.

25. The computer-readable medium of claim 21, wherein said interface maintained at said asynchronous data server further supports a server start method that may be called by said spreadsheet application program to start said asynchronous data server, said server start method taking as a parameter a callback object implementing said interface maintained by said spreadsheet application.

26. The computer-readable medium of claim 21, wherein said interface maintained at said asynchronous data server further supports a server terminate method that terminates said asynchronous data server in the event that said spreadsheet application program no longer requires data values from said asynchronous data server.