Abstract: A spin control graphical user interface is used to display a currently applied option and to receive options from a user. The spin control is a circular graphical user interface that is positioned near a displayed document to which it applies. For example, the spin control may be positioned on or near a corner of the displayed document. The spin control comprises options that are presented to a user upon rotation of the spin control. An option may be manually selected or automatically selected and applied to the displayed document upon rotating the spin control clockwise or counterclockwise. More than one spin control may be associated with the displayed document. The spin control may be automatically shown and removed from a display in response to whether the document to which the spin control is attached is currently being displayed.

Abstract: Selected data is temporarily formatted and charted to assist a user in visualizing the selected data without the user having to manually create the display of the charted data. Once the temporary formatting and charting is automatically applied to the selected data, a user may interact with the visual formatting and charts to gain additional information. For example, the chart may be formatted differently, reference lines may be added, the chart may be sorted, the type of chart(s) displayed may be changed, the user may graphically navigate over the chart to obtain more detailed information, and the like. Once the user has completed interacting with the temporarily formatted and created chart(s) the visualizations are removed from the display.

Abstract: Technologies are described herein for displaying one or more visual indicators to assist users in identifying cells of a spreadsheet that are affected by an operation. In embodiments disclosed herein, an application is configured to receive a request to perform an operation on at least one cell of the spreadsheet. The application then identifies cells of the spreadsheet that are affected by the operation. The application then displays a visual indicator to emphasize the affected cells. By providing a timely displayed visual indicator that brings attention to affected cells, the user is able to gain a better perspective of the extent of the operation and how the operation applies to the cells of the spreadsheet.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: A sparkline is associated with a location in a document to provide a visual representation of one or more data values included in the document. The sparkline is associated with a data source within the document including the one or more data values. The sparkline is generated by generating the visual representation based on the one or more data values with a matrix of points to be presented at the associated location in the document. The sparkline is presented at the associated location in the document. The sparkline is configured to be regenerated when one or more of the data values in the data source change.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: A spin control graphical user interface is used to display a currently applied option and to receive options from a user. The spin control is a circular graphical user interface that is positioned near a displayed document to which it applies. For example, the spin control may be positioned on or near a corner of the displayed document. The spin control comprises options that are presented to a user upon rotation of the spin control. An option may be manually selected or automatically selected and applied to the displayed document upon rotating the spin control clockwise or counterclockwise. More than one spin control may be associated with the displayed document. The spin control may be automatically shown and removed from a display in response to whether the document to which the spin control is attached is currently being displayed.

Abstract: A spin control graphical user interface is used to display a currently applied option and to receive options from a user. The spin control is a circular graphical user interface that is positioned near a displayed document to which it applies. For example, the spin control may be positioned on or near a corner of the displayed document. The spin control comprises options that are presented to a user upon rotation of the spin control. An option may be manually selected or automatically selected and applied to the displayed document upon rotating the spin control clockwise or counterclockwise. More than one spin control may be associated with the displayed document. The spin control may be automatically shown and removed from a display in response to whether the document to which the spin control is attached is currently being displayed.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: Technologies are described herein for displaying one or more visual indicators to assist users in identifying cells of a spreadsheet that are affected by an operation. In embodiments disclosed herein, an application is configured to receive a request to perform an operation on at least one cell of the spreadsheet. The application then identifies cells of the spreadsheet that are affected by the operation. The application then displays a visual indicator to emphasize the affected cells. By providing a timely displayed visual indicator that brings attention to affected cells, the user is able to gain a better perspective of the extent of the operation and how the operation applies to the cells of the spreadsheet.

Abstract: Touch/gesture-enabled interaction and navigation with electronic spreadsheets is provided. Navigation of, finding content in, and interacting with spreadsheets and spreadsheet objects is enhanced via a variety of touch/gesture interactions that allow users to more fully utilize and appreciate spreadsheet functionality and content. Different spreadsheet application functionality modes and spreadsheet content levels may be navigated in response to touch/gesture interactions. Information associated with and/or underlying spreadsheets and/or spreadsheet objects may be exposed. Touchable areas in or around selectable spreadsheet cells, areas/objects and/or selectable functionality controls may be enhanced for improving touch/gesture interaction.

Abstract: When a user uses touch to interact with an application, a contextual touch user interface (UI) element may be displayed that includes a display of commands that are arranged in sections on a tool panel that appears to float over an area of the display. The sections include a C/C/P/D section, an object specific section and may include a contextual trigger/section and an additional UI trigger. The C/C/P/D section may comprise one or more of: cut, copy, paste and delete commands. The object specific section displays commands relating to a current user interaction with an application. The contextual trigger/section displays contextual commands and the alternative trigger section displays another UI element comprising more commands when triggered.

Abstract: When a user uses touch to interact with an application, a contextual touch user interface (UI) element may be displayed that includes a display of commands that are arranged in sections on a tool panel that appears to float over an area of the display. The sections include a C/C/P/D section, an object specific section and may include a contextual trigger/section and an additional UI trigger. The C/C/P/D section may comprise one or more of: cut, copy, paste and delete commands. The object specific section displays commands relating to a current user interaction with an application. The contextual trigger/section displays contextual commands and the alternative trigger section displays another UI element comprising more commands when triggered.

Abstract: User interface elements are configured for touch input and hardware based input. When using touch input, the user interface (UI) elements are optimized for touch input. For example, UI elements may be displayed: using formatting configured for touch input (e.g. changing a size, spacing); using a layout configured for touch input; displaying more/fewer options; changing/removing hover actions, and the like. When using hardware based input, the user interface elements are optimized for the hardware based input. For example, formatting configured for hardware based input may be used (e.g. hover based input may be used, text may be displayed smaller), more/fewer options displayed, and the like.

Abstract: A touch input mode may be entered and exited automatically and/or manually. When the touch input mode is entered, user interface (UI) elements are optimized for touch input. When the touch input mode is exited, the user interface (UI) elements are optimized for hardware based input. A user may enter the touch input mode by manually selecting a user interface element and/or by entering touch input. Settings may be configured that specify conditions upon which the touch input mode is entered/exited. For example, the touch input mode may be configured to be automatically entered upon undocking a computing device, receiving touch input when in the hardware based input mode, and the like. Similarly, the touch input mode may be configured to be automatically exited upon docking a computing device, receiving hardware based input when in the touch input mode, and the like.

Abstract: Selected data is temporarily formatted and charted to assist a user in visualizing the selected data without the user having to manually create the display of the charted data. Once the temporary formatting and charting is automatically applied to the selected data, a user may interact with the visual formatting and charts to gain additional information. For example, the chart may be formatted differently, reference lines may be added, the chart may be sorted, the type of chart(s) displayed may be changed, the user may graphically navigate over the chart to obtain more detailed information, and the like. Once the user has completed interacting with the temporarily formatted and created chart(s) the visualizations are removed from the display.

Abstract: A spin control graphical user interface is used to display a currently applied option and to receive options from a user. The spin control is a circular graphical user interface that is positioned near a displayed document to which it applies. For example, the spin control may be positioned on or near a corner of the displayed document. The spin control comprises options that are presented to a user upon rotation of the spin control. An option may be manually selected or automatically selected and applied to the displayed document upon rotating the spin control clockwise or counterclockwise. More than one spin control may be associated with the displayed document. The spin control may be automatically shown and removed from a display in response to whether the document to which the spin control is attached is currently being displayed.