Formula Property (WorksheetCell)

Gets the formula which has been applied to the cell.

Syntax

C#

public Formula Formula {get;}

Property Value

The formula which has been applied to the cell or null if no formula has been applied.

Remarks

If a formula has been applied to the cell, getting the Value will return the calculated value of the formula.

Note: it is slightly faster to use the WorksheetRow.GetCellFormula method, which does not create a WorksheetCell instance internally. However, if a reference to the WorksheetCell instance already exists, using this property is equivalent to using the WorksheetRow.GetCellFormula method.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+