OpenSeries Property

Visual Basic
C#

'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.

This example sets the OpenSeries property.

C#

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);

VB.NET

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)

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

Reference

SpreadOpenHighLowCloseSeries Class
SpreadOpenHighLowCloseSeries Members