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: 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: An electronic device displays at least a portion of an electronic document with a predefined page layout at a first magnification level on a display; detects a first input indicating a first insertion point in the document, where the first insertion point is proximate to a first portion of text in the document; and in response to detecting the first input: selects a second magnification level different from the first magnification level, where the second magnification level is selected so as to display the first portion of text at a target text display size, and, while maintaining the predefined page layout of the document, displays, at the second magnification level, a portion of the document that includes the first portion of text.

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, an option to lock one or more associated cells is provided with respect to each different group of cells in a single sheet of a spreadsheet application. One or more locked cells of a group of cells do not scroll out of view at least while a portion of the group of cells is viewable in a given display view.

Abstract: An electronic device displays text of an electronic document on a display; displays an insertion marker at a first position in the text of the electronic document; detects a first horizontal gesture on a touch-sensitive surface; in response to a determination that the first horizontal gesture satisfies a first set of one or more predefined conditions: translates the electronic document on the display in accordance with a direction of the first horizontal gesture, and maintains the insertion marker at the first position in the text; and, in response to a determination that the first horizontal gesture satisfies a second set of one or more predefined conditions, moves the insertion marker by one character in the text from the first position to a second position in the text in accordance with the direction of the first horizontal gesture.

Abstract: An electronic device displays at least a portion of an electronic document with a predefined page layout at a first magnification level on a display; detects a first input indicating a first insertion point in the document, where the first insertion point is proximate to a first portion of text in the document; and in response to detecting the first input: selects a second magnification level different from the first magnification level, where the second magnification level is selected so as to display the first portion of text at a target text display size, and, while maintaining the predefined page layout of the document, displays, at the second magnification level, a portion of the document that includes the first portion of text.

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: An electronic device displays text of an electronic document on a display; displays an insertion marker at a first position in the text of the electronic document; detects a first horizontal gesture on a touch-sensitive surface; in response to a determination that the first horizontal gesture satisfies a first set of one or more predefined conditions: translates the electronic document on the display in accordance with a direction of the first horizontal gesture, and maintains the insertion marker at the first position in the text; and, in response to a determination that the first horizontal gesture satisfies a second set of one or more predefined conditions, moves the insertion marker by one character in the text from the first position to a second position in the text in accordance with the direction of the first horizontal gesture.

Abstract: Grouping a set of data is disclosed. In some embodiments, a set of data is grouped with respect to a column and/or a row associated with the set of data in response to receiving a selection of an option to group the set of data with respect to the column and/or the row. In some embodiments, the grouping of the set of data is based on real time values of the set of data and is automatically and dynamically updated in response to changes in the set of data.

Abstract: At a multifunction device with a display and a touch-sensitive surface, a plurality of objects are displayed on the display. The plurality of objects have a first layer order. A first contact is detected at a location on the touch-sensitive surface that corresponds to a location of a respective object of the plurality of objects. While detecting the first contact, a gesture that includes a second contact is detected on the touch-sensitive surface. In response to detecting the gesture, the plurality of objects are reordered in accordance with the gesture to create a second layer order that is different from the first layer order. In some embodiments, the position of the respective object within the first order is different from the position of the respective object within the second order.

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: 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: 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: An electronic device displays at least a portion of an electronic document with a predefined page layout at a first magnification level on a display; detects a first input indicating a first insertion point in the document, where the first insertion point is proximate to a first portion of text in the document; and in response to detecting the first input: selects a second magnification level different from the first magnification level, where the second magnification level is selected so as to display the first portion of text at a target text display size, and, while maintaining the predefined page layout of the document, displays, at the second magnification level, a portion of the document that includes the first portion of text.

Abstract: A method for resizing a currently selected user interface object includes simultaneously displaying on a touch-sensitive display the currently selected user interface object having a center, and a plurality of resizing handles for the currently selected user interface object. The method also includes detecting a first contact on a first resizing handle in the plurality of resizing handles, and detecting movement of the first contact across the touch-sensitive display. The method further includes, in response to detecting movement of the first contact, when a second contact is detected on the touch-sensitive display while detecting movement of the first contact, resizing the currently selected user interface object about the center of the currently selected user interface object.

Abstract: An electronic device displays at least a portion of an electronic document with a predefined page layout at a first magnification level on a display; detects a first input indicating a first insertion point in the document, where the first insertion point is proximate to a first portion of text in the document; and in response to detecting the first input: selects a second magnification level different from the first magnification level, where the second magnification level is selected so as to display the first portion of text at a target text display size, and, while maintaining the predefined page layout of the document, displays, at the second magnification level, a portion of the document that includes the first portion of text.

Abstract: An electronic device displays at least a portion of an electronic document with a predefined page layout at a first magnification level on a display; detects a first input indicating a first insertion point in the document, where the first insertion point is proximate to a first portion of text in the document; and in response to detecting the first input: selects a second magnification level different from the first magnification level, where the second magnification level is selected so as to display the first portion of text at a target text display size, and, while maintaining the predefined page layout of the document, displays, at the second magnification level, a portion of the document that includes the first portion of text.