Contents x
    Table Cell Styles
    • 13 Dec 2023
    • 2 Minutes to read
    • Dark
      Light
    Contents

    Table Cell Styles

    • Updated on 13 Dec 2023
    • 2 Minutes to read
    • Dark
      Light
    Article summary

    General

    This type of Style contains style properties that are applied to the cell of a table.

    Properties

    Every table cell style has the following style properties:

    Text

    Name

    		Description
    Font NameThe name of the font in which contents of the cell are displayed.
    Font SizeThe font size with which contents of the cell are displayed.
    Text ColorThe color in which the contents of the cell are displayed.
    Horizontal AlignmentThe horizontal alignment of the contents of the cell.

    0. Left
    1. Centered
    2. Right
    3. Justified
    Vertical AlignmentThe vertical alignment of the contents of the cell.

    0. Top
    1. Middle
    2. Bottom
    BoldTrue if the contents of the cell shall be displayed in bold.
    ItalicTrue if the contents of the cell shall be displayed in italic.
    UnderlinedTrue if the contents of the cell shall be displayed underlined.
    FormatThe Format String to use to format the content of the cell. This only applies to cells whose value is a number or a date-time.
    Text WrapTrue if the content of the cell can be wrapped.

    Background

    Name

    		Description
    PatternThe background pattern to apply to the cell.

    0. None
    1. Solid.
    ColorThe background color to apply to the cell. This property only applies if the background Pattern it set to something other than None.

    Borders

    Name

    		Description
    Border TypeThe border type to apply.

    0. None
    1. Single Solid
    2.Single Dotted
    3. Single Dashed
    4. Double Solid
    Border WidthThe border width in pixels.
    Border ColorThe border color to apply. This property only applies if the Border Type is set to something other than None.

    Padding

    Name

    		Description
    PaddingThe padding (the distance between the cell border and its contents) in pixels.

    Expression Parameters

    When a style property is set to an Expression, additional expression parameters which can be accessed using an Expression Paramneter Placeholder are available:

    Name

    		Description
    CellValueThe value of the cell for which the style property is evaluated.
    CellTypeThe Cell Type of the cell for which the style property is evaluated.

    0. DataTopHeader
    1. TotalsTopHeader
    2. SubTotalsTopHeader
    3. DataLeftHeader
    4. TotalsLeftHeader
    5. SubTotalsLeftHeader
    6. Data
    7. Total
    8. SubTotal.
    9. Filler
    ColumnNumberThe column number of the cell for which the style property is evaluated (the first column has column number 1).
    IsCellValueNumericTrue if the value of the cell for which the style property is evaluated is numeric, otherwise False.
    RowDataAn array that contains the values of all cells of the row to which the cell for which the style property is evaluated belongs (e.g. RowData(1) returns the value of the first cell of the row).
    RowNumberThe row number of the cell for which the style property is evaluated (the first row has row number 1).
    TableDataA two-dimensional array that contains the values of all cells of all rows of the table (e.g. TableData(1)(2) returns the value of the second column of the first row; TableData(8)(1) returns the value of the first column of the eighth row).
    Was this article helpful?
    What's Next