Apple Inc.

Shawn Patrick Flisakowski

Keith Walter Rauenbuehler

Matthew Ross Lehrian

Alexander David Wallace

Edward Patrick Hogan

Michael Jeremy Coblenz

Craig Milito

Ryan Michael Olshavsky

Jonathan Robert Speicher

Marek Rastislav Telgarsky

Anukul Kapoor

Systems, methods, and devices for tracking spreadsheet table cells from a base table to an organized table/organized table view, and updating of a formula reference based on the tracked cells are provided. In some embodiments, cells may be tracked to convert a first range of cells in the base table into a second range of cells in the organized table/organized table view, such that the second range of cells includes the same cells as the first range of cells, despite any reorganization of rows and columns. In some embodiments, a summary reference cell that provides a sub-group summary based upon the grouping within the organized table/organized table view may also be provided.

Exploded-range references

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

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.

Reference representation and transformation in collaborative documents

Methods, apparatuses, and systems for managing digital content in hierarchies are described. A first version of a digital image is received from an external device which tracks changes to the first version. It is determined that a second version of the digital image, changes to which have been tracked, exists. Based on comparing the tracked changes of both versions, the versions are combined. The first version is created by splitting the second version, which is stored in a master hierarchy, and transmitting the split version to the external device. During splitting, a child hierarchy of information is split from the master hierarchy, the child hierarchy including portions of the master hierarchy to access the second version such that the second version can be accessed independent of the master hierarchy. Changes to the versions are tracked in change tables, for example, using values that are mashed into a single record.

Managing digital content in hierarchies

Methods, systems, and apparatus, including computer program products, for synchronizing database changes among multiple devices. In one aspect, a method includes determining one or more primary differences between a primary database and a local synchronization database; receiving, from a secondary device, one or more secondary differences associated with a secondary database; merging the primary differences and the secondary differences to generate a set of merged differences; providing the set of merged differences to the secondary device; receiving, from the secondary device, an acknowledgment indicating receipt of the set of merged differences; and updating the primary database in accordance with the set of merged differences after receipt of the acknowledgment. Further, at least one conflict can be detected between the primary differences and the secondary differences, and can be resolved prior to generating the set of merged differences.

Growing community of inventors

Cupertino, CA, United States of America

Shawn Patrick Flisakowski