68 lines
1.6 KiB
PHP
68 lines
1.6 KiB
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\Cell\DataType;
|
|
|
|
return [
|
|
[
|
|
'ABCDE,FGHIJ',
|
|
[',', true, 'ABCDE', 'FGHIJ'],
|
|
],
|
|
[
|
|
'ABCDEFGHIJ',
|
|
['', true, 'ABCDE', 'FGHIJ'],
|
|
],
|
|
[
|
|
'1-2-3',
|
|
['-', true, 1, 2, 3],
|
|
],
|
|
[
|
|
'<<::>>',
|
|
['::', true, '<<', '>>'],
|
|
],
|
|
[
|
|
'Καλό απόγευμα',
|
|
[' ', true, 'Καλό', 'απόγευμα'],
|
|
],
|
|
[
|
|
'Boolean-TRUE',
|
|
['-', true, 'Boolean', '', true],
|
|
],
|
|
[
|
|
'Boolean-TRUE',
|
|
['-', true, 'Boolean', ' ', true],
|
|
],
|
|
[
|
|
'Boolean--TRUE',
|
|
['-', false, 'Boolean', '', true],
|
|
],
|
|
[
|
|
'C:\\Users\\Mark\\Documents\\notes.doc',
|
|
['\\', true, 'C:', 'Users', 'Mark', 'Documents', 'notes.doc'],
|
|
],
|
|
'no argument' => ['exception', []],
|
|
'one argument' => ['exception', ['-']],
|
|
'two arguments' => ['exception', ['-', true]],
|
|
'three arguments' => ['a', ['-', true, 'a']],
|
|
'boolean as string' => ['TRUE-FALSE-TRUE', ['-', true, true, false, true]],
|
|
'result too long' => [
|
|
'#CALC!',
|
|
[
|
|
',',
|
|
true,
|
|
str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5),
|
|
'abcde',
|
|
],
|
|
],
|
|
'result just fits' => [
|
|
str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5) . ',abcd',
|
|
[
|
|
',',
|
|
true,
|
|
str_repeat('Ԁ', DataType::MAX_STRING_LENGTH - 5),
|
|
'abcd',
|
|
],
|
|
],
|
|
'propagate REF' => ['#REF!', [',', true, '1', '=sheet99!A1', '3']],
|
|
'propagate NUM' => ['#NUM!', [',', true, '1', '=SQRT(-1)', '3']],
|
|
];
|