Apple Inc.

Michael Jeremy Coblenz

Shawn Patrick Flisakowski

Matthew Ross Lehrian

Ryan Michael Olshavsky

Edward Patrick Hogan

Jonathan Robert Speicher

Yik Shing Yip

Jeffery Robert Hunter

David G Franklin

Embodiments are disclosed in which an algorithm that evaluates the contents of a cell within an application incorporates error tracking. In certain such embodiments, a second cell is identified that is responsible for generation of an error indication within the cell. A link may be provided to the second cell to facilitate resolution of the error condition.

Cell error tracking in applications

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.

Updating formulas in response to table transposition

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.

Context sensitive computations

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.

Growing community of inventors

Sunnyvale, CA, United States of America

Michael Jeremy Coblenz