Aspose::Cells::Charts::ISparklineGroup Class Referenceabstract

ISparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines. More...

Inherits Object.

Public Member Functions

virtual void ResetRanges (intrusive_ptr< Aspose::Cells::Systems::String > dataRange, bool isVertical, intrusive_ptr< Aspose::Cells::ICellArea > locationRange)=0
 Resets the data range and location range of the sparkline group. This method will clear original sparkline items in the group and creates new sparkline items for the new ranges. More...
 
virtual Aspose::Cells::Charts::SparklinePresetStyleType GetPresetStyle ()=0
 Gets the preset style type of the sparkline group. More...
 
virtual void SetPresetStyle (Aspose::Cells::Charts::SparklinePresetStyleType value)=0
 Sets the preset style type of the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::Charts::ISparklineCollectionGetISparklineCollection ()=0
 Gets the ISparklineCollection object of the sparkline group. More...
 
virtual Aspose::Cells::Charts::SparklineType GetType ()=0
 Indicates the sparkline type of the sparkline group. More...
 
virtual void SetType (Aspose::Cells::Charts::SparklineType value)=0
 Indicates the sparkline type of the sparkline group. More...
 
virtual Aspose::Cells::Charts::PlotEmptyCellsType GetPlotEmptyCellsType ()=0
 Indicates how to plot empty cells. More...
 
virtual void SetPlotEmptyCellsType (Aspose::Cells::Charts::PlotEmptyCellsType value)=0
 Indicates how to plot empty cells. More...
 
virtual bool GetDisplayHidden ()=0
 Indicates whether to show data in hidden rows and columns. More...
 
virtual void SetDisplayHidden (bool value)=0
 Indicates whether to show data in hidden rows and columns. More...
 
virtual bool GetShowHighPoint ()=0
 Indicates whether to highlight the highest points of data in the sparkline group. More...
 
virtual void SetShowHighPoint (bool value)=0
 Indicates whether to highlight the highest points of data in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetHighPointICellsColor ()=0
 Gets the color of the highest points of data in the sparkline group. More...
 
virtual void SetHighPointICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the highest points of data in the sparkline group. More...
 
virtual bool GetShowLowPoint ()=0
 Indicates whether to highlight the lowest points of data in the sparkline group. More...
 
virtual void SetShowLowPoint (bool value)=0
 Indicates whether to highlight the lowest points of data in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetLowPointICellsColor ()=0
 Gets the color of the lowest points of data in the sparkline group. More...
 
virtual void SetLowPointICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the lowest points of data in the sparkline group. More...
 
virtual bool GetShowNegativePoints ()=0
 Indicates whether to highlight the negative values on the sparkline group with a different color or marker. More...
 
virtual void SetShowNegativePoints (bool value)=0
 Indicates whether to highlight the negative values on the sparkline group with a different color or marker. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetNegativePointsICellsColor ()=0
 Gets the color of the negative values on the sparkline group. More...
 
virtual void SetNegativePointsICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the negative values on the sparkline group. More...
 
virtual bool GetShowFirstPoint ()=0
 Indicates whether to highlight the first point of data in the sparkline group. More...
 
virtual void SetShowFirstPoint (bool value)=0
 Indicates whether to highlight the first point of data in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetFirstPointICellsColor ()=0
 Gets the color of the first point of data in the sparkline group. More...
 
virtual void SetFirstPointICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the first point of data in the sparkline group. More...
 
virtual bool GetShowLastPoint ()=0
 Indicates whether to highlight the last point of data in the sparkline group. More...
 
virtual void SetShowLastPoint (bool value)=0
 Indicates whether to highlight the last point of data in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetLastPointICellsColor ()=0
 Gets the color of the last point of data in the sparkline group. More...
 
virtual void SetLastPointICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the last point of data in the sparkline group. More...
 
virtual bool GetShowMarkers ()=0
 Indicates whether to highlight each point in each line sparkline in the sparkline group. More...
 
virtual void SetShowMarkers (bool value)=0
 Indicates whether to highlight each point in each line sparkline in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetMarkersICellsColor ()=0
 Gets the color of points in each line sparkline in the sparkline group. More...
 
