Table 4.3.
Name | Description |
---|---|
cell(a,b) | In the contex of a matrix, returns the value at row a and column b. In the context of a table, returns the value at column a and row b (remember that tables use column logic). Everywhere else, this function is undefined. In the case of tables, the column is specified as a path string; see the documentation of column() for supported path formats. |
cell_(column, row) | In the context of a table, return the value of a cell specified using 1-based indices. Wherever possible, you should use cell() instead, because inserting/removing/moving columns will break formulas using cell_(). |
col(c) | DEPRECATED; use column() or cell() instead. Note that the user interface still uses col() until a proper language-specific mechanism is implemented. |
column("path") | In a column formula, returns the value in the given column and current row (i). The column path can either be the name of column in the current table, more generally a relative path to a column in another table (e.g. "../otherTable/col") or an absolute path (i.e., relative to the project root; e.g. "/folder/otherTable/col"). Searching for a table anywhere in the project using "otherTable/col" (without leading slash) is supported for backwards-compatibility reasons, but is strongly discouraged - a future release will drop the requirement of project-wide unique table names, at which point this usage will cease to be well-defined. |
column_(index) | In a column formula, returns the value in the column given by 1-based index and current row (i). You should use column() wherever possible, because inserting/ removing/moving columns will break formulas using column_(). |
if(e1,e2,e3) | if e1 is true, e2 is executed else e3 is executed. |
tablecol(t,c) | DEPRECATED; use column() instead. |