AboveBelow

Enum Class AboveBelow

java.lang.Object

java.lang.Enum<AboveBelow>

com.grapecity.documents.excel.AboveBelow

All Implemented Interfaces:

Serializable, Comparable<AboveBelow>, Constable

---

public enum AboveBelow extends Enum<AboveBelow>

指定规则如何根据平均值或标准差来评估值。

此枚举与 IAboveAverage.setAboveBelow(AboveBelow) 一起使用，用于控制规则是匹配高于平均值、低于平均值、大于或等于平均值、小于或等于平均值，还是高于或低于标准差的值。

 worksheet.getRange("A1:A5").setValue(new Object[][] {
     {10}, {20}, {30}, {40}, {100}
 });
 IAboveAverage averageCondition = worksheet.getRange("A1:A5").getFormatConditions().addAboveAverage();
 averageCondition.setAboveBelow(AboveBelow.AboveAverage);
 averageCondition.getInterior().setColor(Color.GetYellow());
 

• 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

  AboveAverage

  指定高于平均值。

  AboveStdDev

  指定高于标准差。

  BelowAverage

  指定低于平均值。

  BelowStdDev

  指定低于标准差。

  EqualAboveAverage

  指定等于或高于平均值。

  EqualBelowAverage

  指定等于或低于平均值。

• Method Summary

  All MethodsStatic MethodsConcrete Methods

  Modifier and Type

  Method

  Description

  static AboveBelow

  valueOf(String name)

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

  static AboveBelow[]

  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

  • AboveAverage

    public static final AboveBelow AboveAverage

    指定高于平均值。

  • BelowAverage

    public static final AboveBelow BelowAverage

    指定低于平均值。

  • EqualAboveAverage

    public static final AboveBelow EqualAboveAverage

    指定等于或高于平均值。

  • EqualBelowAverage

    public static final AboveBelow EqualBelowAverage

    指定等于或低于平均值。

  • AboveStdDev

    public static final AboveBelow AboveStdDev

    指定高于标准差。

  • BelowStdDev

    public static final AboveBelow BelowStdDev

    指定低于标准差。

• Method Details

  • values

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