Abstract:
For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet application or via a Web service, the ability to discover these parameters through the user interface or object model is provided. The ability to set or change these parameters one at a time or in bulk and drive the changes into the calculation model is also provided. Accordingly, whether viewed in a standalone spreadsheet application or via a Web rendering service, the effect of the parameters entered by the user can be calculated and viewed at once. The ability to suspend recalculation of a workbook until all relevant values, such as a current set of parameters, are obtained is also enabled.
Abstract:
A web page behavior enhancement (WPBE) control element is provided on a rendered web page enabling a user to perform actions on at least a portion of the web page content such as customizing, editing, sharing, analyzing, exporting, and/or annotating the content. The processed content may be presented on the original web page, on a locally stored version of the web page, or archived for subsequent use, where any changes to the original web page content may be tracked and the user notified about the changes. The WPBE control element(s) may be embedded into the web page at the source web application or at the local browser based on factors like web application capabilities, browser capabilities, user preferences, usage pattern, and comparable ones.
Abstract:
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.
Abstract:
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.
Abstract:
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).
Abstract:
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.
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.
Abstract:
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.
Abstract:
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.
Abstract:
For standalone spreadsheet applications and/or Web-based spreadsheet services, the ability to designate, discover and set parameters for spreadsheet documents is provided. When creating a spreadsheet document, the ability to designate certain cells or ranges of cells as parameters to a spreadsheet is enabled. Furthermore, whether viewed in a standalone spreadsheet application or via a Web service, the ability to discover these parameters through the user interface or object model is provided. The ability to set or change these parameters one at a time or in bulk and drive the changes into the calculation model is also provided. Accordingly, whether viewed in a standalone spreadsheet application or via a Web rendering service, the effect of the parameters entered by the user can be calculated and viewed at once. The ability to suspend recalculation of a workbook until all relevant values, such as a current set of parameters, are obtained is also enabled.