-
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
LabelAlignment
Enum Class LabelAlignment
- All Implemented Interfaces:
Serializable,Comparable<LabelAlignment>,Constable
Specifies the position of a cell label within a range.
Use this enum with ILabelOptions.setAlignment(LabelAlignment) to place a cell label at the top or bottom of the cell area, aligned to the left, center, or right.
IRange range = worksheet.getRange("A1");
range.setCellPadding(new CellPadding(10,0, 0,0));
range.setWatermark("Student Name");
range.getLabelOptions().getFont().setSize(7);
range.getLabelOptions().setAlignment(LabelAlignment.topCenter);
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionIndicates that the cell label position is bottom-center.Indicates that the cell label position is bottom-left.Indicates that the cell label position is bottom-right.Indicates that the cell label position is top-center.Indicates that the cell label position is top-left.Indicates that the cell label position is top-right. -
Method Summary
Modifier and TypeMethodDescriptionstatic LabelAlignmentgetLabelAlignment(int value) Returns the label position associated with the specified integer value.intgetValue()Gets the integer value of the label alignment.static LabelAlignmentReturns the enum constant of this class with the specified name.static LabelAlignment[]values()Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
topLeft
Indicates that the cell label position is top-left. -
topCenter
Indicates that the cell label position is top-center. -
topRight
Indicates that the cell label position is top-right. -
bottomLeft
Indicates that the cell label position is bottom-left. -
bottomCenter
Indicates that the cell label position is bottom-center. -
bottomRight
Indicates that the cell label position is bottom-right.
-
-
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
-
getValue
public int getValue()Gets the integer value of the label alignment.- Returns:
- The integer value of the label alignment.
-
getLabelAlignment
Returns the label position associated with the specified integer value.Use this method to convert a stored or serialized label alignment value to its corresponding
LabelAlignmentenum constant.worksheet.getRange("A1").setWatermark("Student Name"); int alignmentValue = 4; LabelAlignment alignment = LabelAlignment.getLabelAlignment(alignmentValue); worksheet.getRange("A1").getLabelOptions().setAlignment(alignment);- Parameters:
value- The integer value representing the label position.- Returns:
- The
LabelAlignmentenum constant associated with the specified value, ornullif no match is found.
-