Abstract: Embodiments are disclosed in which an algorithm that updates or rewrites one or more formulas when a table is transposed in an application. In certain embodiments the formula is rewritten so as to preserve the functionality of the formula with respect to the transposed table. In certain embodiments, a notification may be provided that a formula is changed or not changed in response to the table transposition event.

Abstract: Context sensitive computations in a spreadsheet application are disclosed. In some embodiments, semantics with respect to various spreadsheet operations are specified for each of a plurality of number formats in a spreadsheet application. The semantics associated with a particular number format specify behavior for values of that number format with respect to various spreadsheet operations.

Abstract: The present disclosure relates to implementing changes to a data structure, such as a formula, in a collaborative context. In certain embodiments, collaborative changes made to a formula containing references to other portions of a table are retained or account for when an undo operation is performed. In one aspect, unique identifiers are used to identify and track table features, such as columns, rows, or cells, which may be moved, deleted, or created during a collaborative session. In some instances, collaborative changes may be logged for later application or applied to commands in an undo stack to prevent loss of changes.

Abstract: The present disclosure relates to implementing changes to a data structure, such as a formula, in a collaborative context. In certain embodiments, collaborative changes made to a formula containing references to other portions of a table are retained or account for when an undo operation is performed. In one aspect, unique identifiers are used to identify and track table features, such as columns, rows, or cells, which may be moved, deleted, or created during a collaborative session. In some instances, collaborative changes may be logged for later application or applied to commands in an undo stack to prevent loss of changes.

Abstract: Embodiments are disclosed in which an algorithm that updates or rewrites one or more formulas when a table is transposed in an application. In certain embodiments the formula is rewritten so as to preserve the functionality of the formula with respect to the transposed table. In certain embodiments, a notification may be provided that a formula is changed or not changed in response to the table transposition event.

Abstract: The present disclosure relates to implementing changes to a data structure, such as a formula, in a collaborative context. In certain embodiments, collaborative changes made to a formula containing references to other portions of a table are retained or account for when an undo operation is performed. In one aspect, unique identifiers are used to identify and track table features, such as columns, rows, or cells, which may be moved, deleted, or created during a collaborative session. In some instances, collaborative changes may be logged for later application or applied to commands in an undo stack to prevent loss of changes.

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: 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: Defining spreadsheet function behavior is disclosed. In some embodiments, in response to receiving a selection of a parameterized spreadsheet function behavior to be associated with a spreadsheet function, the parameterized spreadsheet function behavior is associated with the spreadsheet function based at least in part on the selection. In some embodiments, the parameterized spreadsheet function behavior is associated with a behavior of the function with respect to one or more arguments of the function.

Abstract: Context sensitive computations in a spreadsheet application are disclosed. In some embodiments, semantics with respect to various spreadsheet operations are specified for each of a plurality of number formats in a spreadsheet application. The semantics associated with a particular number format specify behavior for values of that number format with respect to various spreadsheet operations.