Spread WPF Documentation
ValueFormula Property
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SpreadDataSeries Class : ValueFormula Property
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)
See Also

Reference

SpreadDataSeries Class
SpreadDataSeries Members