Spread WPF Documentation
OpenSeries Property
Example 


Gets the open series.
Syntax
'Declaration
 
Public ReadOnly Property OpenSeries As SpreadDataSeries
'Usage
 
Dim instance As SpreadOpenHighLowCloseSeries
Dim value As SpreadDataSeries
 
value = instance.OpenSeries
public SpreadDataSeries OpenSeries {get;}

Property Value

The open series.
Example
This example uses the OpenSeries property.
GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries open = new GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries();
open.XValues = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
open.XValues.Add(1);
open.XValues.Add(2);
open.XValues.Add(3);
open.XValues.Add(4);
open.XValues.Add(5);
open.HighSeries.Values.AddRange(new double[] { 5, 7, 6, 8, 7, 9 });
open.LowSeries.Values.AddRange(new double[] { 2, 4, 3, 5, 4, 6 });
open.CloseSeries.Values.AddRange(new Double[] { 4, 6, 5, 7, 6, 8 });
open.OpenSeries.Values.AddRange(new Double[] { 3, 8, 9, 10, 12, 6 });
GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart();
chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose;
chart1.DataSeries.Add(open);
chart1.Name = "Name";
this.gcSpreadSheet1.ActiveSheet.Charts.Add(chart1);
Dim open As New GrapeCity.Windows.SpreadSheet.Data.SpreadOpenHighLowCloseSeries()
open.XValues = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
open.XValues.Add(1)
open.XValues.Add(2)
open.XValues.Add(3)
open.XValues.Add(4)
open.XValues.Add(5)
open.HighSeries.Values.AddRange(New Double() {5, 7, 6, 8, 7, 9})
open.LowSeries.Values.AddRange(New Double() {2, 4, 3, 5, 4, 6})
open.CloseSeries.Values.AddRange(New Double() {4, 6, 5, 7, 6, 8})
open.OpenSeries.Values.AddRange(New Double() {3, 8, 9, 10, 12, 6})

Dim chart1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart()
chart1.ChartType = GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.StockHighLowOpenClose
chart1.DataSeries.Add(open)
chart1.Name = "Name"
GcSpreadSheet1.ActiveSheet.Charts.Add(chart1)
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

See Also

Reference

SpreadOpenHighLowCloseSeries Class
SpreadOpenHighLowCloseSeries Members

 

 


Copyright © GrapeCity, inc. All rights reserved.