Spread Silverlight Documentation
Formula Property (FormulaRule)
Example 


Gets the comparison formula of the text rule.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property Formula As System.String
'Usage
 
Dim instance As FormulaRule
Dim value As System.String
 
instance.Formula = value
 
value = instance.Formula
[System.ComponentModel.DefaultValue()]
public System.string Formula {get; set;}

Property Value

The comparison formula of the text rule.
Example
This example sets the Formula property.
gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 1;
gcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 1;
var style2 = new GrapeCity.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);

GrapeCity.Windows.SpreadSheet.Data.FormulaRule test = new GrapeCity.Windows.SpreadSheet.Data.FormulaRule();
test.Style = style2;
test.Formula = "=A1=B1+C1";
test.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1) };
gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(test);  
GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 1
GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 1
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)

Dim test As New GrapeCity.Windows.SpreadSheet.Data.FormulaRule()
test.Style = style2
test.Formula = "=A1=B1+C1"
test.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)
Requirements

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

See Also

Reference

FormulaRule Class
FormulaRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.