Spread Silverlight Documentation
DataFormula Property (SpreadSurfaceChart)
Example 


Gets or sets the data formula. This action will re-build the chart's series.
Syntax
'Declaration
 
Public Property DataFormula As System.String
'Usage
 
Dim instance As SpreadSurfaceChart
Dim value As System.String
 
instance.DataFormula = value
 
value = instance.DataFormula
public System.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 sets 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)
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

SpreadSurfaceChart Class
SpreadSurfaceChart Members

 

 


Copyright © GrapeCity, inc. All rights reserved.