Referring to cells using header cell values
AssigneeApple Inc.
InventorsYaniv Gur, Jay Christopher Capela, Peter William Rapp, Roger Rock Rosner, Christopher Douglas Weeldreyer
Life of this patent
Estimating the term…
Abstract
Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row.
Claims20
A method comprising:
- receiving, via a processor, a selection of a first header cell in a table, wherein the first header cell is associated with a first set of cells that includes the first header cell and a first plurality of body cells;
- entering, via the processor, a formula editing mode in the first header cell;
- receiving, via the processor, an entry of a formula into the first header cell while in the formula editing mode, wherein the formula comprises a second header cell as an argument of the formula, wherein the second header cell is associated with a second set of cells that includes the second header cell and a second plurality of body cells;
- and
- entering, via the processor, a modified formula into each of the first plurality of body cells, wherein the modified formula comprises the formula entered into the first header cell and replaces the second header cell with a reference to a corresponding body cell of the second plurality of body cells disposed in the same row or column as a respective body cell of the first plurality of body cells without overwriting the first header cell.
A method comprising:
- receiving, via a processor, a selection of a cell in a table, wherein the table comprises a first set of cells that includes a first header cell, a plurality of first body cells, and a first footer cell of the table;
- entering, via the processor, a formula editing mode in the cell;
- receiving, via the processor, an entry of a formula into the cell while in the formula editing mode, wherein the formula comprises a reference to the first header cell as an argument of the formula;
- and
- entering, via the processor, the formula into the cell, wherein the reference to the first header cell in the formula is treated as a reference to a range comprising the first body cells, wherein the range does not include the first footer cell.
One or more articles of manufacture comprising tangible, non-transitory machine-readable media comprising processor-executable instructions to:
- receive an initial selection of a cell in a table, wherein the table comprises at least a first set of cells that includes a first header cell and a first plurality of body cells, wherein the cell is not one of the first plurality of body cells;
- enter a formula editing mode in the cell to enable entry of a formula into the cell;
- receive a subsequent selection of at least one of the first plurality of body cells while in the formula editing mode in the cell;
- and
- in response to receiving the subsequent selection of the at least one of the first plurality of body cells while in the formula editing mode, enter an argument into the formula of the cell comprising a reference to at least the first header cell.
Dependencies are inferred from the claim text.