TTokenStructuredReference Class

A reference for a cell in a table. For example the reference in the formula =SUM(Table1[[#All],[SomeColumn]])

Syntax

Unit: FlexCel.Core

TTokenStructuredReference = class(TToken);

Constructors

Name	Description
Create	Creates a new Structured Reference argument token.

Properties

Name	Description
WorkbookName	Name of the file where the referenced table is. If this value is empty, then the table is in the same file as the reference.
TableName	Table that used by this reference.
Sections	The sections of the table where this reference applies.
FirstColumn	First column where the reference applies. Set it to empty if the reference applies to the whole table.
LastColumn	Last column where the reference applies. If empty and FirstColumn is empty too, then the reference applies to the whole table. If empty but FirstColumn is not empty, then this reference applies only to FirstColumn.
SpaceAfterComma	If true, the text of the structured reference arguments will include a space after every comma separating arguments.
SpaceAfterBrackets	If true, the text of the structure reference will include a space after the brackets which define the arguments.