SetFormula(String,CellReferenceMode,CultureInfo) Method

Sets the formula for a named reference.

Syntax

public void SetFormula( 
   string formula,
   CellReferenceMode cellReferenceMode,
   CultureInfo culture
)

formula: The string containing the formula value.
cellReferenceMode: The mode used to interpret cell references in the formula.
culture: The culture used to parse 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+