Microsoft Technology Licensing, LLC

Karen Xiaoxu Cheng

Benjamin Edward Rampson

Chad B Rothschiller

Christopher D Edwards

Igor B Peev

Eric W Patterson

John S Campbell

Keri Talbot

Lawrence Fubini Waldman

Christopher Doan

Amy Lin

Sherman Der

Thomas Constantine

Yun Ma

Clinton Dee Covington

Krista Bendig

Josh Leong

Different gestures and actions are used to interact with spreadsheets. The gestures are used in manipulating the spreadsheet and performing other actions in the spreadsheet. For example, gestures may be used to move within the spreadsheet, select data, filter, sort, drill down/up, zoom, split rows/columns, perform undo/redo actions, and the like. Sensors that are associated with a device may also be used in interacting with spreadsheets. For example, an accelerometer may be used for moving and performing operations within the spreadsheet.

Natural input for spreadsheet actions

A user interface element is displayed for in place editing of values within a document. For example, in response to selecting a value, a user interface is displayed near the value that receives a slide gesture for adjusting the value in place. The user interface may be configured to select one of the discrete parts of the value in response to changing a level of the slide gesture. For example, a user may move the swipe gesture from a level used for adjusting the day value to the level representing the year value. The user interface displayed and method(s) used to adjust the value may be based on the type of value and the structure and content of the document.

User interface for editing a value in place

Inserting a formula at a location on a content surface in a user interface is provided. A user interface showing a status bar which includes one or more predetermined calculations may be displayed on a computer. The computer may receive a selection of a predetermined calculation from the status bar in the user interface. The selected predetermined calculation may then be dragged from the status bar and inserted at a drop location on the content surface in the user interface. The computer may then automatically generate a formula corresponding to the selected predetermined calculation in the user interface.

Drag and drop always sum formulas

An intuitive user interface for clearing or deleting a structured data element is provided. One or more elements in a data structure may be selected and upon selection of a delete option, the contents of the one or more elements may be cleared. One or more animating panels may be provided which contain elements around the cleared elements. A panel may be moved by a gesture-type action to replace cleared elements. The panels may visually indicate which elements may be moved in place of the cleared elements. The user can visualize how elements may be shifted instead of having to understand terminology in a dialog. Selecting outside the panels may cause the panels to disappear, which may be equivalent to a clear action where other elements are not moved into the place of the deleted elements.

UI differentiation between delete and clear

A document having multiple data entry areas can be presented, and a list of suggestions for a designated data entry area can be generated. Generating the list can include analyzing a first set of data previously entered into one or more data entry areas of the document other than the designated data entry area and analyzing a second set of data including data outside the first set of data. The list of suggestions can be presented without having received manual entry of data in the designated data entry area, and user input selecting one of the suggestions can be received. Data represented by the selected suggestion can be entered in the data entry area in response to receiving the user input selecting the selected suggestion.

Document data entry suggestions

Animation for the expansion and collapse of content in a user interface may be provided. The user interface may be displayed by a computer and may contain a content surface for editing content. The content may include a top data row and data items in rows below the top data row on the content surface. The computer may then receive an input to expand/collapse the data items into the top data row. The computer may then animate a display of the data items expanding/collapsing into the top data row. Animation for the sorting of content in a user interface may also be provided. The user interface may be displayed by a computer and may contain a content surface for editing a plurality of rows containing content. The computer may then receive a request to sort the content. The computer may then animate a sort of the content.

Animation for expanding/collapsing content and for sorting content in an electronic document

Display screen with animated graphical user interface

An improved interactive user interface for presenting functionalities of an application is provided. An application functionality applied to a data element range may be represented by a selectable preview element that provides a preview of the application functionality applied to the data element range. Upon selection of a preview element, one or more drop zones may be displayed. The preview element may be dragged to a drop zone and may animate into a visualization of the application functionality applied to the data element. The type of visualization that is displayed may be dependent on the drop zone to which the preview element is dragged. After a preview element is dropped into a drop zone, the functionality may be applied to the data element range and be displayed. The interactive data visualizations may encourage a user to explore features of an application.

Growing community of inventors

Redmond, WA, United States of America

Karen Xiaoxu Cheng