Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Customizing Sheet Interaction / Customizing Interaction with a Sheet / Creating Tables / Understanding Structured References / Understanding Structured Reference Syntax Rules
In This Topic
    Understanding Structured Reference Syntax Rules
    In This Topic

    Structured references have additional syntax rules listed as follows:

    All table, column, and special item specifiers must be enclosed in matching brackets ([ ]). A specifier that contains other specifiers requires outer matching brackets to enclose the inner matching brackets of the other specifiers, for example:

    =DeptSales[[SalesPerson]:[Region]]

    All column headers are text strings, but do not require quotes when they are used in a structured reference. If a column header contains numbers or dates, such as 2004 or 1/1/2004, these are still considered text strings. Because column headers are text strings, you cannot use expressions within brackets, for example:

    =DeptSalesFYSummary[[2004]:[2002]]

    If a table column header contains one of the following special characters, the entire column header must be enclosed in brackets. This means double brackets are required in a column specifier with the following special characters: space, tab, line feed, carriage return, comma (,), colon (:), period (.), left bracket ([) , right bracket (]), pound sign (#), single quotation mark ('), double quotation mark ("), left brace ({), right brace (}), dollar sign ($), caret (^), ampersand (&), asterisk (*), plus sign (+), equal sign (=), minus sign (-), greater than symbol (>), less than symbol (<), and division sign (/).

    The following structured reference includes a column specifier that contains special characters:

    =DeptSalesFYSummary[[Total$Amount]]

    The only exception to this is if the only special character that is used is a space character, for example:

    =DeptSales[Total Amount]

    The following characters have special meaning and require the use of a single quotation mark (') as an escape character: left bracket ([), right bracket (]), pound sign(#), and single quotation mark (').

    The following example illustrates a structured reference that contains a character with a special meaning:

    =DeptSalesFYSummary['#OfItems]

    You can use space characters to improve the readability of a structured reference. You can use one space after the first left bracket ([) and preceding the last right bracket (]). You can also use one space after a comma, as shown in the following examples:

    =DeptSales[ [SalesPerson]:[Region] ]

    =DeptSales[[#Headers], [#Data], [ComPct]]