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