SetFormula Method (ThresholdConditionBase)

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

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

Parameters

formula

The string representation of the formula.

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.

Note: the formula should return a boolean result. When the formula is applied to cells in the region if the formula returns false then those cells will not be included in the formatting.

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

Reference

ThresholdConditionBase Class
ThresholdConditionBase Members
Formula Property