Spread Windows Forms 16
Spread Windows Forms 16.0 Product Documentation / Spread Designer Guide / Spread Designer Dialogs / Insert Function Dialog
In This Topic
    Insert Function Dialog
    In This Topic

    The Insert Function dialog can be used to insert the proper formula and arguments for your requirements.

    The Insert Function dialog helps the user to:

    Call Insert Function Dialog

    Let's say, you want to add the values in cell A2 and A3, and insert the sum of these values in A4. To open the Insert Function dialog and use the SUM function in cell A4, follow the steps below:

    1. Select the cell in which you want to insert the function, here cell A4.

    2. Navigate to the Insert Function option in the Functions Library group from the Formulas tab of the Spread ribbon.

    3. Click Insert Function option, and add the function using the Insert Function dialog. Select the SUM function and click OK to view the Function Arguments dialog. Use this dialog to add arguments in function.

    4. Click OK to close the Function Arguments dialog, and view the final result in cell A4:

    Using Table Totals formula

    You can also invoke the Insert Function dialog while using More Function option in Totals formula in a table:

    Keyboard Shortcut

    The keyboard shortcut for Insert Function dialog is Shift + F3.

    Note: To use keyboard shortcut, set the ExcelCompatibleKeyboardShortcuts to True from the Properties window in the Spread designer.