SparklineGroup

SparklineGroup class

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

class SparklineGroup;

Properties

Property	Type	Description
presetStyle	SparklinePresetStyleType	Gets and sets the preset style type of the sparkline group.
sparklines	SparklineCollection	Readonly. Gets the collection of Sparkline object.
type	SparklineType	Indicates the sparkline type of the sparkline group.
plotEmptyCellsType	PlotEmptyCellsType	Indicates how to plot empty cells.
displayHidden	boolean	Indicates whether to show data in hidden rows and columns.
showHighPoint	boolean	Indicates whether to highlight the highest points of data in the sparkline group.
highPointColor	CellsColor	Gets and sets the color of the highest points of data in the sparkline group.
showLowPoint	boolean	Indicates whether to highlight the lowest points of data in the sparkline group.
lowPointColor	CellsColor	Gets and sets the color of the lowest points of data in the sparkline group.
showNegativePoints	boolean	Indicates whether to highlight the negative values on the sparkline group with a different color or marker.
negativePointsColor	CellsColor	Gets and sets the color of the negative values on the sparkline group.
showFirstPoint	boolean	Indicates whether to highlight the first point of data in the sparkline group.
firstPointColor	CellsColor	Gets and sets the color of the first point of data in the sparkline group.
showLastPoint	boolean	Indicates whether to highlight the last point of data in the sparkline group.
lastPointColor	CellsColor	Gets and sets the color of the last point of data in the sparkline group.
showMarkers	boolean	Indicates whether to highlight each point in each line sparkline in the sparkline group.
markersColor	CellsColor	Gets and sets the color of points in each line sparkline in the sparkline group.
seriesColor	CellsColor	Gets and sets the color of the sparklines in the sparkline group.
plotRightToLeft	boolean	Indicates whether the plot data is right to left.
lineWeight	number	Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.
horizontalAxisColor	CellsColor	Gets and sets the color of the horizontal axis in the sparkline group.
showHorizontalAxis	boolean	Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.
horizontalAxisDateRange	string	Represents the range that contains the date values for the sparkline data.
verticalAxisMaxValueType	SparklineAxisMinMaxType	Represents the vertical axis maximum value type.
verticalAxisMaxValue	number	Gets and sets the custom maximum value for the vertical axis.
verticalAxisMinValueType	SparklineAxisMinMaxType	Represents the vertical axis minimum value type.
verticalAxisMinValue	number	Gets and sets the custom minimum value for the vertical axis.

Methods

