-
com.grapecity.documents.excel
- Classes
-
Enum Classes
- AboveBelow
- AutoFilterOperator
- AutoMergeDirection
- AutoMergeMode
- AutoMergeSelectionMode
- BackgroundImageLayout
- BarcodeType
- BorderLineStyle
- BordersIndex
- CalcError
- CalculationMode
- CellAttribute
- CellControlType
- CellTypeDirection
- CellTypeTextAlign
- CheckBoxAlign
- ColorDataIndex
- ColorScaleType
- ConditionValueTypes
- ConsolidationFunction
- ContainsOperator
- CornerPosition
- CssExportType
- DataBarAxisPosition
- DataBarBorderType
- DataBarDirection
- DataBarFillType
- DataBarNegativeColorType
- DeleteShiftDirection
- Direction
- DisplayBlanksAs
- DupeUnique
- DynamicFilterType
- EccMode
- EditorValueType
- ErrorCorrectionLevel
- FindLookIn
- FontLanguageIndex
- FormatConditionOperator
- FormatConditionType
- FunctionValueType
- GradientFillType
- HorizontalAlignment
- HyperLinkTargetType
- IconPosition
- IconSetType
- IconType
- IgnoredErrorType
- IMEModeType
- ImportFlags
- InsertShiftDirection
- InsufficientSpaceHandling
- InvalidFormulaHandling
- LabelAlignment
- LabelVisibility
- LayoutFormType
- LayoutRowType
- LookAt
- NumbersFitMode
- OpenFileFormat
- Order
- PageBreakExtent
- PageOrientation
- PaginationOrientation
- PaperSize
- PasteType
- Pattern
- PivotCellType
- PivotFieldCalculation
- PivotFieldDateGroupBy
- PivotFieldOrientation
- PivotFieldRepeatLabels
- PivotFilterType
- PivotLineType
- PrintErrors
- PrintLocation
- PrintQuality
- PropertyType
- ReadingOrder
- ReferenceStyle
- SaveFileFormat
- SearchDirection
- SearchOrder
- SheetTabType
- SheetType
- SlicerSortOrder
- SortDataOption
- SortOnType
- SortOrder
- SortOrientation
- SparklineRowCol
- SparkScale
- SparkType
- SpecialCellType
- SpreadJSTabStripPosition
- SubtotalLocationType
- SubtotalType
- SummaryColumn
- SummaryRow
- TableStyleElementType
- ThemeColor
- ThemeFont
- TimePeriods
- TopBottom
- TotalsCalculation
- UnderlineType
- UsedRangeType
- ValidationAlertStyle
- ValidationOperator
- ValidationType
- ValueQuoteType
- VerticalAlignment
- ViewType
- Visibility
- Exceptions
- Interfaces
- com.grapecity.documents.excel.drawing
- com.grapecity.documents.excel.expressions
- com.grapecity.documents.excel.forms
- com.grapecity.documents.excel.template
- com.grapecity.documents.excel.template.DataSource
SparklineRowCol
Enum Class SparklineRowCol
- All Implemented Interfaces:
Serializable,Comparable<SparklineRowCol>,Constable
Specifies how sparklines are plotted when the source data is in a square-shaped range.
Used with ISparklineGroup.getPlotBy() and ISparklineGroup.setPlotBy(SparklineRowCol) to control whether sparkline data is plotted by rows or columns.
worksheet.getRange("A1:C3").setValue(new Object[][] {
{1, 2, 3},
{4, 5, 6},
{7, 8, 9}
});
ISparklineGroup group = worksheet.getRange("D1:D3").getSparklineGroups().add(SparkType.Line, "A1:C3");
group.setPlotBy(SparklineRowCol.RowsSquare);
SparklineRowCol plotBy = group.getPlotBy();
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionSpecifies to plot the data by columns.Specifies that the sparkline is not bound to data in a square-shaped range.Specifies to plot the data by rows. -
Method Summary
Modifier and TypeMethodDescriptionstatic SparklineRowColReturns the enum constant of this class with the specified name.static SparklineRowCol[]values()Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
NonSquare
Specifies that the sparkline is not bound to data in a square-shaped range. -
RowsSquare
Specifies to plot the data by rows. -
ColumnsSquare
Specifies to plot the data by columns.
-
-
Method Details
-
values
Returns an array containing the constants of this enum class, in the order they are declared.- Returns:
- an array containing the constants of this enum class, in the order they are declared
-
valueOf
Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)- Parameters:
name- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException- if this enum class has no constant with the specified nameNullPointerException- if the argument is null
-