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

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