DEC2HEX.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. return [
  3. ['165', '357'],
  4. ['54D', '1357'],
  5. ['F6', '246'],
  6. ['3039', '12345'],
  7. ['75BCD15', '123456789'],
  8. ['0064', '100, 4'],
  9. ['00064', '100, 5.75'], // Leading places as a float
  10. ['#NUM!', '100, -1'], // Leading places negative
  11. ['#VALUE!', '100, "ABC"'], // Leading places non-numeric
  12. ['7B', '123.45'],
  13. ['0', '0'],
  14. ['#VALUE!', '"3579A"'], // Invalid decimal
  15. ['#VALUE!', 'true'], // ODS accepts boolean, Excel/Gnumeric don't
  16. ['#VALUE!', 'false'],
  17. ['FFFFFFFFCA', '-54'], // 2's Complement
  18. ['FFFFFFFF95', '-107'], // 2's Complement
  19. ['FF80000001', '-2147483647'], // 2's Complement
  20. ['FF80000000', '-2147483648'], // 2's Complement
  21. ['7FFFFFFFFF', 549755813887], // highest positive, succeeds even for 32-bit
  22. ['#NUM!', 549755813888],
  23. ['8000000000', -549755813888], // lowest negative, succeeds even for 32-bit
  24. ['A2DE246000', -400000000000],
  25. ['5D21DBA000', 400000000000],
  26. ['#NUM!', -549755813889],
  27. ['0103', '259, 4'],
  28. ['#NUM!', '259, 0'],
  29. ['#NUM!', '259, -1'],
  30. ['#NUM!', '259, 14'],
  31. ['#NUM!', '259, 1'],
  32. ['103', '259, 3'],
  33. ['11', 'A2'],
  34. ['0', 'C2'],
  35. ['exception', ''],
  36. ];