Method	Description
getPresetStyle()	@deprecated. Please use the ‘presetStyle’ property instead. Gets and sets the preset style type of the sparkline group.
setPresetStyle(SparklinePresetStyleType)	@deprecated. Please use the ‘presetStyle’ property instead. Gets and sets the preset style type of the sparkline group.
getSparklines()	@deprecated. Please use the ‘sparklines’ property instead. Gets the collection of Sparkline object.
getType()	@deprecated. Please use the ’type’ property instead. Indicates the sparkline type of the sparkline group.
setType(SparklineType)	@deprecated. Please use the ’type’ property instead. Indicates the sparkline type of the sparkline group.
getPlotEmptyCellsType()	@deprecated. Please use the ‘plotEmptyCellsType’ property instead. Indicates how to plot empty cells.
setPlotEmptyCellsType(PlotEmptyCellsType)	@deprecated. Please use the ‘plotEmptyCellsType’ property instead. Indicates how to plot empty cells.
getDisplayHidden()	@deprecated. Please use the ‘displayHidden’ property instead. Indicates whether to show data in hidden rows and columns.
setDisplayHidden(boolean)	@deprecated. Please use the ‘displayHidden’ property instead. Indicates whether to show data in hidden rows and columns.
getShowHighPoint()	@deprecated. Please use the ‘showHighPoint’ property instead. Indicates whether to highlight the highest points of data in the sparkline group.
setShowHighPoint(boolean)	@deprecated. Please use the ‘showHighPoint’ property instead. Indicates whether to highlight the highest points of data in the sparkline group.
getHighPointColor()	@deprecated. Please use the ‘highPointColor’ property instead. Gets and sets the color of the highest points of data in the sparkline group.
setHighPointColor(CellsColor)	@deprecated. Please use the ‘highPointColor’ property instead. Gets and sets the color of the highest points of data in the sparkline group.
getShowLowPoint()	@deprecated. Please use the ‘showLowPoint’ property instead. Indicates whether to highlight the lowest points of data in the sparkline group.
setShowLowPoint(boolean)	@deprecated. Please use the ‘showLowPoint’ property instead. Indicates whether to highlight the lowest points of data in the sparkline group.
getLowPointColor()	@deprecated. Please use the ’lowPointColor’ property instead. Gets and sets the color of the lowest points of data in the sparkline group.
setLowPointColor(CellsColor)	@deprecated. Please use the ’lowPointColor’ property instead. Gets and sets the color of the lowest points of data in the sparkline group.
getShowNegativePoints()	@deprecated. Please use the ‘showNegativePoints’ property instead. Indicates whether to highlight the negative values on the sparkline group with a different color or marker.
setShowNegativePoints(boolean)	@deprecated. Please use the ‘showNegativePoints’ property instead. Indicates whether to highlight the negative values on the sparkline group with a different color or marker.
getNegativePointsColor()	@deprecated. Please use the ’negativePointsColor’ property instead. Gets and sets the color of the negative values on the sparkline group.
setNegativePointsColor(CellsColor)	@deprecated. Please use the ’negativePointsColor’ property instead. Gets and sets the color of the negative values on the sparkline group.
getShowFirstPoint()	@deprecated. Please use the ‘showFirstPoint’ property instead. Indicates whether to highlight the first point of data in the sparkline group.
setShowFirstPoint(boolean)	@deprecated. Please use the ‘showFirstPoint’ property instead. Indicates whether to highlight the first point of data in the sparkline group.
getFirstPointColor()	@deprecated. Please use the ‘firstPointColor’ property instead. Gets and sets the color of the first point of data in the sparkline group.
setFirstPointColor(CellsColor)	@deprecated. Please use the ‘firstPointColor’ property instead. Gets and sets the color of the first point of data in the sparkline group.
getShowLastPoint()	@deprecated. Please use the ‘showLastPoint’ property instead. Indicates whether to highlight the last point of data in the sparkline group.
setShowLastPoint(boolean)	@deprecated. Please use the ‘showLastPoint’ property instead. Indicates whether to highlight the last point of data in the sparkline group.
getLastPointColor()	@deprecated. Please use the ’lastPointColor’ property instead. Gets and sets the color of the last point of data in the sparkline group.
setLastPointColor(CellsColor)	@deprecated. Please use the ’lastPointColor’ property instead. Gets and sets the color of the last point of data in the sparkline group.
getShowMarkers()	@deprecated. Please use the ‘showMarkers’ property instead. Indicates whether to highlight each point in each line sparkline in the sparkline group.
setShowMarkers(boolean)	@deprecated. Please use the ‘showMarkers’ property instead. Indicates whether to highlight each point in each line sparkline in the sparkline group.
getMarkersColor()	@deprecated. Please use the ‘markersColor’ property instead. Gets and sets the color of points in each line sparkline in the sparkline group.
setMarkersColor(CellsColor)	@deprecated. Please use the ‘markersColor’ property instead. Gets and sets the color of points in each line sparkline in the sparkline group.
getSeriesColor()	@deprecated. Please use the ‘seriesColor’ property instead. Gets and sets the color of the sparklines in the sparkline group.
setSeriesColor(CellsColor)	@deprecated. Please use the ‘seriesColor’ property instead. Gets and sets the color of the sparklines in the sparkline group.
getPlotRightToLeft()	@deprecated. Please use the ‘plotRightToLeft’ property instead. Indicates whether the plot data is right to left.
setPlotRightToLeft(boolean)	@deprecated. Please use the ‘plotRightToLeft’ property instead. Indicates whether the plot data is right to left.
getLineWeight()	@deprecated. Please use the ’lineWeight’ property instead. Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.
setLineWeight(number)	@deprecated. Please use the ’lineWeight’ property instead. Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.
getHorizontalAxisColor()	@deprecated. Please use the ‘horizontalAxisColor’ property instead. Gets and sets the color of the horizontal axis in the sparkline group.
setHorizontalAxisColor(CellsColor)	@deprecated. Please use the ‘horizontalAxisColor’ property instead. Gets and sets the color of the horizontal axis in the sparkline group.
getShowHorizontalAxis()	@deprecated. Please use the ‘showHorizontalAxis’ property instead. Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.
setShowHorizontalAxis(boolean)	@deprecated. Please use the ‘showHorizontalAxis’ property instead. Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.
getHorizontalAxisDateRange()	@deprecated. Please use the ‘horizontalAxisDateRange’ property instead. Represents the range that contains the date values for the sparkline data.
setHorizontalAxisDateRange(string)	@deprecated. Please use the ‘horizontalAxisDateRange’ property instead. Represents the range that contains the date values for the sparkline data.
getVerticalAxisMaxValueType()	@deprecated. Please use the ‘verticalAxisMaxValueType’ property instead. Represents the vertical axis maximum value type.
setVerticalAxisMaxValueType(SparklineAxisMinMaxType)	@deprecated. Please use the ‘verticalAxisMaxValueType’ property instead. Represents the vertical axis maximum value type.
getVerticalAxisMaxValue()	@deprecated. Please use the ‘verticalAxisMaxValue’ property instead. Gets and sets the custom maximum value for the vertical axis.
setVerticalAxisMaxValue(number)	@deprecated. Please use the ‘verticalAxisMaxValue’ property instead. Gets and sets the custom maximum value for the vertical axis.
getVerticalAxisMinValueType()	@deprecated. Please use the ‘verticalAxisMinValueType’ property instead. Represents the vertical axis minimum value type.
setVerticalAxisMinValueType(SparklineAxisMinMaxType)	@deprecated. Please use the ‘verticalAxisMinValueType’ property instead. Represents the vertical axis minimum value type.
getVerticalAxisMinValue()	@deprecated. Please use the ‘verticalAxisMinValue’ property instead. Gets and sets the custom minimum value for the vertical axis.
setVerticalAxisMinValue(number)	@deprecated. Please use the ‘verticalAxisMinValue’ property instead. Gets and sets the custom minimum value for the vertical axis.
resetRanges(string, boolean, CellArea)	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.
isNull()	Checks whether the implementation object is null.

