Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Developer's Guide / Managing Formulas / Nesting Functions in a Formula
In This Topic
    Nesting Functions in a Formula
    In This Topic

    You can nest a function within another function in a formula.

    For more information about formulas, refer to the Formula Reference.

    Using Code

    1. Specify the cell type.
    2. Use a function within another function in a formula

    Example

    In this example the sum of the value in two cells (found by using the SUM function) is embedded in a PRODUCT formula. First the cell types are set and the values of the cells are set.

    C#
    Copy Code
    FarPoint.Web.Spread.DoubleCellType ncell = new FarPoint.Web.Spread.DoubleCellType();
    FpSpread1.Sheets[0].Cells[0, 0, 2, 0].CellType = ncell;
    FpSpread1.Sheets[0].Cells[0, 0, 2, 0].Value = 2;
    FpSpread1.Sheets[0].Cells[3, 1].Formula = "PRODUCT(A1, SUM(A2,A3))";
    
    VB
    Copy Code
    Dim ncell As New FarPoint.Web.Spread.DoubleCellType
    FpSpread1.Sheets(0).Cells(0, 0, 2, 0).CellType = ncell
    FpSpread1.Sheets(0).Cells(0, 0, 2, 0).Value = 2
    FpSpread1.Sheets(0).Cells(3, 1).Formula = "PRODUCT(A1, SUM(A2,A3))"
    
    See Also