Abstract: An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data. The program also provides a mechanism whereby by rows and columns may be prioritized for display, particularly on a relatively smaller mobile display. The prioritization(s) are then used by a device, whether the same or different than used to create provide the designations, to use the prioritizations to display the prioritized information, with other information being nested and displayable upon an interaction from a user, such as touching a displayed primary column cell to cause a secondary nested and related column cell to be displayed. In some instances, table designations occur automatically based on some attribute of the table or table data.

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: Embodiments are disclosed in which a process generates, receives, or both, via a graphical user interface (GUI) of a spreadsheet application, an evaluation statement. The evaluation statement includes a cell identifier, and the cell identifier specifies a modal reference cell that provides an indication of a modal attribute to be used in the evaluation statement. The indication of the modal attribute comprises a textual indicator related to the modal attribute, but has a format that is different than the modal attribute. The process evaluates the textual indicator to be used by the evaluation statement to determine a corresponding modal attribute and calculates a solution to the evaluation statement using the corresponding modal attribute as the modal attribute of the evaluation statement. The process displays the solution via the GUI.

Abstract: Embodiments are disclosed in which a process generates, receives, or both, via a graphical user interface (GUI) of a spreadsheet application, an evaluation statement. The evaluation statement includes a cell identifier, and the cell identifier specifies a modal reference cell that provides an indication of a modal attribute to be used in the evaluation statement. The indication of the modal attribute comprises a textual indicator related to the modal attribute, but has a format that is different than the modal attribute. The process evaluates the textual indicator to be used by the evaluation statement to determine a corresponding modal attribute and calculates a solution to the evaluation statement using the corresponding modal attribute as the modal attribute of the evaluation statement. The process displays the solution via the GUI.

Abstract: Methods and systems for providing input to a computing device based on a toggle gesture performed during a drag gesture are provided. A drag gesture can be performed on a touch screen to manipulate a user interface object. For example, the drag gesture can move the user interface object or resize the user interface object. Such manipulation commands may have alternate modes or options. For example, a user may want to place a copy of the user interface object rather than simply moving it. Accordingly, a toggle gesture can be performed during the drag gesture to choose an alternate manipulation command. For example, a drag gesture can be performed to move an object, and a toggle gesture can be performed during the drag gesture to copy the object instead of moving it.

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: An electronic device with a display and a touch-sensitive surface detects a first user input that selects a first numerical value field and, in response, displays a value selection bar at a first length and with a range of values and displays a value selection object. The device detects a gesture on the value selection bar and, in response to, displays the value selection bar at a second length. While the value selection bar is displayed at the second length, the device detects a third user input that moves the value selection object within the value selection bar and, in response, enters a second value within the range of values into the first numerical value field based on a position of the value selection object on the value selection bar.

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: An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data. The program also provides a mechanism whereby by rows and columns may be prioritized for display, particularly on a relatively smaller mobile display. The prioritization(s) are then used by a device, whether the same or different than used to create provide the designations, to use the prioritizations to display the prioritized information, with other information being nested and displayable upon an interaction from a user, such as touching a displayed primary column cell to cause a secondary nested and related column cell to be displayed. In some instances, table designations occur automatically based on some attribute of the table or table data.

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: Methods and systems for providing input to a computing device based on a toggle gesture performed during a drag gesture are provided. A drag gesture can be performed on a touch screen to manipulate a user interface object. For example, the drag gesture can move the user interface object or resize the user interface object. Such manipulation commands may have alternate modes or options. For example, a user may want to place a copy of the user interface object rather than simply moving it. Accordingly, a toggle gesture can be performed during the drag gesture to choose an alternate manipulation command. For example, a drag gesture can be performed to move an object, and a toggle gesture can be performed during the drag gesture to copy the object instead of moving it.

Abstract: Methods and systems for providing input to a computing device based on a toggle gesture performed during a drag gesture are provided. A drag gesture can be performed on a touch screen to manipulate a user interface object. For example, the drag gesture can move the user interface object or resize the user interface object. Such manipulation commands may have alternate modes or options. For example, a user may want to place a copy of the user interface object rather than simply moving it. Accordingly, a toggle gesture can be performed during the drag gesture to choose an alternate manipulation command. For example, a drag gesture can be performed to move an object, and a toggle gesture can be performed during the drag gesture to copy the object instead of moving it.

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: An electronic device having a display and a touch-sensitive surface, displays a table having a plurality of rows, a plurality of columns, and a plurality of cells. The device detects a gesture on the touch-sensitive surface that includes movement of one or more of a first contact and a second contact. When the detected gesture is a pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device decreases the width of the one or more respective columns. When the detected gesture is a de-pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device increases the width of the one or more respective columns.

Abstract: An electronic device having a display and a touch-sensitive surface, displays a table having a plurality of rows, a plurality of columns, and a plurality of cells. The device detects a gesture on the touch-sensitive surface that includes movement of one or more of a first contact and a second contact. When the detected gesture is a pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device decreases the width of the one or more respective columns. When the detected gesture is a de-pinch gesture at a location that corresponds to one or more respective columns in the table and has a component that is perpendicular to the one or more respective columns, the device increases the width of the one or more respective columns.

Abstract: Computing equipment may display tables of data that contain rows and columns. Touch gestures such as hold and flick gestures may be detected using a touch screen or other touch sensor. In response to a detected hold portion of a hold and flick gesture, a row or column in a table may be selected. In response to detection of a simultaneous flick portion, columns or rows may be inserted or deleted. A column may be inserted after a selected column using a hold and right downflick gesture. A hold and left downflick gesture may be used to insert a column before a selected column. Rows may be inserted before and after selected rows using hold and upper rightflick and hold and lower rightflick gestures. One or more columns or rows may be deleted using upflick or leftflick gestures.