SetFormula Method (ThresholdConditionBase)

Assigns a new Infragistics.Documents.Excel.Formula to the Formula property.

Syntax

Visual Basic

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

C#

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.

Remarks

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.

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