IPrxReportOptions.EnableEmptyValuesTreatment

Fore Syntax

EnableEmptyValuesTreatment: Boolean;

Fore.NET Syntax

EnableEmptyValuesTreatment: boolean;

Description

The EnableEmptyValuesTreatment property determines whether error checking is used for formulas with links to empty cells.

Comments

The property is outdated, use IPrxReportOptions.EnableErrorChecking.

Available values:

True. Default value. Errors are checked.
False. Errors are not checked.

Errors are checked if the formula refers to to an empty cell. In a cell with formula the indicator as a colored triangle in the top left corner appears, and empty value is replaced with zero.

The operation, which must be executed on checking, can be changed only via the interface in the Formulas dialog box.

After the property is changed, calculate a report.

Fore Example

To execute the example, add links to the Metabase, Tab and Report system assemblies. The repository must contain a regular report with the Report identifier.

Sub UserProc;
Var
    MB: IMetabase;
    Report: IPrxReport;
    Tab: ITabSheet;
    Opt: ITabOptions;
    Options: IPrxReportOptions;
Begin
    MB := MetabaseClass.Active;
    Report := MB.ItemById("Report").Edit As IPrxReport;
    Tab := Report.ActiveSheet.Table;
    Opt := Tab.Options;
    Options := Report.Options;
    Options.EnableEmptyValuesTreatment := True;
    Debug.WriteLine("Error checking:");
    Debug.WriteLine(Opt.EmptyValuesTreatmentType);
    Report.Recalc;
    Report.MetabaseObject.Save;
End Sub UserProc;

After executing the example the regular report with the Report identifier has the Error Checking option enabled. The console window displays the information about action on error checking.

Fore.NET Example

To execute the example, add links to the Metabase, Tab and Report system assemblies. The report must contain the regular report with the Report identifier.

Sub UserProc;
Var
    MB: IMetabase;
    Report: IPrxReport;
    Tab: ITabSheet;
    Opt: ITabOptions;
    Options: IPrxReportOptions;
Begin
    MB := Params.Metabase;
    Report := MB.ItemById["Report"].Edit() As IPrxReport;
    Tab := Report.ActiveSheet.Table;
    Opt := Tab.Options;
    Options := Report.Options;
    Options.EnableEmptyValuesTreatment := True;
    Debug.WriteLine("Error checking:");
    Debug.WriteLine(Opt.EmptyValuesTreatmentType);
    Report.Recalc();
    Report.MetabaseObject.Save();
End Sub;

After executing the example the regular report with the Report identifier has the Error Checking option enabled. The console window displays the information about action on error checking.