ITabOptions.AutoUpdateCellsText

Syntax

AutoUpdateCellsText: Boolean;

AutoUpdateCellsText: System.Boolean;

Description

The AutoUpdateCellsText property determines automatic update of cells to correctly display multiple selection of dictionary and group of elements in the cell.

Comments

Available values:

The property is used to display multiple selection of dictionary elements in regular report cell, if group of elements is additionally set in dictionary contents and selection. Multiple selection of dictionary elements is displayed in the cell using the Dictionary drop-down list type of values.

The group of elements can be set from another dictionary using cell editor enumeration in the following format can be defined:

GROUP="@<key of group of elements>"

Example

Executing this example assumes that the repository contains a regular report with the identifier REPORT. The report contains analytical data area where the cell is displayed as drop-down list. The dropd-own list provides multiple selection of dictionary elements and the group of elements of another dictionary specified in cell editor and in the value editor settings.

Add links to the Metabase, Report, Tab system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Tab: ITabSheet;
    Opt: ITabOptions;
Begin
    // Get current repository
    Mb := MetabaseClass.Active;
    // Get regular report
    Report := Mb.ItemById("REPORT").Edit As IPrxReport;
    // Get table of active report sheet
    Tab := (Report.ActiveSheet As IPrxTable).TabSheet;
    // Enable automatic cell update
    Opt := Tab.Options;
    Opt.AutoUpdateCellsText := True;
    // Save changes
    (Report As IMetabaseObject).Save;
End Sub UserProc;

Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Report;
Imports Prognoz.Platform.Interop.Tab;
…
Public Shared Sub Main(Params: StartParams);
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Tab: ITabSheet;
    Opt: ITabOptions;
Begin
    // Get current repository
    Mb := Params.Metabase;
    // Get regular report
    Report := Mb.ItemById["REPORT"].Edit() As IPrxReport;
    // Get table of active report sheet
    Tab := (Report.ActiveSheet As IPrxTable).TabSheet;
    // Enable automatic cell update
    Opt := Tab.Options;
    Opt.AutoUpdateCellsText := True;
    // Save changes
    (Report As IMetabaseObject).Save();
End Sub;

After executing the example there will be an automatic update of regular report cells for correct display of dictionary elements multiple selection and of group of elements of another dictionary dictionary group of elements in the cell on selecting elements from the drop-down list.

See also:

ITabOptions