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

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

公开(公告)号：US20150365803A1

公开(公告)日：2015-12-17

申请号：US14632928

申请日：2015-02-26

Applicant: APPLE INC.

Inventor： Peter Glen Berger ,  Yik Shing Yip ,  Matthew Ross Lehrian ,  Michael Jeremy Coblenz

IPC: H04W4/02 ,  H04M1/725

CPC classification number: H04M1/72522 ,  G06F17/243 ,  G06F17/246 ,  H04W4/029

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