Spread Silverlight Documentation
ValueFormula Property
Example 


Gets or sets the formula reference for the series data.
Syntax
'Declaration
 
Public Property ValueFormula As System.String
'Usage
 
Dim instance As SpreadDataSeries
Dim value As System.String
 
instance.ValueFormula = value
 
value = instance.ValueFormula
public System.string ValueFormula {get; set;}

Property Value

The formula reference.
Example
This example uses the ValueFormula 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

SpreadDataSeries Class
SpreadDataSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.