Spread for ASP.NET 9.0 Product Documentation
FirstFormula Property
Example 


Gets or sets the first formula.
Syntax
'Declaration
 
Public Property FirstFormula As String
'Usage
 
Dim instance As BetweenValuesConditionalFormattingRule
Dim value As String
 
instance.FirstFormula = value
 
value = instance.FirstFormula
public string FirstFormula {get; set;}

Property Value

The first 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
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

BetweenValuesConditionalFormattingRule Class
BetweenValuesConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.