org.zkoss.poi.ss.usermodel

Class ErrorConstants

java.lang.Object

org.zkoss.poi.ss.usermodel.ErrorConstants

Direct Known Subclasses:

HSSFErrorConstants

public class ErrorConstants
extends java.lang.Object

Contains raw Excel error codes (as defined in OOO's excelfileformat.pdf (2.5.6)

Author:

Michael Harhen

Field Summary

Fields

Modifier and Type	Field and Description
static int	ERROR_DIV_0 #DIV/0!
static int	ERROR_FORMULA
static int	ERROR_NA #N/A - Argument or function not available
static int	ERROR_NAME #NAME?
static int	ERROR_NULL #NULL!
static int	ERROR_NUM #NUM!
static int	ERROR_REF #REF!
static int	ERROR_VALUE #VALUE!

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	ErrorConstants()

Method Summary

Modifier and Type	Method and Description
static java.lang.String	getText(int errorCode)
static boolean	isValidCode(int errorCode)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ERROR_NULL

public static final int ERROR_NULL

#NULL! - Intersection of two cell ranges is empty

See Also:

Constant Field Values

ERROR_DIV_0

public static final int ERROR_DIV_0

#DIV/0! - Division by zero

See Also:

Constant Field Values

ERROR_VALUE

public static final int ERROR_VALUE

#VALUE! - Wrong type of operand

See Also:

Constant Field Values

ERROR_REF

public static final int ERROR_REF

#REF! - Illegal or deleted cell reference

See Also:

Constant Field Values

ERROR_NAME

public static final int ERROR_NAME

#NAME? - Wrong function or range name

See Also:

Constant Field Values

ERROR_NUM

public static final int ERROR_NUM

#NUM! - Value range overflow

See Also:

Constant Field Values

ERROR_NA

public static final int ERROR_NA

#N/A - Argument or function not available

See Also:

Constant Field Values

ERROR_FORMULA

public static final int ERROR_FORMULA

See Also:

Constant Field Values

Constructor Detail

ErrorConstants

protected ErrorConstants()

Method Detail

getText

public static final java.lang.String getText(int errorCode)

Returns:

Standard Excel error literal for the specified error code.

Throws:

java.lang.IllegalArgumentException - if the specified error code is not one of the 7 standard error codes

isValidCode

public static final boolean isValidCode(int errorCode)

Returns:

true if the specified error code is a standard Excel error code.