公开(公告)号：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.

公开(公告)号：US20190205359A1

公开(公告)日：2019-07-04

申请号：US15862252

申请日：2018-01-04

Applicant: Apple Inc.

Inventor： James M. Geisler ,  Edward P. Hogan ,  Zachariah N. Paine

IPC: G06F17/17 ,  G06F17/18 ,  G06F17/30 ,  G06F3/0484 ,  G06F17/24 ,  G06Q40/04

CPC classification number: G06F17/17 ,  G06F3/0484 ,  G06F16/90344 ,  G06F17/18 ,  G06F17/246 ,  G06Q40/04

Abstract: Embodiments are disclosed in which a process generates, receives, or both, via a graphical user interface (GUI) of a spreadsheet application, an evaluation statement. The evaluation statement includes a cell identifier, and the cell identifier specifies a modal reference cell that provides an indication of a modal attribute to be used in the evaluation statement. The indication of the modal attribute comprises a textual indicator related to the modal attribute, but has a format that is different than the modal attribute. The process evaluates the textual indicator to be used by the evaluation statement to determine a corresponding modal attribute and calculates a solution to the evaluation statement using the corresponding modal attribute as the modal attribute of the evaluation statement. The process displays the solution via the GUI.

公开(公告)号：US20150261794A1

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

申请号：US14206911

申请日：2014-03-12

Applicant: Apple Inc.

Inventor： Matthew R. Lehrian ,  Edward P. Hogan

IPC: G06F17/30

CPC classification number: G06F17/246 ,  G06F3/0486

Abstract: The present approaches relate to the creation or updating of a table using data acquired from an external source. In one embodiment, the data acquired from the external source may be dragged-and-dropped onto a new or existing table to invoke execution data import or update routines. In the case of an update, a unique key within the existing table may correspond to a field within the acquired external data set, allowing record matching to be performed such that matched records may be updated and new records may be added to the table. In addition, identified fields in the acquired external data set may correspond to or be matched with columns of the table, allowing data values to be matched and updated regardless of differences in the layout of the table and the acquired external data set.

Abstract translation: 本方法涉及使用从外部源获取的数据创建或更新表。 在一个实施例中，从外部源获取的数据可以被拖放到新的或现有的表上以调用执行数据导入或更新例程。 在更新的情况下，现有表中的唯一密钥可以对应于所获取的外部数据集中的字段，允许执行记录匹配，使得可以更新匹配的记录，并且可以向表中添加新记录。 此外，所获取的外部数据集中的标识字段可以对应于或与表的列匹配，从而允许数据值被匹配和更新，而与表的布局和所获取的外部数据集之间的差异无关。

公开(公告)号：US20140164992A1

公开(公告)日：2014-06-12

申请号：US13712673

申请日：2012-12-12

Applicant: APPLE INC.

Inventor： Edward P. Hogan ,  Matthew R. Lehrian ,  Zachariah N. Paine ,  Marek R. Telgarsky

IPC: G06F3/0484

CPC classification number: G06F3/0481 ,  G06F17/245 ,  G06F2203/04806

Abstract: Approaches are disclosed for maintaining spatial relationships (i.e., a layout) between a table object and other objects placed on a virtual canvas of an application work space. In certain implementations, offsets between the other objects and the table object are initially determined and are used to maintain the spatial relationships when the table object is resized. In certain implementations, the movement of the objects in response to a resize of the table object is dynamic from the user's perspective and can be easily undone.

Abstract translation: 公开了用于维护表对象和放置在应用程序工作空间的虚拟画布上的其他对象之间的空间关系（即，布局）的方法。 在某些实现中，最初确定其他对象和表对象之间的偏移，并且当表对象被调整大小时用于维护空间关系。 在某些实现中，响应于表对象的调整大小，对象的移动是从用户的角度动态的并且可以容易地被撤销。