TTokenStructuredReference Class
A reference for a cell in a table. For example the reference in the formula =SUM(Table1[[#All],[SomeColumn]])
Syntax
Namespace: FlexCel.Core
public class TTokenStructuredReference: TTokenConstructors
| Name | Description |
|---|---|
| TTokenStructured​Reference | Creates a new Structured Reference argument token. |
Properties
| Name | Description |
|---|---|
| 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. |
| Sections | The sections of the table where this reference applies. |
| SpaceAfterBrackets | If true, the text of the structure reference will include a space after the brackets which define the arguments. |
| SpaceAfterComma | If true, the text of the structured reference arguments will include a space after every comma separating arguments. |
| TableName | Table that used by this reference. |
| 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. |