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: Automated population of location-based data and formulae into electronic documents is disclosed. In one embodiment, in response to detecting a user selection of a first data population control, first location-based data is populated in an electronic document, wherein the first location-based data includes data obtained from a location-data source. After the first location-based data is populated in the electronic document, in response to detecting a user selection of a second data population control, second location-based data and one or more formulae are populated in the electronic document, wherein the second location-based data includes data obtained from the location-data source, and wherein the one or more formulae are configured for performing calculations upon the first and second location-based data.

Abstract: A method includes: displaying a collection of objects; detecting a gesture made by a contact on the touch-sensitive surface, the gesture comprising a first movement of the contact on the touch-sensitive surface followed by a pause in movement of the contact followed by a second movement of the contact on the touch-sensitive surface; selecting a plurality of objects in the collection of objects in accordance with the first movement; and, after detecting the pause in movement of the contact, moving the selected plurality of objects away from unselected objects in the collection of objects in accordance with the second movement.

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: Automatically populating and/or generating tables using data extracted from files is disclosed. In some embodiments, in response to receiving an indication that at least a portion of a data object is desired to be included in a table, a set of one or more data values associated with the data object is selected for inclusion in the table and automatically included as an entry corresponding to the data object in the table. In various embodiments, the table may comprise an existing table and/or a newly generated table.

Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, providing a feature with respect to a set of cells includes determining that a degradation threshold associated with the feature is satisfied with respect to the set of cells and at least partially degrading the feature for the set of cells.

Abstract: Context-sensitive, automated use of a magnification loupe is disclosed to facilitate management and manipulation of user interface content and small user interface elements via gestures on a touch-sensitive surface. In one embodiment, a magnifying loupe is displayed based on the context associated with a finger-based gesture on a touch-sensitive surface. For example, a magnification loupe is displayed when one or more user interface elements corresponding to the location of the gesture on the touch-sensitive surface is smaller than a predefined size threshold, but the loupe is not displayed when the user interface elements corresponding to the location of the gesture on the touch-sensitive surface are larger than the predefined size threshold. In another embodiment, the magnification power of the loupe varies based on the size of the one or more user interface elements corresponding to the location of the gesture on the touch-sensitive surface.

Abstract: In some embodiments, the grid definition and data source definition portions of a table definition are segregated. Grid definition values included in the grid definition portion include one or more grid geometry values and/or grid line style values. Cell content values included in the data source definition portion include one or more data values and/or cell-specific style values.

Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, a feature is provided with respect to a set of spreadsheet cells. The feature consumes processing power. If a degradation threshold associated providing the feature is satisfied, the feature is at least partially degraded so that an expected latency of providing the feature is at least in part avoided. If a restoration threshold associated with providing the feature is satisfied, the feature is at least partially restored for the set of cells.

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: 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: 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: A method includes: displaying a collection of objects; detecting a gesture made by a contact on the touch-sensitive surface, the gesture comprising a first movement of the contact on the touch-sensitive surface followed by a pause in movement of the contact followed by a second movement of the contact on the touch-sensitive surface; selecting a plurality of objects in the collection of objects in accordance with the first movement; and, after detecting the pause in movement of the contact, moving the selected plurality of objects away from unselected objects in the collection of objects in accordance with the second movement.

Abstract: Automated population of location-based data and formulae into electronic documents is disclosed. In one embodiment, in response to detecting a user selection of a first data population control, first location-based data is populated in an electronic document, wherein the first location-based data includes data obtained from a location-data source. After the first location-based data is populated in the electronic document, in response to detecting a user selection of a second data population control, second location-based data and one or more formulae are populated in the electronic document, wherein the second location-based data includes data obtained from the location-data source, and wherein the one or more formulae are configured for performing calculations upon the first and second location-based data.

Abstract: Context-sensitive, automated use of a magnification loupe is disclosed to facilitate management and manipulation of user interface content and small user interface elements via gestures on a touch-sensitive surface. In one embodiment, a magnifying loupe is displayed based on the context associated with a finger-based gesture on a touch-sensitive surface. For example, a magnification loupe is displayed when one or more user interface elements corresponding to the location of the gesture on the touch-sensitive surface is smaller than a predefined size threshold, but the loupe is not displayed when the user interface elements corresponding to the location of the gesture on the touch-sensitive surface are larger than the predefined size threshold. In another embodiment, the magnification power of the loupe varies based on the size of the one or more user interface elements corresponding to the location of the gesture on the touch-sensitive surface.

Abstract: Cutting and copying discontiguous selections of cells is disclosed. In some embodiments, in response to receiving an indication of a selection of a set of cells that does not include only a continuous grid of selected cells and receiving an indication of a selection of a paste destination in which the set of cells is desired to be pasted, the set of cells is pasted in the paste destination in a manner that preserves a respective relative position of each cell in the set. In some embodiments, if a paste destination is not large enough to accommodate a paste operation, the paste destination is automatically expanding so that it is large enough to accommodate the paste operation.

Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, providing a feature with respect to a set of cells includes determining that a degradation threshold associated with the feature is satisfied with respect to the set of cells and at least partially degrading the feature for the set of cells.

Abstract: In some embodiments, text that includes one or more prescribed characters is represented on a pasteboard in a plurality of representations, including an escaped representation that escapes the one or more prescribed characters so that a format of the text can be preserved when the text is pasted into a cell of a spreadsheet application that does not natively support inclusion of the one or more prescribed characters in cell content.

Abstract: In some embodiments, the cell content portion of a table definition of a table of cells is specified in a prescribed order such that cell positions do not have to be explicitly specified with cell definitions in the cell content portion of the table definition. The cells of the table to which one or more entries in the cell content portion correspond to are inferred from the prescribed order in which the entries are specified.

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.