CellFormula Property

Gets or sets a formula of the Cell.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (20.2)
public string Formula { get; set; }

Property Value

Type: String
A formula string always begins with an equal sign (=). And please always use comma(,) as parameters delimeter, such as "=SUM(A1, E1, H2)".

User can set any formula in Workbook designer file. Aspose.Cells will keep all the formulas. If user use this property to set a formula to a cell, major part of Workbook built-in functions is supported. And more is coming. If you have any special need for Workbook built-in functions, please let us know.


Workbook excel = new Workbook();
Cells cells = excel.Worksheets[0];
cells["B6"].Formula = "=SUM(B2:B5, E1) + sheet1!A1";

[Visual Basic]

Dim excel As Workbook =  New Workbook() 
Dim cells As Cells =  excel.Worksheets(0) 
cells("B6").Formula = "=SUM(B2:B5, E1) + sheet1!A1"
See Also