Aspose::Cells::Charts::ISeriesCollection Class Referenceabstract

Encapsulates a collection of Series objects. More...

Inherits CollectionBase.

Public Member Functions

virtual intrusive_ptr< Aspose::Cells::Charts::ISeriesGetObjectByIndex (Aspose::Cells::Systems::Int32 index)=0
 Gets the ISeries element at the specified index. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::ISeriesGetISeriesByOrder (Aspose::Cells::Systems::Int32 order)=0
 Gets the ISeries element by order. More...
 
virtual void RemoveAt (Aspose::Cells::Systems::Int32 index)=0
 Remove at a series at the specific index. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetCategoryData ()=0
 Sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). More...
 
virtual void SetCategoryData (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
 Sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetSecondCategoryData ()=0
 Gets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis. More...
 
virtual void SetSecondCategoryData (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
 Sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis. More...
 
virtual void ChangeSeriesOrder (Aspose::Cells::Systems::Int32 sourceIndex, Aspose::Cells::Systems::Int32 destIndex)=0
 Directly chanages the orders of the two series. More...
 
virtual void SetSeriesNames (Aspose::Cells::Systems::Int32 startIndex, intrusive_ptr< Aspose::Cells::Systems::String > area, bool isVertical)=0
 Sets the name of all the serieses in the chart. More...
 
virtual Aspose::Cells::Systems::Int32 AddR1C1 (intrusive_ptr< Aspose::Cells::Systems::String > area, bool isVertical)=0
 Adds the ISeriesCollection collection to a chart. More...
 
virtual Aspose::Cells::Systems::Int32 Add (intrusive_ptr< Aspose::Cells::Systems::String > area, bool isVertical)=0
 Adds the ISeriesCollection collection to a chart. More...
 
virtual Aspose::Cells::Systems::Int32 Add (intrusive_ptr< Aspose::Cells::Systems::String > area, bool isVertical, bool checkLabels)=0
 Adds the ISeriesCollection collection to a chart. More...
 
virtual bool IsColorVaried ()=0
 Represents if the color of points is varied. More...
 
virtual void SetColorVaried (bool value)=0
 Represents if the color of points is varied. More...
 
virtual void Clear ()=0
 Clears the collection More...
 

Detailed Description

Encapsulates a collection of Series objects.

Member Function Documentation

◆ Add() [1/2]

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::ISeriesCollection::Add ( intrusive_ptr< Aspose::Cells::Systems::String >  area,
bool  isVertical 
)
pure virtual

Adds the ISeriesCollection collection to a chart.

Parameters
areaSpecifies values from which to plot the data series
isVerticalSpecifies whether to plot the series from a range of cell values by row or by column.
Returns
Return the first index of the added ASeries in the NSeries.


If set data on contiguous cells, use colon to seperate them.For example, C2:C5.
If set data on non contiguous cells, use comma to seperate them.For example, C2,D5.

◆ Add() [2/2]

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::ISeriesCollection::Add ( intrusive_ptr< Aspose::Cells::Systems::String >  area,
bool  isVertical,
bool  checkLabels 
)
pure virtual

Adds the ISeriesCollection collection to a chart.

Parameters
areaSpecifies values from which to plot the data series
isVerticalSpecifies whether to plot the series from a range of cell values by row or by column.
checkLabelsIndicates whether the range contains series's name
Returns
Return the first index of the added ASeries in the NSeries.


If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.
If set data on non contiguous cells, use comma to seperate them.For example, ($C$2,$D$5).

◆ AddR1C1()

virtual Aspose::Cells::Systems::Int32 Aspose::Cells::Charts::ISeriesCollection::AddR1C1 ( intrusive_ptr< Aspose::Cells::Systems::String >  area,
bool  isVertical 
)
pure virtual

Adds the ISeriesCollection collection to a chart.

Parameters
areaSpecifies values from which to plot the data series
isVerticalSpecifies whether to plot the series from a range of cell values by row or by column.
Returns
Return the first index of the added ASeries in the NSeries.


If set data on contiguous cells, use colon to seperate them.For example, R[1]C[1]:R[3]C[2].
If set data on contiguous cells, use comma to seperate them.For example,R[1]C[1],R[3]C[2].

◆ ChangeSeriesOrder()

virtual void Aspose::Cells::Charts::ISeriesCollection::ChangeSeriesOrder ( Aspose::Cells::Systems::Int32  sourceIndex,
Aspose::Cells::Systems::Int32  destIndex 
)
pure virtual

Directly chanages the orders of the two series.

Parameters
sourceIndexThe current index
destIndexThe dest index

◆ Clear()

virtual void Aspose::Cells::Charts::ISeriesCollection::Clear ( )
pure virtual

Clears the collection

◆ GetCategoryData()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Charts::ISeriesCollection::GetCategoryData ( )
pure virtual

Sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}").

◆ GetISeriesByOrder()

virtual intrusive_ptr<Aspose::Cells::Charts::ISeries> Aspose::Cells::Charts::ISeriesCollection::GetISeriesByOrder ( Aspose::Cells::Systems::Int32  order)
pure virtual

Gets the ISeries element by order.

Parameters
orderThe order of series
Returns
The element series

◆ GetObjectByIndex()

virtual intrusive_ptr<Aspose::Cells::Charts::ISeries> Aspose::Cells::Charts::ISeriesCollection::GetObjectByIndex ( Aspose::Cells::Systems::Int32  index)
pure virtual

Gets the ISeries element at the specified index.

Parameters
indexThe zero based index of the element.
Returns
The element at the specified index.

◆ GetSecondCategoryData()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Charts::ISeriesCollection::GetSecondCategoryData ( )
pure virtual

Gets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

◆ IsColorVaried()

virtual bool Aspose::Cells::Charts::ISeriesCollection::IsColorVaried ( )
pure virtual

Represents if the color of points is varied.

◆ RemoveAt()

virtual void Aspose::Cells::Charts::ISeriesCollection::RemoveAt ( Aspose::Cells::Systems::Int32  index)
pure virtual

Remove at a series at the specific index.

Parameters
indexThe index.

◆ SetCategoryData()

virtual void Aspose::Cells::Charts::ISeriesCollection::SetCategoryData ( intrusive_ptr< Aspose::Cells::Systems::String >  value)
pure virtual

Sets the range of category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}").

◆ SetColorVaried()

virtual void Aspose::Cells::Charts::ISeriesCollection::SetColorVaried ( bool  value)
pure virtual

Represents if the color of points is varied.

◆ SetSecondCategoryData()

virtual void Aspose::Cells::Charts::ISeriesCollection::SetSecondCategoryData ( intrusive_ptr< Aspose::Cells::Systems::String >  value)
pure virtual

Sets the range of second category Axis values. It can be a range of cells (such as, "d1:e10"), or a sequence of values (such as,"{2,6,8,10}"). Only effects when some ASerieses plot on the second axis.

◆ SetSeriesNames()

virtual void Aspose::Cells::Charts::ISeriesCollection::SetSeriesNames ( Aspose::Cells::Systems::Int32  startIndex,
intrusive_ptr< Aspose::Cells::Systems::String >  area,
bool  isVertical 
)
pure virtual

Sets the name of all the serieses in the chart.

Parameters
startIndexThe index of the first series which you want to set the name.
areaSpecifies the area for the series name.
isVertical>Specifies whether to plot the series from a range of cell values by row or by column.


If the start index is larger than the count of the serieses, it will return and do nothing.
If set data on contiguous cells, use colon to seperate them.For example, $C$2:$C$5.
If set data on contiguous cells, use comma to seperate them.For example, ($C$2,$D$5).