SetFormula(String,CellReferenceMode) Method

Sets the formula for a named reference.

Syntax

public void SetFormula( 
   string formula,
   CellReferenceMode cellReferenceMode
)

formula: The string containing the formula value.
cellReferenceMode: The mode used to interpret cell references in the formula.

Exceptions

Exception	Description
System.ArgumentNullException	formula is null or empty.
System.ComponentModel.InvalidEnumArgumentException	cellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ArgumentException	formula is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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