Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
[Root] / Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Cell Class / CalculateFormula Method
Example


In This Topic
    CalculateFormula Method
    In This Topic
    Starts the calculation process in order to get a value from the Cell's formula.
    Syntax
    'Declaration
 

    Public Sub CalculateFormula() 
    'Usage
 

    Dim instance As Cell
 
instance.CalculateFormula()
    public void CalculateFormula()
    Remarks
    The Value property will be updated with the result of the calculation once it is over.
    Example
    worksheet.Cells[ "E1" ].Formula = "=SUM(A1, B1, A2) * B2 + 4";

worksheet.Cells[ "E1" ].CalculateFormula();
var result = worksheet.Cells[ "E1"].Value;
    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