CellAlignment

New to Analytica 5.0

CellAlignment( horiz, indent, vert, vertIndent, wrap, hybridFlags )

Specifies the text alignment (justification) or indention for a cell in a table. This is used from within a Cell Format Expression attribute, see Computed cell formats for an overview of using computed formats.

Parameters:

• «horiz»: The horizontal alignment. One of: 'Left', 'Center', 'Right', 'Default'or 'Hybrid'.
• «indent»: An indention amount, in units equal to the width of one space character. For 'Left' alignment, this is a margin to the left of the text, for 'Right' it is a margin to the right of the text, and for 'Center' it is a margin on both sides.
• «vert»: The vertical alignment. One of 'Top', 'Middle', 'Bottom' or 'Default'.
• «vertIndent»: Vertical margin in pixel units. For 'Top', this is a margin above the text, for 'Bottom' it is a margin below the text, and for 'Middle' it is a margin on both sides.
• «wrap»: (new to Analytica 6.4) Specifies whether long text should be word-wrapped (the default starting in Analytica 6.4).
• «hybridFlags»: (new to Analytica 6.4) A bit field that is only used when you set «horiz» to 'Hybrid'. The cell content types set here are right-justified, those not set are left-justified. The bits are:

  1 = Numbers

  2 = Dates and times

  4 = Single-line text

  8 = Multi-line text

  16 = Nulls

  32 = Handles

  1024 = Other

The «horiz» and «vert» parameters also accept 'Justify', 'Fill', and 'Distributed'. However, these modes are not honored -- instead it just maps to the most appropriate justification among the stated options. When reading cell justifications in an excel spreadsheet, these values are possible (e.g., from SpreadsheetCell with «what» set to 'HorizontalAlignment' or 'VerticalAlignment').

When «horiz» is 'Default' it right or left aligns cell content based on the data type displayed in the cell, and whether it is single or multiline content In Analytica 6.4, the system variable Sys_CellAlignmentHybridDefault determines this mapping globally (and can be changed). When «horiz» is set to 'Hybrid' it also right or left justifies cell content based on the data type, but uses the «hybridFlags» parameter to determine which types should be right aligned.

Examples

These would appear in the Cell Format Expression attribute.

CellAlignment( 'Center' )

CellAlignment( If IsNumber(Self) Then 'Right' Else 'Left' )

The previous example can also be accomplished using

CellAlignment( 'Hybrid', hybridFlags:1 )

CellSpan( LineItem, CellAlignment(vert:'Middle'), header:true )

In the next example, there is an index named Place, and a variable Place_level indexed by Place, with a 0 for each state, a 1 for each county, and a 2 for each city.

CellSpan(Place, CellAlignment(indent:Place_level*3), header:true)

:

See Also

• Computed cell formats
• CellFormats
• CellSpan
• Other cell format predicates: CellFont, CellBorder, CellBar, CellFill, CellNumberFormat, CellOnClick, CellEntry