ITabView.ShowFormulaWizard

Fore Syntax

ShowFormulaWizard(Wnd: IWin32Window; Range: ITabRange);

Fore.NET Syntax

ShowFormulaWizard(Wnd: IWin32Window; Range: ITabRange);

Parameters

Wnd. The window according to which the formula wizard opens.

Range. A table cell or cell range, for which the formula wizard window opens.

Description

The ShowFormulaWizard method calls the formula wizard dialog box for a cell range.

Comments

The window of formula wizard is modal.

Fore Example

To execute the example a form with a button named Button1 on it, the TabSheetBox component named TabSheetBox1, and a data source for TabSheetBox1 are required. Add a link to the Tab system assembly.

The example is a handler of the Button1OnClick event for the Button1 button.

    Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
    Var Sheet: ITabSheet;
         View: ITabView;
        Range: ITabRange;
    Begin
        Sheet := TabSheetBox1.Source.GetTabSheet;
        View := Sheet.View;
        View.ShowFormulaWizard(Self As IWin32Window, Range);
    End Sub Button1OnClick;

After executing the example, clicking the button opens the formula wizard window.

Fore.NET Example

To execute the example a form with a button named Button1 on it, the TabSheetBox component named TabSheetBox1, and a data source for TabSheetBox1 are required.

As IWin32Window is used differently in Fore.NET, than in Fore, use IWin32WindowForeAdapter.

The example is a handler of the Click event for the button1 button.

Imports Prognoz.Platform.Interop.Tab;

...

    Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
    Var Sheet: ITabSheet;
        View: ITabView;
        Range: ITabRange;
    Begin
        Sheet := tabSheetBoxNet1.Source.GetTabSheet() As ITabSheet;
        View := Sheet.View;
        View.ShowFormulaWizard(New IWin32WindowForeAdapter(Self), Range);
    End Sub;

After executing the example the formula wizard window opens.