-
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
FindLookIn
Enum Class FindLookIn
- All Implemented Interfaces:
Serializable,Comparable<FindLookIn>,Constable
Specifies the type of data to search in when using
IRange.find(Object,IRange,FindOptions). Used with FindOptions.setLookIn(FindLookIn) to control where the find operation searches: formulas, displayed text, raw values, or comments.
worksheet.getRange("A1").setValue("Hello");
worksheet.getRange("A2").setFormula("=A1");
worksheet.getRange("A3").addComment("review this");
IRange searchRange = worksheet.getRange("A1:A3");
FindOptions options = new FindOptions();
options.setLookIn(FindLookIn.Formulas);
IRange found = searchRange.find("A1", null, options);
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionSearches in comments.Searches in formulas.Searches in formulas.Searches in texts.Searches in Texts.Performs type sensitive search in values. -
Method Summary
Modifier and TypeMethodDescriptionstatic FindLookInforValue(int value) Gets the search target that corresponds to the specified ordinal value.intgetValue()Gets the ordinal value of this search target.static FindLookInReturns the enum constant of this class with the specified name.static FindLookIn[]values()Returns an array containing the constants of this enum class, in the order they are declared.
-
Enum Constant Details
-
Formulas
Searches in formulas. -
Texts
Searches in texts. -
Values
Performs type sensitive search in values. Supports double, string (Wildcard match is disabled), Date, bool, Calendar, and CalcError. -
Comments
Searches in comments. -
OnlyFormulas
Searches in formulas. If the HasFormula property of a cell is false, the cell will be skipped. -
TextsExcludeFormulaCell
Searches in Texts. If the HasFormula property of a cell is true, the cell will be skipped.
-
-
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 ordinal value of this search target.- Returns:
- The ordinal value.
-
forValue
Gets the search target that corresponds to the specified ordinal value.- Parameters:
value- The ordinal value.- Returns:
- The matching search target.
-