presetStyle

Gets and sets the preset style type of the sparkline group.

presetStyle : SparklinePresetStyleType;

sparklines

Readonly. Gets the collection of Sparkline object.

sparklines : SparklineCollection;

type

Indicates the sparkline type of the sparkline group.

type : SparklineType;

plotEmptyCellsType

Indicates how to plot empty cells.

plotEmptyCellsType : PlotEmptyCellsType;

displayHidden

Indicates whether to show data in hidden rows and columns.

displayHidden : boolean;

showHighPoint

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

showHighPoint : boolean;

highPointColor

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

highPointColor : CellsColor;

showLowPoint

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

showLowPoint : boolean;

lowPointColor

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

lowPointColor : CellsColor;

showNegativePoints

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

showNegativePoints : boolean;

negativePointsColor

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

negativePointsColor : CellsColor;

showFirstPoint

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

showFirstPoint : boolean;

firstPointColor

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

firstPointColor : CellsColor;

showLastPoint

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

showLastPoint : boolean;

lastPointColor

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

lastPointColor : CellsColor;

showMarkers

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

showMarkers : boolean;

markersColor

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

markersColor : CellsColor;

seriesColor

Gets and sets the color of the sparklines in the sparkline group.

seriesColor : CellsColor;

plotRightToLeft

Indicates whether the plot data is right to left.

plotRightToLeft : boolean;

lineWeight

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

lineWeight : number;

horizontalAxisColor

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

horizontalAxisColor : CellsColor;

showHorizontalAxis

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

