ITabRange.ToDoubleArray

Fore Syntax

ToDoubleArray([SkipNonDoubles: Boolean = false]): Array;

Fore.NET Syntax

ToDoubleArray(SkipNonDoubles: boolean): System.Array;

Parameters

SkipNonDoubles. Indicates whether non-integer values must be skipped.

Description

The ToDoubleArray method converts a range into a float array.

Comments

The SkipNonDoubles parameter determines the rule of non-real range values skipping. Available values:

True. Non-real value will be skipped.
False. Default value. The item with non-real value is replaced to 0 in the array.

If the ITabErrorCheckingOptions.EnableChecking property is set to True, on calling the ToDoubleArray method all options of ITabSheet.ErrorCheckingOptions are taken into account.

Fore Example

To execute the example a form that contains the Button component with the Button1 identifier, the TabSheetBox component with the TabSheetBox1 identifier and the UiTabSheet component with the UiTabSheet1 identifier are required. Set the UiTabSheet1 component as a data source for the TabSheetBox1 component.

The example is a handler of the OnClick event for the Button1 component.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    TSheet: ITabSheet;
    TRange: ITabRange;
    Arr: Array Of Double;
Begin
    TSheet := UiTabSheet1.TabSheet;
    TRange := TSheet.View.Selection.Range;
    Arr := TRange.ToDoubleArray(True);
    // Get array length
    Debug.WriteLine("Array length: " + Arr.Length.ToString);
End Sub Button1OnClick;

Clicking the button creates the Arr real array where values of the selected table range are placed. Non-real values will be ignored. The console displays message about the Arr array length.

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;
…
Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    TSheet: ITabSheet;
    TRange: ITabRange;
    Arr: Array Of Double;
Begin
    TSheet := UiTabSheetNet1.TabSheetUi.TabSheet;
    TRange := TSheet.View.Selection.Range;
    Arr := TRange.ToDoubleArray(True) As Array Of Double;
    // Get array length
    System.Diagnostics.Debug.WriteLine("Array length: " + Arr.Length.ToString());
End Sub;