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. |