virtual void SetMarkersICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of points in each line sparkline in the sparkline group. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetSeriesICellsColor ()=0
 Gets the color of the sparklines in the sparkline group. More...
 
virtual void SetSeriesICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the sparklines in the sparkline group. More...
 
virtual bool GetPlotRightToLeft ()=0
 Indicates whether the plot data is right to left. More...
 
virtual void SetPlotRightToLeft (bool value)=0
 Indicates whether the plot data is right to left. More...
 
virtual Aspose::Cells::Systems::Double GetLineWeight ()=0
 Gets the line weight in each line sparkline in the sparkline group, in the unit of points. More...
 
virtual void SetLineWeight (Aspose::Cells::Systems::Double value)=0
 Sets the line weight in each line sparkline in the sparkline group, in the unit of points. More...
 
virtual intrusive_ptr< Aspose::Cells::ICellsColorGetHorizontalAxisICellsColor ()=0
 Gets the color of the horizontal axis in the sparkline group. More...
 
virtual void SetHorizontalAxisICellsColor (intrusive_ptr< Aspose::Cells::ICellsColor > value)=0
 Sets the color of the horizontal axis in the sparkline group. More...
 
virtual bool GetShowHorizontalAxis ()=0
 Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis. More...
 
virtual void SetShowHorizontalAxis (bool value)=0
 Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis. More...
 
virtual intrusive_ptr< Aspose::Cells::Systems::String > GetHorizontalAxisDateRange ()=0
 Represents the range that contains the date values for the sparkline data. More...
 
virtual void SetHorizontalAxisDateRange (intrusive_ptr< Aspose::Cells::Systems::String > value)=0
 Represents the range that contains the date values for the sparkline data. More...
 
virtual Aspose::Cells::Charts::SparklineAxisMinMaxType GetVerticalAxisMaxValueType ()=0
 Represents the vertical axis maximum value type. More...
 
virtual void SetVerticalAxisMaxValueType (Aspose::Cells::Charts::SparklineAxisMinMaxType value)=0
 Represents the vertical axis maximum value type. More...
 
virtual Aspose::Cells::Systems::Double GetVerticalAxisMaxValue ()=0
 Gets the custom maximum value for the vertical axis. More...
 
virtual void SetVerticalAxisMaxValue (Aspose::Cells::Systems::Double value)=0
 Sets the custom maximum value for the vertical axis. More...
 
virtual Aspose::Cells::Charts::SparklineAxisMinMaxType GetVerticalAxisMinValueType ()=0
 Represents the vertical axis minimum value type. More...
 
virtual void SetVerticalAxisMinValueType (Aspose::Cells::Charts::SparklineAxisMinMaxType value)=0
 Represents the vertical axis minimum value type. More...
 
virtual Aspose::Cells::Systems::Double GetVerticalAxisMinValue ()=0
 Gets the custom minimum value for the vertical axis. More...
 
virtual void SetVerticalAxisMinValue (Aspose::Cells::Systems::Double value)=0
 Sets the custom minimum value for the vertical axis. More...
 

Detailed Description

ISparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines.

Member Function Documentation

◆ GetDisplayHidden()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetDisplayHidden ( )
pure virtual

Indicates whether to show data in hidden rows and columns.

◆ GetFirstPointICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetFirstPointICellsColor ( )
pure virtual

Gets the color of the first point of data in the sparkline group.

◆ GetHighPointICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetHighPointICellsColor ( )
pure virtual

Gets the color of the highest points of data in the sparkline group.

◆ GetHorizontalAxisDateRange()

virtual intrusive_ptr<Aspose::Cells::Systems::String> Aspose::Cells::Charts::ISparklineGroup::GetHorizontalAxisDateRange ( )
pure virtual

Represents the range that contains the date values for the sparkline data.

◆ GetHorizontalAxisICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetHorizontalAxisICellsColor ( )
pure virtual

Gets the color of the horizontal axis in the sparkline group.

◆ GetISparklineCollection()

virtual intrusive_ptr<Aspose::Cells::Charts::ISparklineCollection> Aspose::Cells::Charts::ISparklineGroup::GetISparklineCollection ( )
pure virtual

Gets the ISparklineCollection object of the sparkline group.

◆ GetLastPointICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetLastPointICellsColor ( )
pure virtual

