Table Cell Styles
  • 18 Sep 2024
  • 2 Minutes to read
  • Dark
    Light

Table Cell Styles

  • 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 Parameter 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?