AX1514

Applying formatting to Formatted Grids

By default, Formatted Grid components are set up to use thematic formatting—meaning that grid contents are formatted by applying row and column styles. Thematic grid formatting is determined by the following elements:

  • The style used by the Formatted Grid component. This style is set in the component properties, and only affects the grid "container-level" formatting, such as an external border. It does not affect the formatting of the grid contents.

  • The row and column styles defined in the Grid data source. Each row and column can be flagged with different styles to set the formatting as appropriate for its contents. Styles can apply formats like bold font, borders, background colors, and more.

    NOTE: If your form uses a legacy skin (any skin other than the default Axiom2018 skin), then the grid formatting is also affected by the assigned theme. By default, this is inherited from the form-level theme, though it can be set at the component level if necessary. Different themes have different default formatting, and provide access to different row and column styles. For example, the form theme may be set to Report to support display of data, or to Worksheet to support user inputs. Themes do not apply when using the Axiom2018 skin, because that skin uses a different set of styles that are designed to accommodate all of the display variations that used to require themes.

Formatted grids created in older versions of the software may use a deprecated format, known as spreadsheet-formatted grids. Spreadsheet-formatted grids read the formatting defined in the spreadsheet instead of using row and column styles. If you are working with older grids that use this format, see Using spreadsheet formatting with Formatted Grids (deprecated).