ConditionalFormat Constructor(NamedStyle)

Creates a new conditional format with the specified style.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal style As NamedStyle _
)

'Usage
 
Dim style As NamedStyle
 
Dim instance As New ConditionalFormat(style)

public ConditionalFormat( 
   NamedStyle style
)

Parameters

style: Style

Example

FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle(); 
FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle(); 
FarPoint.Win.Spread.NamedStyle styleMild = new FarPoint.Win.Spread.NamedStyle(); 
FarPoint.Win.Spread.NamedStyle styleWarm = new FarPoint.Win.Spread.NamedStyle(); 
FarPoint.Win.Spread.NamedStyle styleHot = new FarPoint.Win.Spread.NamedStyle(); 
styleCold.BackColor = Color.Blue; 
styleCold.ForeColor = Color.White; 
styleCool.BackColor = Color.Cyan; 
styleMild.BackColor = Color.Lime; 
styleWarm.BackColor = Color.Yellow; 
styleHot.BackColor = Color.Red; 
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "32"); 
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55"); 
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75"); 
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85"); 
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85"); 

fpSpread1.ActiveSheet.Cells[1, 1].Value = 38;

FarPoint.Win.Spread.ConditionalFormat[]cf;  
cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1, false); 
foreach (FarPoint.Win.Spread.ConditionalFormat item in cf) 
{ 
      MessageBox.Show(item.FirstCondition.ToString()); 
}

Visual Basic

Dim styleCold As New FarPoint.Win.Spread.NamedStyle
Dim styleCool As New FarPoint.Win.Spread.NamedStyle
Dim styleMild As New FarPoint.Win.Spread.NamedStyle
Dim styleWarm As New FarPoint.Win.Spread.NamedStyle
Dim styleHot As New FarPoint.Win.Spread.NamedStyle
styleCold.BackColor = Color.Blue
styleCold.ForeColor = Color.White
styleCool.BackColor = Color.Cyan
styleMild.BackColor = Color.Lime
styleWarm.BackColor = Color.Yellow
styleHot.BackColor = Color.Red

Dim co As New FarPoint.Win.Spread.ComparisonOperator
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, co.LessThan, "32")
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCool, co.Between, "32", "55")
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleMild, co.Between, "55", "75")
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleWarm, co.Between, "75", "85")
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleHot, co.GreaterThan, "85")

fpSpread1.ActiveSheet.Cells(1, 1).Value = 38

Dim cf As FarPoint.Win.Spread.ConditionalFormat()
Dim item As New FarPoint.Win.Spread.ConditionalFormat(styleCool)
cf = fpSpread1.ActiveSheet.GetConditionalFormats(1, 1, False)
For Each item In cf
      MessageBox.Show(item.FirstCondition.ToString())
Next

Reference

ConditionalFormat Class
ConditionalFormat Members
Overload List