ValidationOperator

Enum Class ValidationOperator

java.lang.Object

java.lang.Enum<ValidationOperator>

com.grapecity.documents.excel.ValidationOperator

All Implemented Interfaces:

Serializable, Comparable<ValidationOperator>, Constable

---

public enum ValidationOperator extends Enum<ValidationOperator>

指定数据验证用于将公式与单元格值比较的运算符；对于 Between 和 NotBetween，则用于比较两个公式。

将此枚举与 IValidation 一起使用，以定义验证规则如何计算输入。Between 和 NotBetween 需要两个公式参数，而其他运算符只使用第一个公式。

 IRange range = worksheet.getRange("A1");
 range.getValidation().add(
     ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 1, 10);
 

• Nested Class Summary

  Nested classes/interfaces inherited from class java.lang.Enum

  Enum.EnumDesc<E extends Enum<E>>

• Enum Constant Summary

  Enum Constants

  Enum Constant

  Description

  Between

  指定之间。只有提供两个公式时才能使用。

  Equal

  指定相等。

  Greater

  指定大于。

  GreaterEqual

  指定大于或等于。

  Less

  指定小于。

  LessEqual

  指定小于或等于。

  NotBetween

  指定不在两者之间。仅当提供两个公式时才能使用。

  NotEqual

  指定不等于。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static ValidationOperator

  valueOf(String name)

  Returns the enum constant of this class with the specified name.

  static ValidationOperator[]

  values()

  Returns an array containing the constants of this enum class, in the order they are declared.

  Methods inherited from class java.lang.Enum

  clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

  Methods inherited from class java.lang.Object

  getClass, notify, notifyAll, wait, wait, wait

• Enum Constant Details

  • Between

    public static final ValidationOperator Between

    指定之间。只有提供两个公式时才能使用。

  • NotBetween

    public static final ValidationOperator NotBetween

    指定不在两者之间。仅当提供两个公式时才能使用。

  • Equal

    public static final ValidationOperator Equal

    指定相等。

  • NotEqual

    public static final ValidationOperator NotEqual

    指定不等于。

  • Greater

    public static final ValidationOperator Greater

    指定大于。

  • Less

    public static final ValidationOperator Less

    指定小于。

  • GreaterEqual

    public static final ValidationOperator GreaterEqual

    指定大于或等于。

  • LessEqual

    public static final ValidationOperator LessEqual

    指定小于或等于。

• Method Details

  • values

    public static ValidationOperator[] 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

    public static ValidationOperator valueOf(String name)

    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 name

    NullPointerException - if the argument is null