Class Hex2Dec
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.Hex2Dec
- All Implemented Interfaces:
FreeRefFunction
,Function
,Function1Arg
Implementation for Excel HEX2DEC() function.
Syntax:
HEX2DEC (number)
Converts a hexadecimal number to decimal.
Number is the hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation. Remark If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.
- Author:
- cedric dot walter @ gmail dot com
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction
evaluate
-
Field Details
-
instance
-
-
Constructor Details
-
Hex2Dec
public Hex2Dec()
-
-
Method Details
-
evaluate
Description copied from interface:Function1Arg
- Specified by:
evaluate
in interfaceFunction1Arg
-
evaluate
- Specified by:
evaluate
in interfaceFreeRefFunction
- Parameters:
args
- the pre-evaluated arguments for this function. args is nevernull
, nor are any of its elements.ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.- Returns:
- never
null
. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
-