CellFormat (Object)

Member of:

GridFormat object

Description:

Represents an individual CellFormat object (data value, label) in the Pivot and OLAPQuery (both CubeQuery and OLAPQuery) sections. Setting properties for an CellFomat object corresponds to setting the properties for a data value, font or label on the Default Formats dialog box. Default format are applied to the new sections of the current Interactive Reporting document (BQY) and new documents.

Example:

This example shows hot to set the background color for a Pivot section label to blue, and set the border style for the labels to horizontal.

DefaultFormats.Pivot.Labels.BackgroundColor = bqDefaultFormatsBlue
DefaultFormats.Pivot.Labels.BorderStyle = bqBorderStyle_Horizontal

Properties:

BackgroundColor as BqDefaultFormatsColor, BorderColor as BqDefaultFormatsColor, BorderStyle as BqBorderStyle, HorizontalAlignment as BqHorizonAlignment, VerticalAlignment as BqVerticalAlignment

Objects:

Font as Font