Class Dec2Hex

java.lang.Object
org.apache.poi.ss.formula.functions.Dec2Hex
All Implemented Interfaces:
FreeRefFunction, Function, Function1Arg, Function2Arg

public final class Dec2Hex extends Object implements FreeRefFunction
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 invalid input: '<' -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 Details

  • Constructor Details

    • Dec2Hex

      public Dec2Hex()
  • Method Details