Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Cell Class / Formula Property


In This Topic
    Formula Property
    In This Topic

    Gets or sets the Cell's formula.

    Syntax
    'Declaration
 

    Public Property Formula As String
    'Usage
 

    Dim instance As Cell
Dim value As String
 
instance.Formula = value
 
value = instance.Formula
    public string Formula {get; set;}
    Remarks

    A formula always starts with the equal sign (“=”) and uses comma (“,”) as parameter separators; for example: “=SUM(A1, A2, A4)”.

    A formula can include constant (“=A1 + 5*4%”), references (“=A1*A3”), ranges of references (“=SUM(A1:A3, B1:B3)”) or functions (“=SUM(A1:A3) + AVERAGE(B1:B3)”).

    Note that each function have their own characteristics and that you should refer to their specific pages for more information.

    The formula will be calculated once the Workbook is opened with MS Excel and the Value property will be updated once the Workbook is saved with MS Excel.

    The formula can also be calculated by using Worksheet.CalculateFormulas() since this call will automatically set the Value property.

    The default value is null, which means that the Cell will not contain a formula.

    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    Cell Class
    Cell Members

    Send Feedback