Microsoft Technology Licensing, LLC

Daniel C Battagin

Shahar Prish

Eran Megiddo

Lawrence Fubini Waldman

Daniel Yancy Parish

Yariv Ben-Tovim

Johnny S Campbell

Amy Lin

Liviu Asnash

Jon Garrett Simmons

Amir Netz

Cristian Petculescu

Robert C Collie

Lee B Graber

Raman S Iyer

Eoin James Burke

Su-Piao Bill Wu

Melissa R MacBeth

Keyur Rahul Patel

Sanjay Govindrao Kulkarni

Gabhan Berry

Ira Levin

Naveen Kumar

Shawn Michael Allen Lipstein

Ramarathnam R Venkatesan

Eric Cohen

John S Campbell

Sumit Gulwani

Chad B Rothschiller

Benjamin Zorn

Benjamin C Chamberlain

Robert G Hawking

Rishabh Singh

Brian L Welcker

Aaron Lamar Wilson

Ramakrishnan Natarajan

Boaz Chen

Sean Boon

Shawn Lipstein

Dany Rouhana

Amarinder Singh Grewal

Alexander Martynov

Prashant Anand Shirolkar

Robert Archer

Justin Frederick Rockwood

Tom Hoke

Rodrigo Moreira-Silveira

Dmitri O Danilov

Harrison Gordon

Harold Campbell

Jon Garret Simmons

Sharar Prish

Christopher Benedict

A panorama display application shows objects from a spreadsheet such as charts in primary screen of a mobile device adjoined by left and right virtual screens. The application overlays interaction controls such as sort and filter functions on the object. The application also provides additional interaction controls for the object on the left virtual screen and associated objects links on the right virtual screen. The application may expose the additional interaction controls and the associated objects links by overlaying portions of the virtual screens on the primary screen. The application fluidly shifts content from virtual screens to the primary screen subsequent to detected user action on the overlaid portions.

Managing objects in panorama display to navigate spreadsheet

A user interface that when selected triggers the automatic sharing of a spreadsheet object in a spreadsheet with a chosen network service (e.g. social network, blog, or some other network location). For example, cells, tables, charts and other objects of the spreadsheet may be selected to be shared using the user interface. When a spreadsheet object is selected and indicated to be shared using the user interface, the spreadsheet is automatically saved to a network share, permissions are set for the spreadsheet to share the spreadsheet object, and the spreadsheet object is shared with the network service. Changes made to the spreadsheet after the spreadsheet object is shared are reflected in the spreadsheet object on the network service.

Codeless sharing of spreadsheet objects

Suggestions are automatically displayed in response to an event. For example, suggestions may be automatically displayed in response to a receiving an indication from a user to enter content (e.g. receiving a selection of a content entry area). The suggestions may be displayed before a user enters any characters and before an input device is displayed and/or used (e.g. keyboard, Software Input Panel (SIP), and the like. Suggestions may also be automatically displayed in response to detecting a pause while a user is entering content. For example, when a user is actively entering content, suggestions are not automatically displayed but when a user pauses a predetermined amount while entering content, suggestions are automatically displayed. The suggestions may be determined from content that may be seen on a display and/or hidden from view (e.g. hidden rows in a spreadsheet).

Automatically displaying suggestions for entry

Data formatting rules to convert data from one form to another form are automatically determined based on a user's edits. A machine learning heuristic is applied to a user's edits to determine a data formatting rule that may be applied to data. For example, a user may make edits that add/remove characters from data, concatenate data, extract data, rename data, and the like. The machine learning heuristic may be automatically triggered in response to an event (e.g. after a predetermined number of edits are made to a same type of data) or manually triggered (e.g. selecting a user interface option). The data formatting rule may be applied to other data and the results of the formatting reviewable by the user. Based on further edits/reviews, the data formatting rule may be updated. The data formatting rules may be stored for later use.

Formatting data by example

Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user.

Embedding and retrieving data in an application file format

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.

Interaction between web gadgets and spreadsheets

Architecture that enables the capability to call user-defined functions (UDFs) within the hosting page, and from within a spreadsheet. UDFs can be used to add functionality to spreadsheet models. Spreadsheet calculations are spread across a backend calculation server and the web browser. Spreadsheet calculation state is maintained as browser functions are calculated. Moreover, the browser UDFs can be executed synchronously or asynchronously. The architecture also provides capability to dynamically register/unregister UDFs at runtime, which can then be called from the spreadsheet model and executed remotely), and the capability to define a manifest that can include all of the UDF definitions, infinite calculation loop situations are also prevented. The UDFs have full access to the page DOM (document object model).

Custom browser-side spreadsheet functions

Embodiments of the present disclosure provide a method and system for providing additional functionality, including web functionality, to one or more online documents. Specifically, embodiments described herein include receiving a selection of a range of data to be used in a web extension and binding the selection of the range of data to the web extension. Once the data is bound, the binding is stored in a remote computing device. In response to the detection of the interaction with the bound range of data, the bound range of data is sent to the remote computing device where the bound range of data is updated based on the interaction. The updated data is then sent to the web extension to enable the web extension to be updated with the newly received data.

System and method for providing calculation web services for online documents

A web page behavior control (WPBC) menu is provided on a rendered web page for enabling a user to perform actions on a portion of the web page content such as customizing, editing, sharing, analyzing, exporting, and/or annotating the content. The user may automatically activate the menu by performing a unique gesture on the rendered web page and/or by selecting a portion of the web page content. The WPBC menu may provide a list of applications which may be selected for modifying and managing the portion of selected web page content. The application may provide full functionality for managing the web page content in a separate user interface and/or directly on the rendered web page. Furthermore, manipulation of data presentation on the rendered web page such as table properties of a spreadsheet may be enabled through natural gestures.

Web page application controls

Functionality and presentation of spreadsheet applications and web based services are integrated by automating interactions between a spreadsheet object on a web page and other elements on the web page. Bidirectional referencing, automatic coordinate space integration, and assimilation of look and feel of the spreadsheet object into the web page or vice versa are enabled.

Integration of spreadsheet objects on web page

A named object view of a report is generated from an electronic data file. Objects in the file to be published are identified in the file. A named object view of the report associated with the file is generated by displaying published identified objects according to associated viewing rights. A viewer at a client is presented with the named object view of the report, according to the viewing rights, such that the viewer's attention is focused on the published objects.

Named object view of electronic data report

Growing community of inventors

Redmond, WA, United States of America

Daniel C Battagin