SetFormula Method (ConditionValue)

Assigns the specified formula to the Formula property, and assigns a value of Formula to the ValueType property.

Syntax

C#

public void SetFormula( 
   string formula,
   Nullable<CellReferenceMode> cellReferenceMode,
   FormatConditionValueType valueType
)

Parameters

formula

The string representation of the Formula to be assigned to the Value property.

cellReferenceMode

A Infragistics.Documents.Excel.CellReferenceMode value which specifies whether the formula parameter should be interpreted as an A1 or R1C1 expression. This parameter is optional and defaults to null, in which case the CellReferenceMode property is used.

valueType

A FormatConditionValueType value which specifies the manner in which the value returned from the formula is interpreted. This parameter is optional and defaults to '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+