公开(公告)号：US20190294735A1

公开(公告)日：2019-09-26

申请号：US15935964

申请日：2018-03-26

Applicant: Apple Inc.

Inventor： Edward P. Hogan ,  Jonathan R. Speicher ,  Matthew R. Lehrian ,  Shawn P. Flisakowski

IPC: G06F17/30 ,  G06F17/27

Abstract: Embodiments are disclosed in which a process receives, via a graphical user interface (GUI) of a spreadsheet application, a function call. The function call includes a source string attribute identifying a string and a search string attribute identifying a substring to be identified in the string. The process performs a function associated with the function call by searching for the substring in the string and subsequently returning a subset of the string proximate to a location of the substring in the string.

公开(公告)号：US10409890B2

公开(公告)日：2019-09-10

申请号：US15862252

申请日：2018-01-04

Applicant: Apple Inc.

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

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

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.

公开(公告)号：US09489365B2

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

申请号：US13705767

申请日：2012-12-05

Applicant: APPLE INC.

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

IPC: G06F17/00 ,  G06F17/24 ,  G06F3/0481

CPC classification number: G06F17/245 ,  G06F3/0481

Abstract: The present disclosure relates to the resizing of tables elements, such as rows or columns of a table. In one embodiment, a user selects two or more rows or columns to be resized and performs a column or row manipulation corresponding to the desired resize event, such as be interacting with an edge of one of the selected rows or columns. In an implementation, the user may toggle between the use of different resizing algorithms to see the effects of the different resizing algorithms.

Abstract translation: 本公开涉及调整表元素的大小，例如表的行或列。 在一个实施例中，用户选择要调整大小的两个或更多个行或列，并且执行与期望的调整大小事件相对应的列或行操纵，诸如与所选择的行或列之一的边缘交互。 在一个实现中，用户可以在使用不同的调整大小算法之间切换以查看不同调整大小算法的效果。

公开(公告)号：US20140157101A1

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

申请号：US13705767

申请日：2012-12-05

Applicant: APPLE INC.

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

IPC: G06F17/24

CPC classification number: G06F17/245 ,  G06F3/0481

Abstract: The present disclosure relates to the resizing of tables elements, such as rows or columns of a table. In one embodiment, a user selects two or more rows or columns to be resized and performs a column or row manipulation corresponding to the desired resize event, such as be interacting with an edge of one of the selected rows or columns. In an implementation, the user may toggle between the use of different resizing algorithms to see the effects of the different resizing algorithms.

Abstract translation: 本公开涉及调整表元素的大小，例如表的行或列。 在一个实施例中，用户选择要调整大小的两个或更多个行或列，并且执行与期望的调整大小事件相对应的列或行操纵，诸如与所选择的行或列之一的边缘交互。 在一个实现中，用户可以在使用不同的调整大小算法之间切换以查看不同调整大小算法的效果。

公开(公告)号：US09626067B2

公开(公告)日：2017-04-18

申请号：US13712673

申请日：2012-12-12

Applicant: APPLE INC.

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

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

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.

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

公开(公告)号：US20150269747A1

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

申请号：US14223206

申请日：2014-03-24

Applicant: APPLE INC.

Inventor： Edward P. Hogan ,  Joe R. Howard ,  Marek R. Telgarsky ,  Matthew R. Lehrian

IPC: G06T7/40 ,  G06T11/60 ,  G06T11/00

CPC classification number: G06T7/408 ,  G06T11/001 ,  G06T11/60

Abstract: Automatic generation of custom palettes based on an image selected by a user is disclosed. In various embodiments, automatic palette generation may involve generating one or more than one palette based on the color or shading content of the image provided by the user. The generated palette may include a variety of colors (or shadings) that can be automatically mapped to and applied to various distinct features within a composite graphic construct to be customized.

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.

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

公开(公告)号：US09508158B2

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

申请号：US14223206

申请日：2014-03-24

Applicant: APPLE INC.

Inventor： Edward P. Hogan ,  Joe R. Howard ,  Marek R. Telgarsky ,  Matthew R. Lehrian

IPC: G06T5/00 ,  G06T11/20 ,  G06T3/20 ,  G06T5/40 ,  G06T11/00 ,  G09G5/02 ,  G09G5/06 ,  G09G5/14 ,  G06F3/08 ,  G06F3/048 ,  G06T7/40 ,  G06T11/60

CPC classification number: G06T7/408 ,  G06T11/001 ,  G06T11/60

Abstract: Automatic generation of custom palettes based on an image selected by a user is disclosed. In various embodiments, automatic palette generation may involve generating one or more than one palette based on the color or shading content of the image provided by the user. The generated palette may include a variety of colors (or shadings) that can be automatically mapped to and applied to various distinct features within a composite graphic construct to be customized.

Abstract translation: 公开了基于用户选择的图像自动生成自定义调色板。 在各种实施例中，自动调色板生成可以涉及基于由用户提供的图像的颜色或阴影内容生成一个或多于一个调色板。 生成的调色板可以包括可以自动映射到并且应用于要定制的复合图形构造内的各种不同特征的各种颜色（或阴影）。