showHorizontalAxis : boolean;

horizontalAxisDateRange

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

horizontalAxisDateRange : string;

verticalAxisMaxValueType

Represents the vertical axis maximum value type.

verticalAxisMaxValueType : SparklineAxisMinMaxType;

verticalAxisMaxValue

Gets and sets the custom maximum value for the vertical axis.

verticalAxisMaxValue : number;

verticalAxisMinValueType

Represents the vertical axis minimum value type.

verticalAxisMinValueType : SparklineAxisMinMaxType;

verticalAxisMinValue

Gets and sets the custom minimum value for the vertical axis.

verticalAxisMinValue : number;

getPresetStyle()

@deprecated. Please use the ‘presetStyle’ property instead. Gets and sets the preset style type of the sparkline group.

getPresetStyle() : SparklinePresetStyleType;

Returns

SparklinePresetStyleType

setPresetStyle(SparklinePresetStyleType)

@deprecated. Please use the ‘presetStyle’ property instead. Gets and sets the preset style type of the sparkline group.

setPresetStyle(value: SparklinePresetStyleType) : void;

Parameters:

Parameter	Type	Description
value	SparklinePresetStyleType	The value to set.

getSparklines()

@deprecated. Please use the ‘sparklines’ property instead. Gets the collection of Sparkline object.

getSparklines() : SparklineCollection;

Returns

SparklineCollection

getType()

@deprecated. Please use the ’type’ property instead. Indicates the sparkline type of the sparkline group.

getType() : SparklineType;

Returns

SparklineType

setType(SparklineType)

@deprecated. Please use the ’type’ property instead. Indicates the sparkline type of the sparkline group.

setType(value: SparklineType) : void;

Parameters:

Parameter	Type	Description
value	SparklineType	The value to set.

getPlotEmptyCellsType()

@deprecated. Please use the ‘plotEmptyCellsType’ property instead. Indicates how to plot empty cells.

getPlotEmptyCellsType() : PlotEmptyCellsType;

Returns

PlotEmptyCellsType

setPlotEmptyCellsType(PlotEmptyCellsType)

@deprecated. Please use the ‘plotEmptyCellsType’ property instead. Indicates how to plot empty cells.

setPlotEmptyCellsType(value: PlotEmptyCellsType) : void;

Parameters:

Parameter	Type	Description
value	PlotEmptyCellsType	The value to set.

getDisplayHidden()

@deprecated. Please use the ‘displayHidden’ property instead. Indicates whether to show data in hidden rows and columns.

getDisplayHidden() : boolean;

setDisplayHidden(boolean)

@deprecated. Please use the ‘displayHidden’ property instead. Indicates whether to show data in hidden rows and columns.

