GrapeCity.Xaml.SpreadSheet.Data
ValueFormula Property
Example 


Gets or sets the formula reference for the series data.
Syntax
'Declaration
 
Public Property ValueFormula As String
'Usage
 
Dim instance As SpreadDataSeries
Dim value As String
 
instance.ValueFormula = value
 
value = instance.ValueFormula
public 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.Xaml.SpreadSheet.Data.SpreadBubbleSeries series0 = new GrapeCity.Xaml.SpreadSheet.Data.SpreadBubbleSeries();
series0.Name = "Series 0";
series0.XValueFormula = "Sheet1!$B$1:$B$4";
series0.ValueFormula = "Sheet1!$A$1:$A$4";
GrapeCity.Xaml.SpreadSheet.Data.SpreadBubbleSeries series1 = new GrapeCity.Xaml.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.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart();
chart.DataSeries.Add(series0);
chart.DataSeries.Add(series1);
chart.ChartType = GrapeCity.Xaml.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.Xaml.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.Xaml.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.Xaml.SpreadSheet.Data.SpreadChart()
chart.DataSeries.Add(series0)
chart.DataSeries.Add(series1)
chart.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.Bubble
chart.Name = "name1"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SpreadDataSeries Class
SpreadDataSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options