Abstract: Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.

Abstract: Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.

Abstract: Embodiments are disclosed in which a process receives, via a graphical user interface (GUI) of a spreadsheet application, a function call. The function call includes a source string attribute identifying a string and a search string attribute identifying a substring to be identified in the string. The process performs a function associated with the function call by searching for the substring in the string and subsequently returning a subset of the string proximate to a location of the substring in the string.

Abstract: The described embodiments set forth techniques for providing interactive tutorial support for input options at computing devices. According to some embodiments, an interactive tutorial manager of a given application can analyze input information against various available interactive tutorials to identify an appropriate interactive tutorial to be displayed. The interactive tutorial manager can then utilize tutorial logic associated with the interactive tutorial to display an interactive tutorial user interface (UI) at the computing device in accordance with the input information. In turn, and as subsequent inputs are received (in accordance with available inputs/operations associated with the interactive tutorial), the interactive tutorial UI can be updated to reflect the subsequent inputs. Ultimately, when the input requirements for a particular operation are satisfied, the interactive tutorial UI can be disabled/hidden within the application, and the operation can be carried out as appropriate.

Abstract: Approaches are disclosed for maintaining spatial relationships (i.e., a layout) between a table object and other objects placed on a virtual canvas of an application work space. In certain implementations, offsets between the other objects and the table object are initially determined and are used to maintain the spatial relationships when the table object is resized. In certain implementations, the movement of the objects in response to a resize of the table object is dynamic from the user's perspective and can be easily undone.

Abstract: Automatic generation of custom palettes based on an image selected by a user is disclosed. In various embodiments, automatic palette generation may involve generating one or more than one palette based on the color or shading content of the image provided by the user. The generated palette may include a variety of colors (or shadings) that can be automatically mapped to and applied to various distinct features within a composite graphic construct to be customized.

Abstract: The present disclosure relates to the resizing of tables elements, such as rows or columns of a table. In one embodiment, a user selects two or more rows or columns to be resized and performs a column or row manipulation corresponding to the desired resize event, such as be interacting with an edge of one of the selected rows or columns. In an implementation, the user may toggle between the use of different resizing algorithms to see the effects of the different resizing algorithms.

Abstract: Approaches are disclosed for generating a menu that may be used to provide a set of bounded options for populating associated cells of a table. In certain embodiments, the menu is automatically generated based at least in part on the initial content of one or more cells to be associated with the menu. In certain embodiments, the options listed in the menu may be edited by a user or reformatted based on logic associated with the menu generation process.

Abstract: Automatic generation of custom palettes based on an image selected by a user is disclosed. In various embodiments, automatic palette generation may involve generating one or more than one palette based on the color or shading content of the image provided by the user. The generated palette may include a variety of colors (or shadings) that can be automatically mapped to and applied to various distinct features within a composite graphic construct to be customized.

Abstract: The present approaches relate to the creation or updating of a table using data acquired from an external source. In one embodiment, the data acquired from the external source may be dragged-and-dropped onto a new or existing table to invoke execution data import or update routines. In the case of an update, a unique key within the existing table may correspond to a field within the acquired external data set, allowing record matching to be performed such that matched records may be updated and new records may be added to the table. In addition, identified fields in the acquired external data set may correspond to or be matched with columns of the table, allowing data values to be matched and updated regardless of differences in the layout of the table and the acquired external data set.

Abstract: Approaches are disclosed for generating a menu that may be used to provide a set of bounded options for populating associated cells of a table. In certain embodiments, the menu is automatically generated based at least in part on the initial content of one or more cells to be associated with the menu. In certain embodiments, the options listed in the menu may be edited by a user or reformatted based on logic associated with the menu generation process.

Abstract: Approaches are disclosed for maintaining spatial relationships (i.e., a layout) between a table object and other objects placed on a virtual canvas of an application work space. In certain implementations, offsets between the other objects and the table object are initially determined and are used to maintain the spatial relationships when the table object is resized. In certain implementations, the movement of the objects in response to a resize of the table object is dynamic from the user's perspective and can be easily undone.

Abstract: The present disclosure relates to the resizing of tables elements, such as rows or columns of a table. In one embodiment, a user selects two or more rows or columns to be resized and performs a column or row manipulation corresponding to the desired resize event, such as be interacting with an edge of one of the selected rows or columns. In an implementation, the user may toggle between the use of different resizing algorithms to see the effects of the different resizing algorithms.