Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / SpreadSurfaceChart Class / DataFormula Property
Example


In This Topic
    DataFormula Property (SpreadSurfaceChart)
    In This Topic
    Gets or sets the data formula. This action will re-build the chart's series.
    Syntax
    'Declaration
     
    Public Property DataFormula As String
    'Usage
     
    Dim instance As SpreadSurfaceChart
    Dim value As String
     
    instance.DataFormula = value
     
    value = instance.DataFormula
    public string DataFormula {get; set;}

    Property Value

    The data formula.
    Remarks
    This property is not designed for persisting so you should save and re-use the value and access infrequently.
    Example
    This example uses the DataFormula property.
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 2 }, { 3 }, { 5 } });
    GcSpreadSheet1.ActiveSheet.SetArray(0, 1, new object[,] { { 3 }, { 6 }, { 4 } });
    GcSpreadSheet1.ActiveSheet.SetArray(0, 2, new object[,] { { 5 }, { 1 }, { 3 } });
    GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart schart = new GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300);
    schart.DataFormula = "Sheet1!$A$1:$C$3";
    this.GcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart);
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New object(,) { { 2 }, { 3 }, { 5 } })
    GcSpreadSheet1.ActiveSheet.SetArray(0, 1, New object(,) { { 3 }, { 6 }, { 4 } })
    GcSpreadSheet1.ActiveSheet.SetArray(0, 2, New object(,) { { 5 }, { 1 }, { 3 } })
    Dim schart As New GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300)
    schart.DataFormula = "Sheet1!$A$1:$C$3"
    GcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart)
    See Also