Version

SetFormula(String) Method

Sets the formula for a named reference.
Syntax
public void SetFormula( 
   string formula
)

Parameters

formula
The string containing the formula value.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionformula is null or empty.
System.ArgumentExceptionformula is not a valid formula. The inner exception will contain the FormulaParseException describing the reason the formula was not valid.
Remarks

The formula will be parsed using the CellReferenceMode of the Workbook to which the NamedReference is applied. If the NamedReference has been removed from its collection, the A1 reference mode will be used to parse the formula.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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

See Also