Gets the color of the last point of data in the sparkline group.

◆ GetLineWeight()

virtual Aspose::Cells::Systems::Double Aspose::Cells::Charts::ISparklineGroup::GetLineWeight ( )
pure virtual

Gets the line weight in each line sparkline in the sparkline group, in the unit of points.

◆ GetLowPointICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetLowPointICellsColor ( )
pure virtual

Gets the color of the lowest points of data in the sparkline group.

◆ GetMarkersICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetMarkersICellsColor ( )
pure virtual

Gets the color of points in each line sparkline in the sparkline group.

◆ GetNegativePointsICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetNegativePointsICellsColor ( )
pure virtual

Gets the color of the negative values on the sparkline group.

◆ GetPlotEmptyCellsType()

virtual Aspose::Cells::Charts::PlotEmptyCellsType Aspose::Cells::Charts::ISparklineGroup::GetPlotEmptyCellsType ( )
pure virtual

Indicates how to plot empty cells.

◆ GetPlotRightToLeft()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetPlotRightToLeft ( )
pure virtual

Indicates whether the plot data is right to left.

◆ GetPresetStyle()

virtual Aspose::Cells::Charts::SparklinePresetStyleType Aspose::Cells::Charts::ISparklineGroup::GetPresetStyle ( )
pure virtual

Gets the preset style type of the sparkline group.

◆ GetSeriesICellsColor()

virtual intrusive_ptr<Aspose::Cells::ICellsColor> Aspose::Cells::Charts::ISparklineGroup::GetSeriesICellsColor ( )
pure virtual

Gets the color of the sparklines in the sparkline group.

◆ GetShowFirstPoint()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowFirstPoint ( )
pure virtual

Indicates whether to highlight the first point of data in the sparkline group.

◆ GetShowHighPoint()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowHighPoint ( )
pure virtual

Indicates whether to highlight the highest points of data in the sparkline group.

◆ GetShowHorizontalAxis()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowHorizontalAxis ( )
pure virtual

Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.

◆ GetShowLastPoint()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowLastPoint ( )
pure virtual

Indicates whether to highlight the last point of data in the sparkline group.

◆ GetShowLowPoint()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowLowPoint ( )
pure virtual

Indicates whether to highlight the lowest points of data in the sparkline group.

◆ GetShowMarkers()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowMarkers ( )
pure virtual

Indicates whether to highlight each point in each line sparkline in the sparkline group.

◆ GetShowNegativePoints()

virtual bool Aspose::Cells::Charts::ISparklineGroup::GetShowNegativePoints ( )
pure virtual

Indicates whether to highlight the negative values on the sparkline group with a different color or marker.

◆ GetType()

virtual Aspose::Cells::Charts::SparklineType Aspose::Cells::Charts::ISparklineGroup::GetType ( )
pure virtual

Indicates the sparkline type of the sparkline group.

◆ GetVerticalAxisMaxValue()

virtual Aspose::Cells::Systems::Double Aspose::Cells::Charts::ISparklineGroup::GetVerticalAxisMaxValue ( )
pure virtual

Gets the custom maximum value for the vertical axis.

◆ GetVerticalAxisMaxValueType()

virtual Aspose::Cells::Charts::SparklineAxisMinMaxType Aspose::Cells::Charts::ISparklineGroup::GetVerticalAxisMaxValueType ( )
pure virtual

Represents the vertical axis maximum value type.

◆ GetVerticalAxisMinValue()

virtual Aspose::Cells::Systems::Double Aspose::Cells::Charts::ISparklineGroup::GetVerticalAxisMinValue ( )
pure virtual

Gets the custom minimum value for the vertical axis.

◆ GetVerticalAxisMinValueType()

virtual Aspose::Cells::Charts::SparklineAxisMinMaxType Aspose::Cells::Charts::ISparklineGroup::GetVerticalAxisMinValueType ( )
pure virtual

Represents the vertical axis minimum value type.

◆ ResetRanges()

virtual void Aspose::Cells::Charts::ISparklineGroup::ResetRanges ( intrusive_ptr< Aspose::Cells::Systems::String >  dataRange,
bool  isVertical,
intrusive_ptr< Aspose::Cells::ICellArea locationRange 
)
pure virtual

