ITabCellStyle.DisplayZeroAs

Fore Syntax

DisplayZeroAs: String;

Fore.NET Syntax

DisplayZeroAs: string;

Description

The DisplayZeroAs property specifies text defined for the cells with zero values.

Fore 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.DisplayZeroAs:= "Zero";
End Sub Button1OnClick;

On clicking the button the text Zero is displayed for those cells of selected range that contain zero values.

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. 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.DisplayZeroAs:= "Zero";
End Sub;

On clicking the button the text Zero is displayed for those cells of selected range that contain zero values.