Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / SetFormula Method
Example


In This Topic
    SetFormula Method (SheetView)
    In This Topic
    Sets a formula in a specified cell on this sheet.
    Overload List
    OverloadDescription
    Sets a formula in a specified cell on this sheet.  
    Remarks

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

    Example
    This example sets a formula in the specified cell.
    public class CubeFunctionInfo : FarPoint.CalcEngine.FunctionInfo
        {
          public override string Name { get { return "CUBE"; } }
          public override int MinArgs { get { return 1; } }
          public override int MaxArgs { get { return 1; } }
          public override object Evaluate (object[] args)
          {
            double num = FarPoint.CalcEngine.CalcConvert.ToDouble(args[0]);
            return num * num * num;
          }
        }
    
    fpSpread1.AddCustomFunction(new CubeFunctionInfo());
    fpSpread1.ActiveSheet.SetFormula(1, 1, "CUBE(4)");
    
    Public Class CubeFunctionInfo
       Inherits FarPoint.CalcEngine.FunctionInfo
    
       Public Overrides ReadOnly Property Name() As String
         Get
           Return "CUBE"
         End Get
       End Property
    
       Public Overrides ReadOnly Property MinArgs() As Integer
         Get
           Return 1
         End Get
       End Property
    
       Public Overrides ReadOnly Property MaxArgs() As Integer
         Get
           Return 1
         End Get
       End Property
    
       Public Overrides Function Evaluate(ByVal args() As Object) As Object
           Dim num As Double = FarPoint.CalcEngine.CalcConvert.ToDouble(args(0))
           Return num * num * num
       End Function
    End Class
    
    FpSpread1.ActiveSheet.AddCustomFunction(New CubeFunctionInfo)
    FpSpread1.ActiveSheet.SetFormula(0, 0, "CUBE(4)")
    
    fpSpread1.Sheets[0].SetFormula(0, 0, "SUM('C:\\Program Files (x86)\\GrapeCity\\[SumTest.xlsx]Sheet1'!A1:A4)");
    fpSpread1.AllowUserFormulas = true;
    FpSpread1.Sheets(0).SetFormula(0, 0, "SUM('C:\Program Files (x86)\GrapeCity\[SumTest.xlsx]Sheet1'!A1:A4)")
    FpSpread1.AllowUserFormulas = True
    See Also