[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

ReferenceStyle

Enum Class ReferenceStyle

java.lang.Object
java.lang.Enum<ReferenceStyle>
com.grapecity.documents.excel.ReferenceStyle
All Implemented Interfaces:
Serializable, Comparable<ReferenceStyle>, Constable
public enum ReferenceStyle extends Enum<ReferenceStyle>
Specifies the cell reference style used in a workbook.

Use this enum with Workbook.setReferenceStyle(ReferenceStyle) to control whether formulas and references use A1 notation or R1C1 notation.


 workbook.setReferenceStyle(ReferenceStyle.R1C1);
 worksheet.getRange("A1").setFormula("=R[1]C[1]");

  • Enum Constant Details

    • A1

      public static final ReferenceStyle A1
      Specifies to use A1 style. Absolute references are written as $A$1 and relative references are written as A1.

    • R1C1

      public static final ReferenceStyle R1C1
      Specifies the R1C1 reference style for cell references.

      Absolute references are written as R1C1. Relative references are written as R[y]C[x], where y is the relative row offset and x is the relative column offset.

  • Method Details

    • values

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