CONCATENATE.php 765 B

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. use PhpOffice\PhpSpreadsheet\Cell\DataType;
  3. return [
  4. [
  5. 'ABCDEFGHIJ',
  6. 'ABCDE',
  7. 'FGHIJ',
  8. ],
  9. [
  10. '123',
  11. 1,
  12. 2,
  13. 3,
  14. ],
  15. [
  16. 'Boolean-TRUE',
  17. 'Boolean',
  18. '-',
  19. true,
  20. ],
  21. 'no arguments' => ['exception'],
  22. 'result just fits' => [
  23. // Note use Armenian character below to make sure chars, not bytes
  24. str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5) . 'ABCDE',
  25. str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5),
  26. 'ABCDE',
  27. ],
  28. 'result too long' => [
  29. '#CALC!',
  30. str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5),
  31. 'abc',
  32. '=A2',
  33. ],
  34. 'propagate DIV0' => ['#DIV/0!', '1', '=2/0', '3'],
  35. ];