-
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
SortOnType
Enum Class SortOnType
- All Implemented Interfaces:
Serializable,Comparable<SortOnType>,Constable
Specifies the criterion used to sort data.
Use this enum to identify whether a sort field orders data by cell values, cell color, font color, or cell icons. It is commonly returned by ISortField.getSortOn() to describe how a sort field evaluates the target range.
worksheet.getRange("A1:A3").setValue(new Object[][] {
{"Name"},
{"Bob"},
{"Alice"}
});
IValueSortField sortField = new ValueSortField(worksheet.getRange("A1:A3"), SortOrder.Ascending);
if (sortField.getSortOn() == SortOnType.Values) {
worksheet.getRange("A1:A3").sort(SortOrientation.Columns, false, sortField);
}
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum Constants -
Method Summary
Modifier and TypeMethodDescriptionstatic SortOnTypeReturns the enum constant of this class with the specified name.static SortOnType[]values()Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
Values
Specifies that sorting is based on cell values. -
CellColor
Specifies that data is sorted based on cell color. -
FontColor
Specifies that data is sorted by font color. -
CellIcon
Specifies that data is sorted based on cell icons.
-
-
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
-