GrapeCity.Xaml.SpreadSheet.Data Namespace > SpreadDataSeries Class : ValueFormula Property |
'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;}
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)
Target Platforms: Windows Server 2012, Windows RT