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

PrintErrors

Enum Class PrintErrors

java.lang.Object
java.lang.Enum<PrintErrors>
com.grapecity.documents.excel.PrintErrors
All Implemented Interfaces:
Serializable, Comparable<PrintErrors>, Constable
public enum PrintErrors extends Enum<PrintErrors>
Specifies how cell error values are printed on a worksheet.

Use this enum with IPageSetup.setPrintErrors(PrintErrors) to control whether printed output shows error values as they appear, suppresses them, or replaces them with an alternate display. It applies when printing a worksheet that contains formula errors such as division by zero or unavailable values.


 worksheet.getRange("A1").setFormula("=1/0");
 worksheet.getPageSetup().setPrintErrors(PrintErrors.Dash);
 PrintErrors printErrors = worksheet.getPageSetup().getPrintErrors();

  • Enum Constant Details

    • Displayed

      public static final PrintErrors Displayed
      All print errors are displayed.

    • Blank

      public static final PrintErrors Blank
      Print errors are blank.

    • Dash

      public static final PrintErrors Dash
      Print errors are displayed as dashes.

    • NA

      public static final PrintErrors NA
      Print errors are displayed as not available.

  • Method Details

    • values

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

    • getValue

      public int getValue()
      Gets the integer value of this enum member.
      Returns:
      The zero-based integer value of this enum member.

    • forValue

      public static PrintErrors forValue(int value)
      Gets the enum member for the specified integer value.
      Parameters:
      value - The zero-based integer value.
      Returns:
      The matching PrintErrors member.