公开(公告)号：US20160041963A1

公开(公告)日：2016-02-11

申请号：US14452415

申请日：2014-08-05

Applicant: APPLE INC.

Inventor： Michael Jeremy Coblenz ,  Shawn Patrick Flisakowski

IPC: G06F17/24

CPC classification number: G06F17/245 ,  G06F17/2288 ,  G06F17/246

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 translation: 本公开涉及在协作上下文中实现诸如公式的数据结构的改变。 在某些实施例中，对包含对表的其他部分的引用的公式进行的协作改变被保留或者在执行撤消操作时考虑。 在一个方面，使用唯一标识符来识别和跟踪表特征，例如可以在协作会话期间移动，删除或创建的列，行或单元。 在某些情况下，可能会记录协作更改以供稍后应用或应用于撤消堆栈中的命令，以防止丢失更改。

公开(公告)号：US20170286387A1

公开(公告)日：2017-10-05

申请号：US15627185

申请日：2017-06-19

Applicant: Apple Inc.

Inventor： Shawn Patrick Flisakowski ,  Michael Jeremy Coblenz

IPC: G06F17/24 ,  G06F17/22

CPC classification number: G06F17/245 ,  G06F17/2288 ,  G06F17/246

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.

公开(公告)号：US09684646B2

公开(公告)日：2017-06-20

申请号：US14452415

申请日：2014-08-05

Applicant: APPLE INC.

Inventor： Michael Jeremy Coblenz ,  Shawn Patrick Flisakowski

IPC: G06F17/24 ,  G06F17/22

CPC classification number: G06F17/245 ,  G06F17/2288 ,  G06F17/246

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.

公开(公告)号：US10657321B2

公开(公告)日：2020-05-19

申请号：US16128306

申请日：2018-09-11

Applicant: Apple Inc.

Inventor： Shawn Patrick Flisakowski ,  Matthew R. Lehrian ,  Edward P. Hogan ,  Anukul Kapoor ,  Marek R. Telgarsky

IPC: G06F17/00 ,  G06F40/18 ,  G06F40/103 ,  G06F3/0482 ,  G06F3/0484

Abstract: 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.

公开(公告)号：US10152470B2

公开(公告)日：2018-12-11

申请号：US14511761

申请日：2014-10-10

Applicant: Apple Inc.

Inventor： Edward Patrick Hogan ,  Jonathan Robert Speicher ,  Matthew Ross Lehrian ,  Michael Jeremy Coblenz ,  Ryan M. Olshavsky ,  Shawn Patrick Flisakowski

IPC: G06F17/24 ,  G06F17/21

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.

公开(公告)号：US20160103819A1

公开(公告)日：2016-04-14

申请号：US14511761

申请日：2014-10-10

Applicant: Apple Inc.

Inventor： Edward Patrick Hogan ,  Jonathan Robert Speicher ,  Matthew Ross Lehrian ,  Michael Jeremy Coblenz ,  Ryan M. Olshavsky ,  Shawn Patrick Flisakowski

IPC: G06F17/24 ,  G06F17/21

CPC classification number: G06F17/246 ,  G06F17/245

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 translation: 公开了一种实施例，其中当在应用中转置表时更新或重写一个或多个公式的算法。 在某些实施例中，公式被重写以保持相对于转置表的公式的功能。 在某些实施例中，可以提供响应于表转置事件改变公式或不改变公式的通知。

公开(公告)号：US08832677B2

公开(公告)日：2014-09-09

申请号：US14072327

申请日：2013-11-05

Applicant: Apple Inc.

Inventor： Shawn Patrick Flisakowski ,  Keith Walter Rauenbuehler

IPC: G06F9/44 ,  G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30244 ,  G06F17/30256 ,  G06F17/3028

Abstract: 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.

公开(公告)号：US20200081968A1

公开(公告)日：2020-03-12

申请号：US16128306

申请日：2018-09-11

Applicant: Apple Inc.

Inventor： Shawn Patrick Flisakowski ,  Matthew R. Lehrian ,  Edward P. Hogan ,  Anukul Kapoor ,  Marek R. Telgarsky

IPC: G06F17/24 ,  G06F17/21

Abstract: 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.

公开(公告)号：US20140059025A1

公开(公告)日：2014-02-27

申请号：US14072327

申请日：2013-11-05

Applicant: Apple Inc.

Inventor： Shawn Patrick Flisakowski ,  Keith Walter Rauenbuehler

IPC: G06F17/30

CPC classification number: G06F17/30244 ,  G06F17/30256 ,  G06F17/3028

Abstract: 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.

Abstract translation: 描述了用于管理层级中的数字内容的方法，装置和系统。 从外部设备接收数字图像的第一版本，其追踪第一版本的变化。 确定存在已经跟踪的数字图像的第二版本的变化。 基于比较两个版本的跟踪更改，组合版本。 第一个版本是通过拆分存储在主层次结构中的第二个版本，并将拆分版本发送到外部设备创建的。 在拆分期间，信息的子级别从主层次结构被拆分，子层次结构包括主层次结构的部分以访问第二版本，使得可以独立于主层次结构访问第二版本。 在更改表中跟踪对版本的更改，例如，使用捣碎到单个记录中的值。