ITabCellStyle.DisplayEmptyAs

Fore Syntax

DisplayEmptyAs: String;

Fore.NET Syntax

DisplayEmptyAs: string;

Description

The DisplayEmptyAs property specifies text defined for the cells with missing values.

Example

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

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    TSheet: ITabSheet;
    TRange: ITabRange;
    Style: ITabCellStyle;
Begin
    TSheet:= UiTabSheet1.TabSheet;
    TRange:= TSheet.View.Selection.Range;
    Style:= TRange.Style;
    Style.DisplayEmptyAs:= "Empty";
End Sub Button1OnClick;

On clicking the button the text Empty is displayed for the cells with missing values in the selected range.

Fore.NET Example

To execute the example a form, a button named Button1 on this form, TabSheetBoxNet component, and UiTabSheetNet component named UiTabSheetNet1 are required. The UiTabSheetNet1 is the data source for TabSheetBoxNet component.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Tab;
…
Private Sub button1_Click( sender: System.Object; e: System.EventArgs );
Var
    TSheet: ITabSheet;
    TRange: ITabRange;
    Style: ITabCellStyle;
Begin
    TSheet:= UiTabSheetNet1.TabSheetUi.TabSheet;
    TRange:= TSheet.View.Selection.Range;
    Style:= TRange.Style;
    Style.DisplayEmptyAs:= "Empty";
End Sub;

On clicking the button the text Empty is displayed for the cells with missing values in the selected range.