Property Getters/Setters Summary | ||
---|---|---|
function | getDisplayHidden() | |
function | setDisplayHidden(value) | |
Indicates whether to show data in hidden rows and columns. | ||
function | getFirstPointColor() | |
function | setFirstPointColor(value) | |
Gets and sets the color of the first point of data in the sparkline group. | ||
function | getHighPointColor() | |
function | setHighPointColor(value) | |
Gets and sets the color of the highest points of data in the sparkline group. | ||
function | getHorizontalAxisColor() | |
function | setHorizontalAxisColor(value) | |
Gets and sets the color of the horizontal axis in the sparkline group. | ||
function | getHorizontalAxisDateRange() | |
function | setHorizontalAxisDateRange(value) | |
Represents the range that contains the date values for the sparkline data. | ||
function | getLastPointColor() | |
function | setLastPointColor(value) | |
Gets and sets the color of the last point of data in the sparkline group. | ||
function | getLineWeight() | |
function | setLineWeight(value) | |
Gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points. | ||
function | getLowPointColor() | |
function | setLowPointColor(value) | |
Gets and sets the color of the lowest points of data in the sparkline group. | ||
function | getMarkersColor() | |
function | setMarkersColor(value) | |
Gets and sets the color of points in each line sparkline in the sparkline group. | ||
function | getNegativePointsColor() | |
function | setNegativePointsColor(value) | |
Gets and sets the color of the negative values on the sparkline group. | ||
function | getPlotEmptyCellsType() | |
function | setPlotEmptyCellsType(value) | |
Indicates how to plot empty cells. The value of the property is PlotEmptyCellsType integer constant. | ||
function | getPlotRightToLeft() | |
function | setPlotRightToLeft(value) | |
Indicates whether the plot data is right to left. | ||
function | getPresetStyle() | |
function | setPresetStyle(value) | |
Gets and sets the preset style type of the sparkline group. The value of the property is SparklinePresetStyleType integer constant. | ||
function | getSeriesColor() | |
function | setSeriesColor(value) | |
Gets and sets the color of the sparklines in the sparkline group. | ||
function | getShowFirstPoint() | |
function | setShowFirstPoint(value) | |
Indicates whether to highlight the first point of data in the sparkline group. | ||
function | getShowHighPoint() | |
function | setShowHighPoint(value) | |
Indicates whether to highlight the highest points of data in the sparkline group. | ||
function | getShowHorizontalAxis() | |
function | setShowHorizontalAxis(value) | |
Indicates whether to show the sparkline horizontal axis. The horizontal axis appears if the sparkline has data that crosses the zero axis. | ||
function | getShowLastPoint() | |
function | setShowLastPoint(value) | |
Indicates whether to highlight the last point of data in the sparkline group. | ||
function | getShowLowPoint() | |
function | setShowLowPoint(value) | |
Indicates whether to highlight the lowest points of data in the sparkline group. | ||
function | getShowMarkers() | |
function | setShowMarkers(value) | |
Indicates whether to highlight each point in each line sparkline in the sparkline group. | ||
function | getShowNegativePoints() | |
function | setShowNegativePoints(value) | |
Indicates whether to highlight the negative values on the sparkline group with a different color or marker. | ||
function | getSparklineCollection() | |
Gets the |
||
function | getType() | |
function | setType(value) | |
Indicates the sparkline type of the sparkline group. The value of the property is SparklineType integer constant. | ||
function | getVerticalAxisMaxValue() | |
function | setVerticalAxisMaxValue(value) | |
Gets and sets the custom maximum value for the vertical axis. | ||
function | getVerticalAxisMaxValueType() | |
function | setVerticalAxisMaxValueType(value) | |
Represents the vertical axis maximum value type. The value of the property is SparklineAxisMinMaxType integer constant. | ||
function | getVerticalAxisMinValue() | |
function | setVerticalAxisMinValue(value) | |
Gets and sets the custom minimum value for the vertical axis. | ||
function | getVerticalAxisMinValueType() | |
function | setVerticalAxisMinValueType(value) | |
Represents the vertical axis minimum value type. The value of the property is SparklineAxisMinMaxType integer constant. |
Method Summary | ||
---|---|---|
function | resetRanges(dataRange, isVertical, locationRange) | |
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. |
Property Getters/Setters Detail |
---|
getPresetStyle/setPresetStyle : Number | |
function getPresetStyle() / function setPresetStyle(value) |
getSparklineCollection : SparklineCollection | |
function getSparklineCollection() |
getType/setType : Number | |
function getType() / function setType(value) |
getPlotEmptyCellsType/setPlotEmptyCellsType : Number | |
function getPlotEmptyCellsType() / function setPlotEmptyCellsType(value) |
getDisplayHidden/setDisplayHidden : boolean | |
function getDisplayHidden() / function setDisplayHidden(value) |
getShowHighPoint/setShowHighPoint : boolean | |
function getShowHighPoint() / function setShowHighPoint(value) |
getHighPointColor/setHighPointColor : CellsColor | |
function getHighPointColor() / function setHighPointColor(value) |
getShowLowPoint/setShowLowPoint : boolean | |
function getShowLowPoint() / function setShowLowPoint(value) |
getLowPointColor/setLowPointColor : CellsColor | |
function getLowPointColor() / function setLowPointColor(value) |
getShowNegativePoints/setShowNegativePoints : boolean | |
function getShowNegativePoints() / function setShowNegativePoints(value) |
getNegativePointsColor/setNegativePointsColor : CellsColor | |
function getNegativePointsColor() / function setNegativePointsColor(value) |
getShowFirstPoint/setShowFirstPoint : boolean | |
function getShowFirstPoint() / function setShowFirstPoint(value) |
getFirstPointColor/setFirstPointColor : CellsColor | |
function getFirstPointColor() / function setFirstPointColor(value) |
getShowLastPoint/setShowLastPoint : boolean | |
function getShowLastPoint() / function setShowLastPoint(value) |
getLastPointColor/setLastPointColor : CellsColor | |
function getLastPointColor() / function setLastPointColor(value) |
getShowMarkers/setShowMarkers : boolean | |
function getShowMarkers() / function setShowMarkers(value) |
getMarkersColor/setMarkersColor : CellsColor | |
function getMarkersColor() / function setMarkersColor(value) |
getSeriesColor/setSeriesColor : CellsColor | |
function getSeriesColor() / function setSeriesColor(value) |
getPlotRightToLeft/setPlotRightToLeft : boolean | |
function getPlotRightToLeft() / function setPlotRightToLeft(value) |
getLineWeight/setLineWeight : Number | |
function getLineWeight() / function setLineWeight(value) |
getHorizontalAxisColor/setHorizontalAxisColor : CellsColor | |
function getHorizontalAxisColor() / function setHorizontalAxisColor(value) |
getShowHorizontalAxis/setShowHorizontalAxis : boolean | |
function getShowHorizontalAxis() / function setShowHorizontalAxis(value) |
getHorizontalAxisDateRange/setHorizontalAxisDateRange : String | |
function getHorizontalAxisDateRange() / function setHorizontalAxisDateRange(value) |
getVerticalAxisMaxValueType/setVerticalAxisMaxValueType : Number | |
function getVerticalAxisMaxValueType() / function setVerticalAxisMaxValueType(value) |
getVerticalAxisMaxValue/setVerticalAxisMaxValue : Number | |
function getVerticalAxisMaxValue() / function setVerticalAxisMaxValue(value) |
getVerticalAxisMinValueType/setVerticalAxisMinValueType : Number | |
function getVerticalAxisMinValueType() / function setVerticalAxisMinValueType(value) |
getVerticalAxisMinValue/setVerticalAxisMinValue : Number | |
function getVerticalAxisMinValue() / function setVerticalAxisMinValue(value) |
Method Detail |
---|
resetRanges | |
function resetRanges(dataRange, isVertical, locationRange) |
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.