DefaultFormats (Object)

Member of:

Application object

Description:

Represents the collection of GridFormats objects. These objects set the default formats for data values, fonts and labels in the Pivot and OLAPQuery (both CubeQuery and OLAPQuery) sections.

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:

GridFormats object