Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / SpreadChart Class / NameFormula Property
Example


In This Topic
    NameFormula Property (SpreadChart)
    In This Topic
    Gets or sets the series name formula.
    Syntax
    'Declaration
     
    Public Property NameFormula As String
    'Usage
     
    Dim instance As SpreadChart
    Dim value As String
     
    instance.NameFormula = value
     
    value = instance.NameFormula
    public string NameFormula {get; set;}

    Property Value

    This property is not designed for persisting so you should save and re-use the value and access infrequently.
    Example
    This example uses the NameFormula property.
    object[,] values = {{"","Dep1","Dep2","Dep3","Dep4"},
                                   {"a",12,13,14,15},
                                   {"b",20,15,25,16},
                                   {"c",4,9,5,11},
                                   {"d",15,10,18,12},
                                   {"d",17,6,14,11}};
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, values);
    GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnClustered, 0, 0, 400, 400);
    chart.ItemsFormula = "Sheet1!$A$2:$A$6";
    chart.NameFormula = "Sheet1!$B$1:$E$1";
    chart.DataFormula = "Sheet1!$B$2:$E$6";
    Dim values As Object(,) = {{"", "Dep1", "Dep2", "Dep3", "Dep4"}, {"a", 12, 13, 14, 15}, {"b", 20, 15, 25, 16}, {"c", 4, 9, 5, 11}, {"d", 15, 10, 18, 12}, {"d", 17, 6, 14, 11}}
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, values)
    Dim chart As GrapeCity.Xaml.SpreadSheet.Data.SpreadChart = GcSpreadSheet1.ActiveSheet.AddChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnClustered, 0, 0, 400, 400)
    chart.ItemsFormula = "Sheet1!$A$2:$A$6"
    chart.NameFormula = "Sheet1!$B$1:$E$1"
    chart.DataFormula = "Sheet1!$B$2:$E$6"
    See Also