Show contents 

Express > Express Assembly Interfaces > IEaxGridViewSettings > IEaxGridViewSettings.UseStyleFormatting

IEaxGridViewSettings.UseStyleFormatting

Syntax

UseStyleFormatting: Boolean;

Description

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

Comments

Available values:

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 with formulas.

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

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

After executing the example the data table will use formatting of the current sheet, formulas will be used in table.

See also:

IEaxGridViewSettings