Resets the data range and location range of the sparkline group. This method will clear original sparkline items in the group and creates new sparkline items for the new ranges.

Parameters
dataRangeSpecifies the new data range of the sparkline group.
isVerticalSpecifies whether to plot the sparklines from the new data range by row or by column.
locationRangeSpecifies where the sparklines to be placed.

◆ SetDisplayHidden()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetDisplayHidden ( bool  value)
pure virtual

Indicates whether to show data in hidden rows and columns.

◆ SetFirstPointICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetFirstPointICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the first point of data in the sparkline group.

◆ SetHighPointICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetHighPointICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the highest points of data in the sparkline group.

◆ SetHorizontalAxisDateRange()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetHorizontalAxisDateRange ( intrusive_ptr< Aspose::Cells::Systems::String >  value)
pure virtual

Represents the range that contains the date values for the sparkline data.

◆ SetHorizontalAxisICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetHorizontalAxisICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the horizontal axis in the sparkline group.

◆ SetLastPointICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetLastPointICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the last point of data in the sparkline group.

◆ SetLineWeight()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetLineWeight ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the line weight in each line sparkline in the sparkline group, in the unit of points.

◆ SetLowPointICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetLowPointICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the lowest points of data in the sparkline group.

◆ SetMarkersICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetMarkersICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of points in each line sparkline in the sparkline group.

◆ SetNegativePointsICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetNegativePointsICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the negative values on the sparkline group.

◆ SetPlotEmptyCellsType()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetPlotEmptyCellsType ( Aspose::Cells::Charts::PlotEmptyCellsType  value)
pure virtual

Indicates how to plot empty cells.

◆ SetPlotRightToLeft()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetPlotRightToLeft ( bool  value)
pure virtual

Indicates whether the plot data is right to left.

◆ SetPresetStyle()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetPresetStyle ( Aspose::Cells::Charts::SparklinePresetStyleType  value)
pure virtual

Sets the preset style type of the sparkline group.

◆ SetSeriesICellsColor()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetSeriesICellsColor ( intrusive_ptr< Aspose::Cells::ICellsColor value)
pure virtual

Sets the color of the sparklines in the sparkline group.

◆ SetShowFirstPoint()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowFirstPoint ( bool  value)
pure virtual

Indicates whether to highlight the first point of data in the sparkline group.

◆ SetShowHighPoint()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowHighPoint ( bool  value)
pure virtual

Indicates whether to highlight the highest points of data in the sparkline group.

◆ SetShowHorizontalAxis()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowHorizontalAxis ( bool  value)
pure virtual

Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.

◆ SetShowLastPoint()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowLastPoint ( bool  value)
pure virtual

Indicates whether to highlight the last point of data in the sparkline group.

◆ SetShowLowPoint()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowLowPoint ( bool  value)
pure virtual

Indicates whether to highlight the lowest points of data in the sparkline group.

◆ SetShowMarkers()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowMarkers ( bool  value)
pure virtual

Indicates whether to highlight each point in each line sparkline in the sparkline group.

◆ SetShowNegativePoints()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetShowNegativePoints ( bool  value)
pure virtual

Indicates whether to highlight the negative values on the sparkline group with a different color or marker.

◆ SetType()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetType ( Aspose::Cells::Charts::SparklineType  value)
pure virtual

Indicates the sparkline type of the sparkline group.

◆ SetVerticalAxisMaxValue()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetVerticalAxisMaxValue ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the custom maximum value for the vertical axis.

◆ SetVerticalAxisMaxValueType()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetVerticalAxisMaxValueType ( Aspose::Cells::Charts::SparklineAxisMinMaxType  value)
pure virtual

Represents the vertical axis maximum value type.

◆ SetVerticalAxisMinValue()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetVerticalAxisMinValue ( Aspose::Cells::Systems::Double  value)
pure virtual

Sets the custom minimum value for the vertical axis.

◆ SetVerticalAxisMinValueType()

virtual void Aspose::Cells::Charts::ISparklineGroup::SetVerticalAxisMinValueType ( Aspose::Cells::Charts::SparklineAxisMinMaxType  value)
pure virtual

Represents the vertical axis minimum value type.