Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / FormulaRule Class / Formula Property
Example


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

    Property Value

    The comparison formula of the text rule.
    Example
    This example uses 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.Xaml.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
    
    GrapeCity.Xaml.SpreadSheet.Data.FormulaRule test = new GrapeCity.Xaml.SpreadSheet.Data.FormulaRule();
    test.Style = style2;
    test.Formula = "=A1=B1+C1";
    test.Ranges = new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
    
    Dim test As New GrapeCity.Xaml.SpreadSheet.Data.FormulaRule()
    test.Style = style2
    test.Formula = "=A1=B1+C1"
    test.Ranges = New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)}
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(test)   
    See Also