Referring to cells using header cell values
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.
Latest Patents:
- METHODS AND THREAPEUTIC COMBINATIONS FOR TREATING IDIOPATHIC INTRACRANIAL HYPERTENSION AND CLUSTER HEADACHES
- OXIDATION RESISTANT POLYMERS FOR USE AS ANION EXCHANGE MEMBRANES AND IONOMERS
- ANALOG PROGRAMMABLE RESISTIVE MEMORY
- Echinacea Plant Named 'BullEchipur 115'
- RESISTIVE MEMORY CELL WITH SWITCHING LAYER COMPRISING ONE OR MORE DOPANTS
In typical spreadsheet applications, cells are referred to or addressed using column (e.g., A, B, C, etc.) and row (e.g., 1, 2, 3, etc.) address tabs. Each cell is uniquely identified by a cell address that reflects the column and row address tabs, respectively, of the column and row in which the cell is located (e.g., A1). Headings or labels may be entered into one or more cells to give meaning to data included in a corresponding column or row. For example, if the cells of column A are to include revenue data, the top cell in the column (e.g., cell A1) may be labeled as “REVENUE”.
Various embodiments of the invention are disclosed in the following detailed description and the accompanying drawings.
The invention can be implemented in numerous ways, including as a process, an apparatus, a system, a composition of matter, a computer readable medium such as a computer readable storage medium or a computer network wherein program instructions are sent over optical or communication links. In this specification, these implementations, or any other form that the invention may take, may be referred to as techniques. A component such as a processor or a memory described as being configured to perform a task includes both a general component that is temporarily configured to perform the task at a given time or a specific component that is manufactured to perform the task. In general, the order of the steps of disclosed processes may be altered within the scope of the invention.
A detailed description of one or more embodiments of the invention is provided below along with accompanying figures that illustrate the principles of the invention. The invention is described in connection with such embodiments, but the invention is not limited to any embodiment. The scope of the invention is limited only by the claims and the invention encompasses numerous alternatives, modifications and equivalents. Numerous specific details are set forth in the following description in order to provide a thorough understanding of the invention. These details are provided for the purpose of example and the invention may be practiced according to the claims without some or all of these specific details. For the purpose of clarity, technical material that is known in the technical fields related to the invention has not been described in detail so that the invention is not unnecessarily obscured.
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.
As used herein, the term “cell” refers to a cell associated with at least standard spreadsheet functionality. The term “at least standard spreadsheet functionality” in the context of a cell includes the ability to define the content of one cell in such a way that the content of the one cell is determined based at least in part on the content of one or more other cells, and the content of the one cell is updated automatically without further human action if the content of one or more of the one or more other cells is changed. As used herein, the term “host cell” refers to a cell in a formula editing mode, i.e., a cell into which a formula is being entered. In some embodiments, cells in a spreadsheet application are organized into one or more individual tables or table objects, each of which includes a desired number of rows and columns of cells. In such cases, a sheet of a spreadsheet document may include a desired number of table objects. Although in many of the examples described herein the cells of a spreadsheet application are organized into such table objects, the techniques described herein may be similarly employed with respect to other cell configurations or organizations, such as the (seemingly) infinite single grid or table of cells in each sheet of some typical spreadsheet applications that includes an unlimited (or very large) number of rows and columns of cells. Although many of the examples provided herein are with respect to a spreadsheet application, the techniques described herein may be similarly employed with respect to any application, spreadsheet or otherwise.
In some embodiments, one or more of a header row, header column, and footer row may be included in a table.
In some embodiments, if specified, one or more header cell values can be used to refer to or address the rows, columns, and/or cells of a table in a manner analogous to address tabs. For example, with respect to
Address tabs may be displayed with respect to a table such as in
In some embodiments, when used to refer to a corresponding column or row, a header cell value refers to only body cells associated with the corresponding column or row. For example, in the formula “=SUM(Q1)” in the example of
Although using header cell values to refer to or address the rows, columns, and/or cells of a table when in a formula editing mode has been described in the given examples, header cell values can be similarly employed to refer to the rows, columns, and/or cells of a table in any other context such as, for example, when specifying source data when creating a chart or graph from data included in one or more tables.
As described above, the rows, columns, and/or cells of a table may be addressed or referred to using associated address tabs and/or header cell values. Like unique address tabs that are associated with each row and column, unique header cell values need to be selected for header cells included in a table to be able to uniquely identify the rows, columns, and/or cells of the table using associated header cell values. A spreadsheet document or file may include one or more sheets (or canvases), and each sheet (or canvas) may include one or more tables and/or other objects. In some embodiments, each table included in a sheet is uniquely named so that the rows, columns, and cells included in each table can be uniquely identified. In some embodiments, an option to show or hide the table name with a table is provided. For example, the table name is hidden in the examples of
In the syntax of Table 1, header cell and/or address tab values may be employed for the row name and column name parameters. In some embodiments, in the cases in which one or more address tab values are used for the row name and/or column name parameters in the syntax provided for a cell in Table 1, the space between the row name and column name parameters may be omitted. The sheet name and/or table name parameters may be included to uniquely refer to a row, column, or cell of a table. In various embodiments, the sheet name and/or table name parameters may be omitted if a row, column, and/or cell being referred to can be uniquely identified without one or more of those parameters. In some embodiments, when including a reference to a row, column, or cell of a table in a cell of the same table, the table name and/or sheet name parameters may be omitted; and when including a reference to a row, column, or cell of a table in a cell of a different table in the same sheet and/or in a different object in the same sheet, the sheet name parameter (and in some embodiments also the table name parameter, e.g., if the header cell value(s) in the reference are unique at least within the associated sheet) may be omitted. When including a reference to a row, column, or cell of a table in a cell of a different table in a different sheet and/or in a different object in a different sheet, in some embodiments, the sheet name parameter may be omitted, e.g., if an associated table name parameter that is included in the reference is unique across all sheets of a document, and in some embodiments the table name parameter may also be omitted if the header cell value(s) in the reference are unique across all tables (and/or other objects) in all sheets. In some embodiments, even though redundant and/or unnecessary, the sheet name and/or table name parameters may be included in a reference. In the cases in which the row name and/or column name parameters are specified using address tabs, the table name and/or sheet name may need to be specified. In some embodiments, a row, column, and/or cell of a table in one document can be referred to in another document by further including a document name parameter in a reference, e.g., by adding <DocumentName> to the syntax of Table 1. Table 1 provides one embodiment of a syntax that can be employed to uniquely identify or refer to the rows, columns, and cells of a table in a spreadsheet application. Any other appropriate syntax may be employed in other embodiments.
In some embodiments, while a user is entering or typing a sheet name, table name, row name, and/or column name, for example, when entering a reference in a formula using a syntax such as that provided in Table 1, auto-completion of the name being typed is available and/or provided. In the cases in which multiple potential matches exist for the name being typed, an interface that includes the potential matches is presented from which a desired value can be selected by the user. In various embodiments, the auto-completion feature is or can be configured to be available once a prescribed number of the first few characters of a name have been typed. In some embodiments, the auto-completion feature is automatically provided after a prescribed number of the first few characters of a name have been typed. In some embodiments, the auto-completion feature is provided in response to a user typing at least a prescribed number of the first few characters of a name followed by one or more arrow keys. In some embodiments, the auto-completion feature is available on the third keystroke (i.e. starting with the third character of a name), and if multiple matches exist, a drop down list of matching auto-completion options is provided. In some embodiments, an option to turn the auto-completion feature on or off is provided. In some embodiments, in addition to appending the completion of the name being typed, the auto-completion feature prepends extra information or identifiers such as a document name, sheet name, and/or table name, for example, to provide further disambiguation when the same (row, column, and/or table) name is used multiple times.
In some embodiments, such as in the example of
Although described with respect to a column name in
Although an auto-completion feature is described with respect to entering a reference in a formula in the given examples, in various embodiments, the auto-completion feature may be available and can similarly be employed when entering names or references in any other context such as, for example, when specifying source data when creating a chart or graph. Although described with respect to table objects, such an auto-completion feature may be similarly employed with respect to the names of other types of objects or parts thereof that are included in a sheet of a spreadsheet application, such as charts, graphs shapes, images, graphics, multimedia content, etc.
In some embodiments, a formula may be entered into a header cell to populate the body cells of a corresponding row or column.
Formulas may be entered into different types of spreadsheet cells such as header cells, body cells, and footer cells. When in a formula editing mode in a host cell, references to one or more cells or cell ranges that are clicked on or otherwise selected while in the formula editing mode are inserted into the formula being entered into the host cell. As disclosed herein, in some embodiments, references to one or more cells or cell ranges that are clicked on or otherwise selected are added to a formula being entered into a host cell based on the zones (e.g., within an associated table) or types of the clicked cell(s) and/or the host cell. For example, in some embodiments, while in a formula editing mode in a header row cell associated with a column of a table, clicking on or otherwise selecting a cell that is in a different column results in the insertion of a reference to the header row cell associated with the selected cell in the formula of the host cell. Likewise, in some embodiments, while in a formula editing mode in a header column cell associated with a row of a table, clicking on or otherwise selecting a cell that is in a different row results in the insertion of a reference to the header column cell associated with the selected cell in the formula of the host cell. In some embodiments, a spreadsheet application can be configured such that clicking on or otherwise selecting one or more non-header cells while in a formula editing mode in a header cell results in the insertion of a reference to the selected cell(s) (e.g., rather than a reference to an associated row or column) in the formula being entered into the host cell. In some embodiments, when entering a formula into a body or footer cell, clicking on or otherwise selecting one or more other body and/or footer cells results in references to those cells being inserted into the formula being entered into the host cell but clicking on or otherwise selecting a header cell results in a reference to the entire row or column associated with the header cell to be inserted into the formula. In some such cases, the reference to the entire row or column includes only the body cells of the row or column.
Address tabs may be available and/or displayed with a table. In some embodiments, clicking on or otherwise selecting one or more address tabs while in a formula editing mode results in reference adding behavior similar to that described above with respect to header cells. For example, in some embodiments, while in a formula editing mode in a header row cell of a column of a table, clicking on or otherwise selecting an address tab of another column results in the insertion of a (header cell or address tab value) reference to the selected column into the formula being entered into the host cell. Likewise, in some embodiments, while in a formula editing mode in a header column cell of a row of a table, clicking on or otherwise selecting an address tab of another row results in the insertion of a (header cell or address tab value) reference to the selected row into the formula being entered into the host cell. In some embodiments, while in a formula editing mode in a body or footer cell, clicking on or otherwise selecting an address tab results in the insertion into the formula of the host cell of a (header cell or address tab value) reference to the row or column associated with the address tab. In some such cases, the reference to the row or column includes only the body cells of the row or column. In some embodiments, when not in a formula editing mode, clicking on or otherwise selecting an address tab results in the selection of an entire associated column or row, including the body cells, header cell, and/or footer cell associated with the column or row.
Although the foregoing embodiments have been described in some detail for purposes of clarity of understanding, the invention is not limited to the details provided. There are many alternative ways of implementing the invention. The disclosed embodiments are illustrative and not restrictive.
Claims
1. A method for referring to cells of a table, comprising:
- receiving a header cell value for a header cell; and
- enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell.
2. A method as recited in claim 1, further comprising receiving an indication to include one or more of a header column and a header row in the table.
3. A method as recited in claim 1, wherein the header cell comprises a header row cell.
4. A method as recited in claim 3, wherein enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises enabling the header row cell value to be used to refer to one or more other cells included in a corresponding column.
5. A method as recited in claim 1, wherein the header cell comprises a header column cell.
6. A method as recited in claim 5, wherein enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises enabling the header column cell value to be used to refer to one or more other cells included in a corresponding row.
7. A method as recited in claim 1, wherein receiving a header cell value for a header cell comprises receiving a plurality of header cell values including the header cell value for a plurality of corresponding header cells.
8. A method as recited in claim 1, further comprising enabling a header row cell value associated with a column and a header column cell value associated with a row to be used to refer to a cell that is the intersection of the column and row.
9. A method as recited in claim 8, wherein a syntax of a reference to the cell comprises the header row cell value and the header column cell value separated by a space.
10. A method as recited in claim 9, wherein the syntax further comprises one or more of a document name, a sheet name, and a table name associated with the cell.
11. A method as recited in claim 1, further comprising enabling the header cell value to be used in combination with one or more address tab values to refer to one or more cells.
12. A method as recited in claim 1, further comprising providing options to hide or show one or more dimensions of address tabs with respect to the table.
13. A method as recited in claim 1, further comprising receiving a reference in a formula comprising the header cell value.
14. A method as recited in claim 1, wherein when used to refer to a corresponding column or row, the header cell value refers to only associated body cells and excludes the header cell, an associated footer cell, or both.
15. A method as recited in claim 14, wherein the associated footer cell is included in a footer row optionally included in the table.
16. A method as recited in claim 1, further comprising providing options to include or hide one or more of a header row, a header column, and a footer row in the table.
17. A method as recited in claim 1, further comprising enabling one or more cells to be referred to using one or more of a document name, a sheet name, a table name, and the header cell value.
18. A method as recited in claim 1, further comprising receiving an indication that a formula has been entered into the header cell.
19. A method as recited in claim 18, wherein the formula entered into the header cell includes a reference to another header cell of a same dimension.
20. A method as recited in claim 18, further comprising using the formula entered into the header cell to populate a corresponding column or row of cells.
21. A method as recited in claim 20, wherein using the formula entered into the header cell to populate a corresponding column of cells comprises excluding an associated footer cell, if any, from being populated.
22. A method as recited in claim 1, wherein the table is included in a sheet of a spreadsheet application.
23. A method as recited in claim 1, wherein the table comprises a sheet of a spreadsheet application.
24. A system for referring to cells of a table, comprising:
- a processor configured to: receive a header cell value for a header cell; and enable the header cell value to be used to refer to one or more other cells that are associated with the header cell; and
- a memory coupled to the processor and configured to provide instructions to the processor.
25. A system as recited in claim 24, wherein the header cell comprises a header row cell.
26. A system as recited in claim 25, wherein to enable the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises to enable the header row cell value to be used to refer to one or more other cells included in a corresponding column.
27. A system as recited in claim 24, wherein the header cell comprises a header column cell.
28. A system as recited in claim 27, wherein to enable the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises to enable the header column cell value to be used to refer to one or more other cells included in a corresponding row.
29. A system as recited in claim 24, wherein when used to refer to a corresponding column or row, the header cell value refers to only associated body cells and excludes the header cell, an associated footer cell, or both.
30. A system as recited in claim 24, wherein the processor is further configured to receive an indication that a formula has been entered into the header cell.
31. A system as recited in claim 30, wherein the processor is further configured to use the formula entered into the header cell to populate a corresponding column or row of cells.
32. A computer program product for referring to cells of a table, the computer program product being embodied in a computer readable medium and comprising computer instructions for:
- receiving a header cell value for a header cell; and
- enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell.
33. A computer program product as recited in claim 32, further comprising computer instructions for receiving an indication to include one or more of a header column and a header row in the table.
34. A computer program product as recited in claim 32, wherein the header cell comprises a header row cell.
35. A computer program product as recited in claim 34, wherein enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises enabling the header row cell value to be used to refer to one or more other cells included in a corresponding column.
36. A computer program product as recited in claim 32, wherein the header cell comprises a header column cell.
37. A computer program product as recited in claim 36, wherein enabling the header cell value to be used to refer to one or more other cells that are associated with the header cell comprises enabling the header column cell value to be used to refer to one or more other cells included in a corresponding row.
38. A computer program product as recited in claim 32, wherein receiving a header cell value for a header cell comprises receiving a plurality of header cell values including the header cell value for a plurality of corresponding header cells.
39. A computer program product as recited in claim 32, further comprising computer instructions for enabling a header row cell value associated with a column and a header column cell value associated with a row to be used to refer to a cell that is the intersection of the column and row.
40. A computer program product as recited in claim 32, wherein when used to refer to a corresponding column or row, the header cell value refers to only associated body cells and excludes the header cell, an associated footer cell, or both.
41. A computer program product as recited in claim 32, further comprising computer instructions for receiving an indication that a formula has been entered into the header cell.
42. A computer program product as recited in claim 41, further comprising computer instructions for using the formula entered into the header cell to populate a corresponding column or row of cells.
Type: Application
Filed: Aug 6, 2007
Publication Date: Feb 12, 2009
Applicant:
Inventors: Yaniv Gur (Pittsburgh, PA), Jay Christopher Capela (Santa Cruz, CA), Peter William Rapp (Pittsburgh, PA), Roger Rock Rosner (Mountain View, CA), Christopher Douglas Weeldreyer (San Carlos, CA)
Application Number: 11/890,785