Spread Silverlight Documentation
XValueFormula Property
Example 


Gets or sets the X values formula.
Syntax
'Declaration
 
Public Property XValueFormula As System.String
'Usage
 
Dim instance As SpreadXYDataSeries
Dim value As System.String
 
instance.XValueFormula = value
 
value = instance.XValueFormula
public System.string XValueFormula {get; set;}

Property Value

The X values formula.
Example
This example uses the XValueFormula property for values.
gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 2 }, { 4 }, { 3 }, { 5 } });
gcSpreadSheet1.ActiveSheet.SetArray(0, 1, new object[,] { { 1 }, { 2 }, { 4 }, { 8 } });
GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries series0 = new GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries();
series0.Name = "Series 0";
series0.XValueFormula = "Sheet1!$B$1:$B$4";
series0.ValueFormula = "Sheet1!$A$1:$A$4";
GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries series1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries();
series1.Name = "Series 1";
series1.XValues.Add(1.0);
series1.XValues.Add(3.0);
series1.XValues.Add(5.0);
series1.XValues.Add(8.0);
series1.Values.Add(1.0);
series1.Values.Add(2.0);
series1.Values.Add(4.0);
series1.Values.Add(8.0);
series1.SizeValues.Add(4.0);
series1.SizeValues.Add(3.0);
series1.SizeValues.Add(4.0);
series1.SizeValues.Add(3.0);
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
chart.DataSeries.Add(series0);
chart.DataSeries.Add(series1);
chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble;
chart.Name = "name1";
gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{2}, {4}, {3}, {5}})
GcSpreadSheet1.ActiveSheet.SetArray(0, 1, New Object(,) {{1}, {2}, {4}, {8}})
Dim series0 As New GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries()
series0.Name = "Series 0"
series0.XValueFormula = "Sheet1!$B$1:$B$4"
series0.ValueFormula = "Sheet1!$A$1:$A$4"
Dim series1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadBubbleSeries()
series1.Name = "Series 1"
series1.XValues.Add(1.0)
series1.XValues.Add(3.0)
series1.XValues.Add(5.0)
series1.XValues.Add(8.0)
series1.Values.Add(1.0)
series1.Values.Add(2.0)
series1.Values.Add(4.0)
series1.Values.Add(8.0)
series1.SizeValues.Add(4.0)
series1.SizeValues.Add(3.0)
series1.SizeValues.Add(4.0)
series1.SizeValues.Add(3.0)
Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
chart.DataSeries.Add(series0)
chart.DataSeries.Add(series1)
chart.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.Bubble
chart.Name = "name1"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
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

SpreadXYDataSeries Class
SpreadXYDataSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.