BIN2HEX.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. return [
  3. ['B2', '10110010'],
  4. ['#NUM!', '111001010101'], // Too large
  5. ['00FB', '11111011, 4'], // Leading places
  6. ['0FB', '11111011, 3.75'], // Leading places as a float
  7. ['#NUM!', '11111011, -1'], // Leading places negative
  8. ['#VALUE!', '11111011, "ABC"'], // Leading places non-numeric
  9. ['E', '"1110"'],
  10. ['5', '101'],
  11. ['2', '10'],
  12. ['0', '0'],
  13. ['#NUM!', '21'], // Invalid binary number
  14. ['#VALUE!', 'true'], // ODS accepts Boolean, Excel/Gnumeric don't
  15. ['#VALUE!', 'false'], // ODS accepts Boolean, Excel/Gnumeric don't
  16. ['FFFFFFFF95', '1110010101'], // 2's Complement
  17. ['FFFFFFFFFF', '1111111111'], // 2's Complement
  18. ['FFFFFFFE00', '1000000000'], // lowest negative
  19. ['1FF', '111111111'], // highest positive
  20. ['0', '0000000000'],
  21. ['1', '000000001'],
  22. ['100', '0100000000'],
  23. ['100', '100000000'],
  24. ['FFFFFFFF00', '1100000000'],
  25. ['0003', '11, 4'],
  26. ['#NUM!', '11, 0'],
  27. ['#NUM!', '11, -1'],
  28. ['#NUM!', '11, 14'],
  29. ['#NUM!', '10001, 1'],
  30. ['11', '10001, 2'],
  31. [5, 'A2'],
  32. ['#NUM!', '"A2"'],
  33. [0, 'A3'],
  34. ['exception', ''],
  35. ];