SetFormula Method (ConditionValue)

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

Syntax

Visual Basic

'Declaration
 
Public Sub SetFormula( _
   ByVal formula As String, _
   Optional ByVal cellReferenceMode As Nullable(Of CellReferenceMode), _
   Optional ByVal valueType As FormatConditionValueType _
) 

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: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2