发明名称 Interaction between web gadgets and spreadsheets
摘要 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.
申请公布号 US9514116(B2) 申请公布日期 2016.12.06
申请号 US201514731023 申请日期 2015.06.04
申请人 Microsoft Technology Licensing, LLC 发明人 Waldman Lawrence;Patel Keyur Rahul;Prish Sharar;Burke Eoin James;Battagin Daniel;Simmons Jon Garrett
分类号 G06F17/24;G06F9/445 主分类号 G06F17/24
代理机构 代理人 Wong Thomas S.;Minhas Micky
主权项 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.
地址 Redmond WA US