Class Dec2Hex
java.lang.Object
org.apache.poi.ss.formula.functions.Dec2Hex
- All Implemented Interfaces:
FreeRefFunction
,Function
,Function1Arg
,Function2Arg
Implementation for Excel DELTA() function.
Syntax:
DEC2HEX (number,places )
Converts a decimal number to hexadecimal. The decimal integer you want to convert. If number is negative, places is ignored and this function returns a 10-character (40-bit) hexadecimal number in which the most significant bit is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
- If number < -549,755,813,888 or if number > 549,755,813,887, this function returns the #NUM! error value.
- If number is nonnumeric, this function returns the #VALUE! error value.
places
The number of characters to use. The places argument is useful for padding the return value with leading 0s (zeros).- If this argument is omitted, this function uses the minimum number of characters necessary.
- If this function requires more than places characters, it returns the #NUM! error value.
- If this argument is non numeric, this function returns the #VALUE! error value.
- If this argument is negative, this function returns the #NUM! error value.
- If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.
-
Field Summary
Fields -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionfinal ValueEval
evaluate
(ValueEval[] args, OperationEvaluationContext ec)
-
Field Details
-
instance
-
-
Constructor Details
-
Dec2Hex
public Dec2Hex()
-
-
Method Details
-
evaluate
Description copied from interface:Function2Arg
- Specified by:
evaluate
in interfaceFunction2Arg
-
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).
-
evaluate
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, nevernull
.srcRowIndex
- row index of the cell containing the formula under evaluationsrcColumnIndex
- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval
, nevernull
. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaN
be sure to translate the result toErrorEval.NUM_ERROR
.
-