FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > BetweenValuesConditionalFormattingRule Class : FirstFormula Property |
'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;}
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.Win.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Win.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.ActiveSheet.SetConditionalFormatting(1, 1, between);
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.Win.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.ActiveSheet.SetConditionalFormatting(1, 1, between)
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8