CalculatedColumnFormula Property

Office Open XML

Sets a calculated column Formula. Be carefull with this property since it is not validated.

Examples

tbl.Columns[9].CalculatedColumnFormula = string.Format("SUM(MyDataTable[[#This Row],[{0}]])",tbl.Columns[9].Name);

Namespace:  OfficeOpenXml.Table
Assembly:  EPPlus (in EPPlus.dll) Version: 3.0.0.1 (3.0.0.1)

Syntax

C#
public string CalculatedColumnFormula { get; set; }
Visual Basic (Declaration)
Public Property CalculatedColumnFormula As String
Visual C++
public:
property String^ CalculatedColumnFormula {
	String^ get ();
	void set (String^ value);
}

See Also