ITabOptions.EnableEmptyValuesTreatment

Fore Syntax

EnableEmptyValuesTreatment: Boolean;

Fore.NET Syntax

EnableEmptyValuesTreatment: boolean;

Description

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

Comments

The property is outdated, use the ITabErrorCheckingOptions.EnableChecking property instead.

Available values:

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

Errors are checked if the formula refers to an empty cell. The cell with formula contains an indicator which looks as a colored triangle located at the left top corner, and the empty value is replaced with 0.

Fore Example

To execute the example a form, a button on this form named Button1, the TabSheetBox component named TabSheetBox1, and the UiTabSheet component named UiTabSheet1 which is a data source for TabSheetBox1 are required.

The procedure is the OnClick event handler for the Button1 button. This example is executed on clicking the button.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Tab: ITabSheet;
    Options: ITabOptions;
Begin
    Tab := UiTabSheet1.TabSheet;
    Options := Tab.Options;
    Options.EnableEmptyValuesTreatment := False;
    Tab.Recalc;
End Sub Button1OnClick;

After executing the example the Error Checking option is disabled.

Fore.NET Example

The requirements and result of the Fore.NET Example execution match with those in the Fore Example. Use Fore.NET analogs instead of Fore components.

Imports Prognoz.Platform.Interop.Tab;
…
Public Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Tab: ITabSheet;
    Options: ITabOptions;
Begin
    Tab := UiTabSheetNet1.TabSheetUi.TabSheet;
    Options := Tab.Options;
    Options.EnableEmptyValuesTreatment := False;
    Tab.Recalc();
End Sub;