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

Visual Basic (Declaration)
Public Overridable Property MinValue As ConditionalFormattingColorValue

Visual Basic (Usage)	Copy Code
Dim instance As TwoColorScaleConditionalFormattingRule Dim value As ConditionalFormattingColorValue instance.MinValue = value value = instance.MinValue

C#
public virtual ConditionalFormattingColorValue MinValue {get; set;}

Example

This example sets the MinValue property.

C#	Copy Code
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.Web.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Web.Spread.TwoColorScaleConditionalFormattingRule(); two.MaxValue = new FarPoint.Web.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Web.Spread.ConditionalFormattingValueType.Max); two.MinValue = new FarPoint.Web.Spread.ConditionalFormattingColorValue(Color.Blue, 1, FarPoint.Web.Spread.ConditionalFormattingValueType.Min); FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, two);

Copy Code

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.Web.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Web.Spread.TwoColorScaleConditionalFormattingRule();
two.MaxValue = new FarPoint.Web.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Web.Spread.ConditionalFormattingValueType.Max);
two.MinValue = new FarPoint.Web.Spread.ConditionalFormattingColorValue(Color.Blue, 1, FarPoint.Web.Spread.ConditionalFormattingValueType.Min);
FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, two);

VB.NET	Copy Code
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.Web.Spread.TwoColorScaleConditionalFormattingRule() two.MaxValue = New FarPoint.Web.Spread.ConditionalFormattingColorValue(Drawing.Color.Red, 10, FarPoint.Web.Spread.ConditionalFormattingValueType.Max) two.MinValue = New FarPoint.Web.Spread.ConditionalFormattingColorValue(Drawing.Color.Blue, 1, FarPoint.Web.Spread.ConditionalFormattingValueType.Min) FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 3, 3, two)

VB.NET

Copy Code

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.Web.Spread.TwoColorScaleConditionalFormattingRule()
two.MaxValue = New FarPoint.Web.Spread.ConditionalFormattingColorValue(Drawing.Color.Red, 10, FarPoint.Web.Spread.ConditionalFormattingValueType.Max)
two.MinValue = New FarPoint.Web.Spread.ConditionalFormattingColorValue(Drawing.Color.Blue, 1, FarPoint.Web.Spread.ConditionalFormattingValueType.Min)
FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 3, 3, two)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Syntax

Example

Requirements

See Also

Reference

Spread for ASP.NET 7.0 Product Documentation
MinValue Property
See Also Example Support Options