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

公开(公告)号：US20200302008A1

公开(公告)日：2020-09-24

申请号：US16358591

申请日：2019-03-19

Applicant: Apple Inc.

Inventor： Edward Patrick Hogan ,  Anukul Kapoor

IPC: G06F17/24 ,  G06F3/0484 ,  G06F3/0482

Abstract: Systems, methods, and devices for modifying a summary cell for a set of organized cells are provided. In some embodiments, the summary cells may be modified by modification of the summary function, such that modification may include a function and/or text that is different than preexisting summary function options for a summary cell. In some embodiments, the modification of the summary cell for the set of organized cells may update summary cells for additional sets of organized cells using a corresponding function and/or text that is different than preexisting summary function.

公开(公告)号：US20160378811A1

公开(公告)日：2016-12-29

申请号：US14750704

申请日：2015-06-25

Applicant: Apple Inc.

Inventor： Anukul Kapoor ,  Edward P. Hogan

IPC: G06F17/30

CPC classification number: G06F16/2282 ,  G06F16/245

Abstract: An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data. The program also provides a mechanism whereby by rows and columns may be prioritized for display, particularly on a relatively smaller mobile display. The prioritization(s) are then used by a device, whether the same or different than used to create provide the designations, to use the prioritizations to display the prioritized information, with other information being nested and displayable upon an interaction from a user, such as touching a displayed primary column cell to cause a secondary nested and related column cell to be displayed. In some instances, table designations occur automatically based on some attribute of the table or table data.

Abstract translation: 公开了一种物品，装置和方法。 该装置和相关方法涉及包括诸如文字处理程序或电子表格程序的程序的计算设备，其被配置为通过主要和其它指定来组织数据表和显示或以其他方式使用数据表。 该程序还提供了一种机制，其中行和列可以被优先显示，特别是在相对较小的移动显示器上。 优先次序随后由设备使用，无论相同或不同于用于创建的设备提供指定，以使用优先级来显示优先级信息，其他信息在用户交互时嵌套和显示，例如 触摸显示的主列单元格以使得显示次级嵌套和相关的列单元格。 在某些情况下，根据表或表数据的某些属性自动生成表名称。

公开(公告)号：US10853342B2

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

申请号：US14750704

申请日：2015-06-25

Applicant: Apple Inc.

Inventor： Anukul Kapoor ,  Edward P. Hogan

IPC: G06F16/22 ,  G06F16/245 ,  G06F16/957 ,  G06F3/0488

Abstract: An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data. The program also provides a mechanism whereby by rows and columns may be prioritized for display, particularly on a relatively smaller mobile display. The prioritization(s) are then used by a device, whether the same or different than used to create provide the designations, to use the prioritizations to display the prioritized information, with other information being nested and displayable upon an interaction from a user, such as touching a displayed primary column cell to cause a secondary nested and related column cell to be displayed. In some instances, table designations occur automatically based on some attribute of the table or table data.

公开(公告)号：US10776574B1

公开(公告)日：2020-09-15

申请号：US16358591

申请日：2019-03-19

Applicant: Apple Inc.

Inventor： Edward Patrick Hogan ,  Anukul Kapoor

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

Abstract: Systems, methods, and devices for modifying a summary cell for a set of organized cells are provided. In some embodiments, the summary cells may be modified by modification of the summary function, such that modification may include a function and/or text that is different than preexisting summary function options for a summary cell. In some embodiments, the modification of the summary cell for the set of organized cells may update summary cells for additional sets of organized cells using a corresponding function and/or text that is different than preexisting summary function.

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