Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / BetweenValuesConditionalFormattingRule Class / SecondFormula Property
Example


In This Topic
    SecondFormula Property
    In This Topic
    Gets or sets the second formula.
    Syntax
    'Declaration
     
    Public Property SecondFormula As String
    'Usage
     
    Dim instance As BetweenValuesConditionalFormattingRule
    Dim value As String
     
    instance.SecondFormula = value
     
    value = instance.SecondFormula
    public string SecondFormula {get; set;}

    Property Value

    The second formula.
    Example
    This example specifies the values using formulas.
    protected void Page_Load(object sender, EventArgs e)
    {
    if (this.IsPostBack) return;
    FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
    FpSpread1.Sheets[0].Cells[0, 1].Value = 2;
    FpSpread1.Sheets[0].Cells[0, 2].Value = 1;
    FpSpread1.Sheets[0].Cells[0, 3].Value = 1;
    FpSpread1.Sheets[0].Cells[1, 0].Value = 2;
    FpSpread1.Sheets[0].Cells[1, 1].Value = 6;
    
    FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false, "=B1+B2", true, "=C1+D1", true);
    between.BackColor = System.Drawing.Color.Bisque;
    between.FirstFormula = "=B1+B2";
    between.SecondFormula = "=C1+D1";
    between.StopIfTrue = false;
    FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, between);
    }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
    If (IsPostBack) Then
     Return
    End If
    FpSpread1.Sheets(0).Cells(0, 0).Value = 3
    FpSpread1.Sheets(0).Cells(0, 1).Value = 2
    FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    FpSpread1.Sheets(0).Cells(0, 3).Value = 1
    FpSpread1.Sheets(0).Cells(1, 0).Value = 2
    FpSpread1.Sheets(0).Cells(1, 1).Value = 6
    
    Dim between as New FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false, "=B1+B2", true, "=C1+D1", true)
    between.BackColor = System.Drawing.Color.Bisque
    between.FirstFormula = "=B1+B2"
    between.SecondFormula = "=C1+D1"
    between.StopIfTrue = false
    FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, between)
    End Sub
    See Also