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 Name | The name of the font in which contents of the cell are displayed. |
| Font Size | The font size with which contents of the cell are displayed. |
| Text Color | The color in which the contents of the cell are displayed. |
| Horizontal Alignment | The horizontal alignment of the contents of the cell. 0. Left 1. Centered 2. Right 3. Justified |
| Vertical Alignment | The vertical alignment of the contents of the cell. 0. Top 1. Middle 2. Bottom |
| Bold | True if the contents of the cell shall be displayed in bold. |
| Italic | True if the contents of the cell shall be displayed in italic. |
| Underlined | True if the contents of the cell shall be displayed underlined. |
| Format | The 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 Wrap | True if the content of the cell can be wrapped. |
Background
Name |
Description |
|---|---|
| Pattern | The background pattern to apply to the cell. 0. None 1. Solid. |
| Color | The 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 Type | The border type to apply. 0. None 1. Single Solid 2.Single Dotted 3. Single Dashed 4. Double Solid |
| Border Width | The border width in pixels. |
| Border Color | The border color to apply. This property only applies if the Border Type is set to something other than None. |
Padding
Name |
Description |
|---|---|
| Padding | The 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 |
|---|---|
| CellValue | The value of the cell for which the style property is evaluated. |
| CellType | The 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 |
| ColumnNumber | The column number of the cell for which the style property is evaluated (the first column has column number 1). |
| IsCellValueNumeric | True if the value of the cell for which the style property is evaluated is numeric, otherwise False. |
| RowData | An 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). |
| RowNumber | The row number of the cell for which the style property is evaluated (the first row has row number 1). |
| TableData | A 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). |