Spread for ASP.NET 9.0 Product Documentation
FillColor Property
Example 


Gets or sets the color of the fill.
Syntax
'Declaration
 
Public Property FillColor As Color
'Usage
 
Dim instance As DatabarConditionalFormattingRule
Dim value As Color
 
instance.FillColor = value
 
value = instance.FillColor
public Color FillColor {get; set;}

Property Value

The color of the fill.
Example
This example uses the FillColor property.
protected void Page_Load(object sender, EventArgs e)
        {
            if (this.IsPostBack) return;
            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.DatabarConditionalFormattingRule d = new FarPoint.Web.Spread.DatabarConditionalFormattingRule();
            d.ShowBorder = true;
            d.AxisColor = System.Drawing.Color.DarkOrange;
            d.UseNegativeBorderColor = true;
            d.NegativeBorderColor = System.Drawing.Color.Green;
            d.FillColor = System.Drawing.Color.Bisque;
            d.NegativeFillColor = System.Drawing.Color.Aqua;
            d.Maximum = new FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number);
            FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d); 
        }
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        If (IsPostBack) Then
            Return
        End If
        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 d As New FarPoint.Web.Spread.DatabarConditionalFormattingRule()
        d.ShowBorder = True
        d.AxisColor = System.Drawing.Color.DarkOrange
        d.UseNegativeBorderColor = True
        d.NegativeBorderColor = System.Drawing.Color.Green
        d.FillColor = System.Drawing.Color.Bisque
        d.NegativeFillColor = System.Drawing.Color.Aqua
        d.Maximum = New FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number)
        FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d)
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DatabarConditionalFormattingRule Class
DatabarConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.