Abstract: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

Abstract: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

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, 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: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

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: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

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: Features associated with smart tables are disclosed. In some embodiments, address tabs associated with a table are provided on-demand in response to receiving an indication of interest in the table. In some embodiments, controls for modifying the number of rows and/or columns of a table are provided on-demand when an indication of interest in the table is received. In some embodiments, in response to a passive indication of interest in an address tab associated with a row or column of a table, a set of one or more options associated with the row or column and/or associated table are made available.

Abstract: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

Abstract: Providing an infinite or seemingly infinite canvas as a workspace is disclosed. In some embodiments, an ability to add to a displayed canvas and view simultaneously one or more table objects, each of which has associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed, is provided.

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: 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: Pasting a set of cells is disclosed. In some embodiments, a selection of an option to paste a set of cells in a paste destination is received; and in response to determining that the paste destination is not large enough to accommodate a paste operation associated with the selected option, the paste destination is automatically expanded so that the paste destination is large enough to accommodate the paste operation.

Abstract: Including multiple types of objects on a canvas is disclosed. In some embodiments, an ability to include on a displayed canvas simultaneously a set of objects comprising one or more objects of two or more different types, including a first type of object having associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed and a second type of object not having said ability associated with it, is provided.

Abstract: Features associated with smart tables are disclosed. In some embodiments, address tabs associated with a table are provided on-demand in response to receiving an indication of interest in the table. In some embodiments, controls for modifying the number of rows and/or columns of a table are provided on-demand when an indication of interest in the table is received. In some embodiments, in response to a passive indication of interest in an address tab associated with a row or column of a table, a set of one or more options associated with the row or column and/or associated table are made available.

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: 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: Including multiple types of objects on a canvas is disclosed. In some embodiments, an ability to include on a displayed canvas simultaneously a set of objects comprising one or more objects of two or more different types, including a first type of object having associated with it an ability to define the content of a first cell by reference to one or more other cells such that the content of the first cell is updated automatically and without further human intervention if the content of one or more of the one or more other cells is changed and a second type of object not having said ability associated with it, is provided.

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.