Spread Windows Forms 10.0 Product Documentation
MinValue Property (TwoColorScaleConditionalFormattingRule)
Example 


Gets or sets the minimum value. Note: The minimum value only accepts the ConditionalFormattingColorValue object which has a Type property value of Min, Number, Percent, Formula, or Pecentile.
Syntax
'Declaration
 
Public Overridable Property MinValue As ConditionalFormattingColorValue
'Usage
 
Dim instance As TwoColorScaleConditionalFormattingRule
Dim value As ConditionalFormattingColorValue
 
instance.MinValue = value
 
value = instance.MinValue
public virtual ConditionalFormattingColorValue MinValue {get; set;}
Example
This example uses the MinValue property.
fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
fpSpread1.Sheets[0].Cells[0, 2].Value = 1;
FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule();
two.MaxValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max);
two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, 3, 3, two);
FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(0, 2).Value = 1
Dim two As New FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule()
two.MaxValue = New FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max)
two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min)
FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 3, 3, two)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

TwoColorScaleConditionalFormattingRule Class
TwoColorScaleConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.