Table of Contents

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: TToken

Constructors

Name Description
TTokenStructured​Reference 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.