setDisplayHidden(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getShowHighPoint()

@deprecated. Please use the ‘showHighPoint’ property instead. Indicates whether to highlight the highest points of data in the sparkline group.

getShowHighPoint() : boolean;

setShowHighPoint(boolean)

@deprecated. Please use the ‘showHighPoint’ property instead. Indicates whether to highlight the highest points of data in the sparkline group.

setShowHighPoint(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getHighPointColor()

@deprecated. Please use the ‘highPointColor’ property instead. Gets and sets the color of the highest points of data in the sparkline group.

getHighPointColor() : CellsColor;

Returns

CellsColor

setHighPointColor(CellsColor)

@deprecated. Please use the ‘highPointColor’ property instead. Gets and sets the color of the highest points of data in the sparkline group.

setHighPointColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowLowPoint()

@deprecated. Please use the ‘showLowPoint’ property instead. Indicates whether to highlight the lowest points of data in the sparkline group.

getShowLowPoint() : boolean;

setShowLowPoint(boolean)

@deprecated. Please use the ‘showLowPoint’ property instead. Indicates whether to highlight the lowest points of data in the sparkline group.

setShowLowPoint(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getLowPointColor()

@deprecated. Please use the ’lowPointColor’ property instead. Gets and sets the color of the lowest points of data in the sparkline group.

getLowPointColor() : CellsColor;

Returns

CellsColor

setLowPointColor(CellsColor)

@deprecated. Please use the ’lowPointColor’ property instead. Gets and sets the color of the lowest points of data in the sparkline group.

setLowPointColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowNegativePoints()

@deprecated. Please use the ‘showNegativePoints’ property instead. Indicates whether to highlight the negative values on the sparkline group with a different color or marker.

getShowNegativePoints() : boolean;

setShowNegativePoints(boolean)

@deprecated. Please use the ‘showNegativePoints’ property instead. Indicates whether to highlight the negative values on the sparkline group with a different color or marker.

setShowNegativePoints(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getNegativePointsColor()

@deprecated. Please use the ’negativePointsColor’ property instead. Gets and sets the color of the negative values on the sparkline group.

getNegativePointsColor() : CellsColor;

Returns

CellsColor

setNegativePointsColor(CellsColor)

@deprecated. Please use the ’negativePointsColor’ property instead. Gets and sets the color of the negative values on the sparkline group.

setNegativePointsColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowFirstPoint()

@deprecated. Please use the ‘showFirstPoint’ property instead. Indicates whether to highlight the first point of data in the sparkline group.

getShowFirstPoint() : boolean;

setShowFirstPoint(boolean)

@deprecated. Please use the ‘showFirstPoint’ property instead. Indicates whether to highlight the first point of data in the sparkline group.

setShowFirstPoint(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getFirstPointColor()

@deprecated. Please use the ‘firstPointColor’ property instead. Gets and sets the color of the first point of data in the sparkline group.

getFirstPointColor() : CellsColor;

Returns

CellsColor

setFirstPointColor(CellsColor)

@deprecated. Please use the ‘firstPointColor’ property instead. Gets and sets the color of the first point of data in the sparkline group.

setFirstPointColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowLastPoint()

@deprecated. Please use the ‘showLastPoint’ property instead. Indicates whether to highlight the last point of data in the sparkline group.

getShowLastPoint() : boolean;

setShowLastPoint(boolean)

@deprecated. Please use the ‘showLastPoint’ property instead. Indicates whether to highlight the last point of data in the sparkline group.

setShowLastPoint(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getLastPointColor()

@deprecated. Please use the ’lastPointColor’ property instead. Gets and sets the color of the last point of data in the sparkline group.

getLastPointColor() : CellsColor;

Returns

CellsColor

setLastPointColor(CellsColor)

@deprecated. Please use the ’lastPointColor’ property instead. Gets and sets the color of the last point of data in the sparkline group.

setLastPointColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowMarkers()

@deprecated. Please use the ‘showMarkers’ property instead. Indicates whether to highlight each point in each line sparkline in the sparkline group.

getShowMarkers() : boolean;

setShowMarkers(boolean)

@deprecated. Please use the ‘showMarkers’ property instead. Indicates whether to highlight each point in each line sparkline in the sparkline group.

setShowMarkers(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getMarkersColor()

@deprecated. Please use the ‘markersColor’ property instead. Gets and sets the color of points in each line sparkline in the sparkline group.

getMarkersColor() : CellsColor;

Returns

CellsColor

setMarkersColor(CellsColor)

@deprecated. Please use the ‘markersColor’ property instead. Gets and sets the color of points in each line sparkline in the sparkline group.

setMarkersColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getSeriesColor()

@deprecated. Please use the ‘seriesColor’ property instead. Gets and sets the color of the sparklines in the sparkline group.

getSeriesColor() : CellsColor;

Returns

CellsColor

setSeriesColor(CellsColor)

@deprecated. Please use the ‘seriesColor’ property instead. Gets and sets the color of the sparklines in the sparkline group.

setSeriesColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getPlotRightToLeft()

@deprecated. Please use the ‘plotRightToLeft’ property instead. Indicates whether the plot data is right to left.

getPlotRightToLeft() : boolean;

setPlotRightToLeft(boolean)

@deprecated. Please use the ‘plotRightToLeft’ property instead. Indicates whether the plot data is right to left.

setPlotRightToLeft(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getLineWeight()

@deprecated. Please use the ’lineWeight’ property instead. Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.

getLineWeight() : number;

setLineWeight(number)

@deprecated. Please use the ’lineWeight’ property instead. Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.

setLineWeight(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getHorizontalAxisColor()

@deprecated. Please use the ‘horizontalAxisColor’ property instead. Gets and sets the color of the horizontal axis in the sparkline group.

getHorizontalAxisColor() : CellsColor;

Returns

CellsColor

setHorizontalAxisColor(CellsColor)

@deprecated. Please use the ‘horizontalAxisColor’ property instead. Gets and sets the color of the horizontal axis in the sparkline group.

setHorizontalAxisColor(value: CellsColor) : void;

Parameters:

Parameter	Type	Description
value	CellsColor	The value to set.

getShowHorizontalAxis()

@deprecated. Please use the ‘showHorizontalAxis’ property instead. Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.

getShowHorizontalAxis() : boolean;

setShowHorizontalAxis(boolean)

@deprecated. Please use the ‘showHorizontalAxis’ property instead. Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis.

setShowHorizontalAxis(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getHorizontalAxisDateRange()

@deprecated. Please use the ‘horizontalAxisDateRange’ property instead. Represents the range that contains the date values for the sparkline data.

getHorizontalAxisDateRange() : string;

setHorizontalAxisDateRange(string)

@deprecated. Please use the ‘horizontalAxisDateRange’ property instead. Represents the range that contains the date values for the sparkline data.

setHorizontalAxisDateRange(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

getVerticalAxisMaxValueType()

@deprecated. Please use the ‘verticalAxisMaxValueType’ property instead. Represents the vertical axis maximum value type.

getVerticalAxisMaxValueType() : SparklineAxisMinMaxType;

Returns

SparklineAxisMinMaxType

setVerticalAxisMaxValueType(SparklineAxisMinMaxType)

@deprecated. Please use the ‘verticalAxisMaxValueType’ property instead. Represents the vertical axis maximum value type.

setVerticalAxisMaxValueType(value: SparklineAxisMinMaxType) : void;

Parameters:

Parameter	Type	Description
value	SparklineAxisMinMaxType	The value to set.

getVerticalAxisMaxValue()

@deprecated. Please use the ‘verticalAxisMaxValue’ property instead. Gets and sets the custom maximum value for the vertical axis.

getVerticalAxisMaxValue() : number;

setVerticalAxisMaxValue(number)

@deprecated. Please use the ‘verticalAxisMaxValue’ property instead. Gets and sets the custom maximum value for the vertical axis.

setVerticalAxisMaxValue(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getVerticalAxisMinValueType()

@deprecated. Please use the ‘verticalAxisMinValueType’ property instead. Represents the vertical axis minimum value type.

getVerticalAxisMinValueType() : SparklineAxisMinMaxType;

Returns

SparklineAxisMinMaxType

setVerticalAxisMinValueType(SparklineAxisMinMaxType)

@deprecated. Please use the ‘verticalAxisMinValueType’ property instead. Represents the vertical axis minimum value type.

setVerticalAxisMinValueType(value: SparklineAxisMinMaxType) : void;

Parameters:

Parameter	Type	Description
value	SparklineAxisMinMaxType	The value to set.

getVerticalAxisMinValue()

@deprecated. Please use the ‘verticalAxisMinValue’ property instead. Gets and sets the custom minimum value for the vertical axis.

getVerticalAxisMinValue() : number;

setVerticalAxisMinValue(number)

@deprecated. Please use the ‘verticalAxisMinValue’ property instead. Gets and sets the custom minimum value for the vertical axis.

setVerticalAxisMinValue(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

resetRanges(string, boolean, CellArea)

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.

resetRanges(dataRange: string, isVertical: boolean, locationRange: CellArea) : void;

Parameters:

Parameter	Type	Description
dataRange	string	Specifies the new data range of the sparkline group.
isVertical	boolean	Specifies whether to plot the sparklines from the new data range by row or by column.
locationRange	CellArea	Specifies where the sparklines to be placed.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;