Spread supports structured reference formulas in tables. Components of the structured reference include the table name, column specifier, special item specifier, and the table specifier.
A table name is the name assigned to the table. The name references the table data, but not the header and totals rows, if any. A column specifier is derived from the column header and references the column data (excluding the column header and total, if any). Specifiers are enclosed in brackets. A special item specifier is a way to refer to specific portions of the table, such as the Totals row. The table specifier is the outer portion of the structured reference. Outer references follow the table name, and are enclosed in square brackets. A structured reference is the entire string beginning with the table name and ending with the column specifier.
The following topics provide additional information about structured references.