Interaction between web gadgets and spreadsheets

• US 9,514,116 B2
• Filed: 06/04/2015
• Issued: 12/06/2016
• Est. Priority Date: 11/04/2011
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Waldman, Lawrence, Patel, Keyur Rahul, Prish, Sharar, Burke, Eoin James, Battagin, Daniel, Simmons, Jon Garrett
• Primary Examiner(s): Stork, Kyle
• Assistant Examiner(s): Kells, Asher
• Application Number:
  US14/731,023
• Publication Number:
  US 20150347372A1
• Time in Patent Office: 551 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 9/44526 Plug-ins; Add-ons

Abstract

Gadgets integrate with spreadsheets and the spreadsheet calculation engine. A gadget is bound to a range of cells (one or more) within a sheet. When one or more of the cells of the bound range is accessed (e.g. selected, hovered over, edited, deleted, added), the gadget is notified. The gadget may use this information for updating a display rendered by the gadget and/or performing some other action. The gadget uses an Application Programming Interface (API) to create the binding, communicate with the spreadsheet, and perform actions in the spreadsheet. The gadget is a Named Item object within the spreadsheet such that the gadget may be viewed/displayed differently from other objects. Out of date requests from the gadget are attempted to be detected and prevented from being processed such that the gadget is not acting on the latest data.

Claims

1. A system comprising:

at least one processor; and

memory encoding computer executable instructions that, when executed by at least one processor, cause the at least one processor to perform a method for integrating a gadget with a spreadsheet, the method comprising

providing an Application Programming Interface (API) for the gadget to communicate with the spreadsheet;

receiving a selection of a range of cells of the spreadsheet to bind to the gadget, wherein the selected range of cells comprises one or more cells of the spreadsheet;

determining a binding between the selected range of cells of the spreadsheet and the gadget;

determining an interaction with the selected range of cells;

automatically providing a first notification to the gadget in response to the interaction;

receiving a call from the gadget using the API;

performing an operation involving the spreadsheet that relates to the received call;

after performing the operation, receiving input to change the selected range of cells to adjust the binding to include the changed selected range of cells; and

automatically providing a second notification to the gadget in response to the input.

2. The system of claim 1, wherein the gadget is configured to display interactive content associated with data within the selected range of cells.

3. The system of claim 2, further comprising in response to an interaction with the interactive content, updating the data within the selected range of cells.

4. The system of claim 2, wherein the interactive content is displayed based on access permissions associated with the spreadsheet.

5. The system of claim 1, wherein the API is configured to at least obtain content from one or more cells of the spreadsheet, place content into one or more cells of the spreadsheet, create a binding between the gadget and a selected range of cells of the spreadsheet, and changing a display of the spreadsheet.

6. The system of claim 1, further comprising storing the binding within the spreadsheet.

7. The system of claim 1, wherein the binding between the selected range of cells of the spreadsheet and the gadget specifies a unique name for the gadget, a link to the gadget, and a range of cells of the spreadsheet to be associated with the gadget.

8. The system of claim 1, further comprising exposing the gadget as a named item within the spreadsheet such that the gadget is publishable in a report.

9. The system of claim 1, further comprising displaying both the spreadsheet and the gadget, wherein the selected range of cells are distinguished from other cells displayed in the spreadsheet.

10. The system of claim 1, wherein the interaction with the selected range of cells includes at least one of deleting a cell within the selected range of cells, adding a cell within the selected range of cells, editing a cell within the selected range of cells, hovering over a cell within the selected range of cells, and selecting a cell within the selected range of cells is selected.

17. The method of claim 1, further comprising determining when the call is out of date, wherein when it is determined that the call is out of date, preventing the call from being executed.

11. A method for integrating a gadget with a spreadsheet, comprising:

providing an Application Programming Interface (API) for the gadget to communicate with the spreadsheet;

receiving a selection of a range of cells of the spreadsheet to bind to the gadget, wherein the selected range of cells comprises one or more cells of the spreadsheet;

determining a binding between the selected range of cells of the spreadsheet and the gadget;

determining an interaction with the selected range of cells;

automatically providing a first notification to the gadget in response to the interaction;

receiving a call from the gadget using the API;

performing an operation involving the spreadsheet that relates to the received call;

after performing the operation, receiving input to change the selected range of cells to adjust the binding to include the changed selected range of cells; and

automatically providing a second notification to the gadget in response to the input.

12. The method of claim 11, further comprising in response to providing the first notification to the gadget, performing an action.

13. The method of claim 12, wherein the action comprises updating a display of the gadget.

14. The method of claim 11, further comprising exposing the gadget as a named item within the spreadsheet such that the gadget can be displayed differently from other objects within the spreadsheet.

15. The method of claim 11, wherein the API further comprises a function for changing the display of one or more cells of the spreadsheet in response to an action occurring on the gadget.

16. The method of claim 11, wherein the binding is automatically updated in response to the input.

18. A system comprising

at least one processor;

and

memory encoding computer executable instructions that, when executed by at least one processor, cause the at least one processor to perform a method comprising

providing an Application Programming Interface (API) for a gadget to communicate with a spreadsheet;

receiving a selection of a range of cells of the spreadsheet to bind to the gadget, wherein the selected range of cells comprises one or more cells of the spreadsheet;

establishing a binding between the selected range of cells of the spreadsheet and the gadget;

receiving input to change the selected range of cells to adjust the binding to include the changed selected range of cells; and

automatically providing a notification to the gadget in response to the input.

19. The system of claim 18, further comprising automatically generating a report for the gadget in response to an event.

20. The system of claim 19, wherein the event includes one of opening the spreadsheet, selecting a Named Object View option or performing a search.