GridFormats (Object)

Member of:

DefaultFormats object

Description:

Represents a collection of the individual CellFormat objects for the Pivot and OLAPQuery (both CubeQuery and OLAPQuery) sections. Setting the properties for this individual CellFormat objects corresponds to setting the same properties in the Default Formats dialog box. Default formats are applied to the new sections of the current Interactive Reporting document (BQY) and new documents.

Example:

This example shows how to set the default format for data values in a Pivot section to red, sets the border style to 3–D raised, and sets the font size to 12:

DefaultFormats.Pivot.DataValues.BorderColor = bqDefaultFormatsRed
DefaultFormats.Pivot.DataValues.BorderStyle = bqBorderStyle_Raise1
DefaultFormats.Pivot.DataValues.Font.Size = 12

Objects:

CellFormat object