Formatting & Styling

Styling Column Headers

Summary

  • It is possible to style and format Column Headers
  • This can be done using a Condition if required

Format Column Styles and Display Formats can also be applied to Column Headers.

Caution

You cannot apply Conditional Styles to Column Headers (as there is only one value and nothing to evaluate)

This is done through the Target property of the FormatColumn object which can be either:

  • cell (the default) - applies the Format just to the Column's data cells
  • columnHeader - applies the Format only to the Column Header

Note

  • All Column Headers always only use a String Display Format (as the Column Header value is a string)
  • This applies also to Numeric and Date columns (whose cells use Number and Date Display Formats respectively)
Styling & Formatting Column Headers
Fork
  • This example contains 3 Format Column Styles which have been applied to Column Headers only:
    • All Columns are centre-aligned
    • Language Column is blue, capitalised and italicised
    • Numeric Columns have a distinctive background

Conditions

PreviousConfiguring FormattingNextTechnical Reference