IEaxGridViewSettings.UseStyleFormatting

Syntax

UseStyleFormatting: Boolean;

Description

The UseStyleFormatting property determines whether proper data table formatting is used.

Comments

Available values:

True. Default. Proper formatting will be used.
False. The current sheet formatting will be used.

The property is relevant if working with analytical data area is executed in a regular report.

Example

Executing the example requires that the repository contains a regular report with the REG_REPORT identifier. The report contains an analytical data area.

Add links to the Express, Metabase and Report system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Rep: IPrxReport;
    PivSlice: IEaxDataAreaSlice;
    Grid: IEaxGrid;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get regular report
    Rep := MB.ItemById("REG_REPORT").Edit As IPrxReport;
    // Get analytical data area slice
    PivSlice := Rep.DataArea.Slices.Item(0);
    // Use current sheet formatting
    Grid := PivSlice.Views.Item(0) As IEaxGrid;
    Grid.ViewSettings.UseStyleFormatting := False;
    // Save changes
    Rep.MetabaseObject.Save;
End Sub UserProc;

After executing the example data table will use current sheet formatting.