Abstract: Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row.

Abstract: Multi-level naming of grouped data is disclosed. In some embodiments, a specification of a plurality of levels of headers with respect to at least one dimension of a group of cells is received, and header cell values of header cells comprising the plurality of levels of headers are enabled to refer to one or more associated cells in the group of cells.

Abstract: Preventing the inclusion of a reference to a host cell in a formula to avoid a circular reference in the formula is disclosed. In some embodiments, an indication of an attempted user gesture for inserting into a formula being entered into a host cell a reference to the host cell is received, and the attempted user gesture for inserting a reference to the host cell is disallowed to prevent a circular reference from being inserted into the formula being entered into the host cell.

Abstract: A method for scrolling a multi-section document is disclosed, including displaying on a display an electronic document that includes a plurality of document sections separated by respective logical structure boundaries; detecting a gesture on a touch-sensitive surface, the gesture having an initial velocity that exceeds a predefined speed threshold such that the gesture will scroll the electronic document more than one document section; initiating scrolling of the electronic document on the display at the initial velocity in accordance with an initial scrolling speed versus scrolling distance function; while scrolling the electronic document, adjusting the scrolling speed versus scrolling distance function so that when the scrolling speed becomes zero, a first logical structure boundary in the electronic document is displayed at a predefined location on the display; and, scrolling the electronic document in accordance with the adjusted scrolling speed versus scrolling distance function.

Abstract: Automatically completing a remainder portion of a name as it is being entered is disclosed. In some embodiments, in response to receiving at least a prescribed number of starting characters of a name being entered into a first cell as a reference name to refer to one or more other cells, a set of one or more valid reference names that begin with the received starting characters is determined and provided as auto-completion options. In such cases, a valid reference name is one that identifies using a supported syntax a spreadsheet document or a portion of a spreadsheet document.

Abstract: A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens.

Abstract: A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens.

Abstract: Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row.

Abstract: In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.

Abstract: Context sensitive delimiter insertion when adding references is disclosed. In some embodiments, a plurality of indications of selections of a cell or cell range while in a formula editing mode in a host cell into which a formula is being entered is successively received, and in response to receiving each indication of selection of the plurality a reference to the selected cell or cell range is successively inserted into the formula, wherein the references inserted into the formula are delimited by a first delimiter type if in a first context and wherein the references inserted into the formula are delimited by a second delimiter type if in a second context.

Abstract: A method for scrolling a multi-section document is disclosed, including displaying on a display an electronic document that includes a plurality of document sections separated by respective logical structure boundaries; detecting a gesture on a touch-sensitive surface, the gesture having an initial velocity that exceeds a predefined speed threshold such that the gesture will scroll the electronic document more than one document section; initiating scrolling of the electronic document on the display at the initial velocity in accordance with an initial scrolling speed versus scrolling distance function; while scrolling the electronic document, adjusting the scrolling speed versus scrolling distance function so that when the scrolling speed becomes zero, a first logical structure boundary in the electronic document is displayed at a predefined location on the display; and, scrolling the electronic document in accordance with the adjusted scrolling speed versus scrolling distance function.

Abstract: The present disclosure relates to the generation of distinctive presentations of an interface for different devices. In this manner, the interface is presented differently on different devices. In one embodiment, the interface is customized based upon a unique sequence or identifier associated with each electronic device such that the interface is distinctive on each respective device.

Abstract: A computing device with a display displays a first portion of an electronic document in a presentation mode of an electronic document authoring application. The first portion of the electronic document includes predefined activation regions for a plurality of presentation emphasis objects. While displaying the first portion of the electronic document the device detects a first input by a user on a respective predefined activation region for a first presentation emphasis object in the plurality of presentation emphasis objects. In response to detecting the first input on the respective predefined activation region for the first presentation emphasis object, the device: selects a first emphasis animation for the first presentation emphasis object based on the first input; displays the first emphasis animation; and displays the first presentation emphasis object.

Abstract: A method is performed at a multifunction device with a display and a touch-sensitive surface. The method includes: displaying a first user interface for an application at a first magnification level. The first user interface includes a first plurality of user interface objects. The application has a range of magnification levels, including a predefined magnification level for requesting a second user interface with a multi-finger pinch gesture.

Abstract: A method for scrolling a multi-section document is disclosed, including displaying on a display an electronic document that includes a plurality of document sections separated by respective logical structure boundaries; detecting a gesture on a touch-sensitive surface, the gesture having an initial velocity that exceeds a predefined speed threshold such that the gesture will scroll the electronic document more than one document section; initiating scrolling of the electronic document on the display at the initial velocity in accordance with an initial scrolling speed versus scrolling distance function; while scrolling the electronic document, adjusting the scrolling speed versus scrolling distance function so that when the scrolling speed becomes zero, a first logical structure boundary in the electronic document is displayed at a predefined location on the display; and, scrolling the electronic document in accordance with the adjusted scrolling speed versus scrolling distance function.

Abstract: Associating an object with a relevant data source is disclosed. In some embodiments, an object pasted into a destination document is associated with a data source included in the destination document. In various embodiments, the data source associated with the object may comprise a data source concurrently pasted with the object into the destination document, a data source already existing in the destination document prior to the object being pasted into the destination document, or a data source generated in the destination document using data extracted from the pasted object.

Abstract: Methods for touch-based gestural command input on a device with a touch-sensitive surface and a display are disclosed. In one embodiment, a method includes displaying an electronic canvas including an object at a first magnification level; simultaneously detecting a first and a second contact on the touch-sensitive surface, wherein at least one of the first contact and the second contact on the touch-sensitive surface is at a location that corresponds to a location on the display that is away from the object; detecting a gesture made with the first and second contacts; when a velocity of the gesture is less than a predefined gesture velocity threshold, scaling the electronic canvas in accordance with the gesture; and, when the velocity of the gesture is greater than the predefined gesture velocity threshold transitioning the electronic canvas from the first magnification level to a second, predefined magnification level in response to the gesture.

Abstract: Computing devices and methods for managing user interface content and user interface elements are disclosed. In one embodiment, after a plurality of user interface elements is selected from an ordered list, wherein a selection order is maintained for the selected plurality of user interface elements: a user gesture to perform an operation on the plurality of user interface elements is detected, and in response, a stack of temporarily displayed thumbnails corresponding to the selected plurality of user interface elements is displayed, wherein a display order of the stack of temporarily displayed thumbnails corresponds to the selection order of the selected plurality of user interface elements.

Abstract: A computing device with a display simultaneously displays a plurality of user interface objects, a currently selected user interface object, and a plurality of resizing handles for the currently selected user interface object. Each respective resizing handle has a corresponding handle activation region with a default position relative to the respective resizing handle, a default size, and a default shape. The device detects a first input on a first handle activation region for a first resizing handle in the plurality of resizing handles. In response to detecting the first input, the device: resizes the currently selected user interface object, and for at least one resizing handle in the plurality of resizing handles, modifies a corresponding handle activation region by changing the position of the handle activation region relative to the resizing handle from the default position to a modified position.

Abstract: A computing device with a display simultaneously displays a plurality of user-repositionable user interface objects with one or more activation regions. The device receives a first input from the user. Based at least in part on the first input, the device determines a first plurality of candidate actions for manipulating a user interface object. The device performs a first candidate action of the first plurality of candidate actions as determined in accordance with the first ordering. After performing the first candidate action, the device undoes the first candidate action, receives a third input that is a repetition of the first input, and determines a second plurality of candidate. The second plurality of candidate actions is ordered such that second candidate action in the second plurality of candidate actions has a higher position than the first candidate action in the second ordering. The device performs the second candidate action.