Interaction between web gadgets and spreadsheets

Patent metadata

Field	Value
Publication number	US-9514116-B2
Application number	US-201514731023-A
Country	US
Kind code	B2
Filing date	Jun 4, 2015
Priority date	Nov 4, 2011
Publication date	Dec 6, 2016
Grant date	Dec 6, 2016

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.

First claim

What is claimed is:

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.

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.

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.

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.

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Waldman Lawrence
• Patel Keyur Rahul
• Prish Sharar
• Burke Eoin James
• Battagin Daniel
• Simmons Jon Garrett

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F9/44526 Primary

  Plug-ins; Add-ons · CPC title

• G06F40/177

  of tables; using ruled lines · CPC title

• G06F17/245

  Physics · mapped topic

• G06F17/246 Primary

  Physics · mapped topic