mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-22 00:33:41 +00:00
Mark Baker
35b65bef8c
* First steps toward array-enabling the information functions Also includes moving unit tests out from Functions and into a separate, dedicated Information folder * Resolve issue with IF(), branch pruning and calculation cache (ensure that we don't convert the if condition to a bool before we've tested to see if it evaluates to an error) More refactoring
136 lines
1.6 KiB
PHP
136 lines
1.6 KiB
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
0,
|
|
null,
|
|
],
|
|
[
|
|
-1,
|
|
-1,
|
|
],
|
|
[
|
|
1.25,
|
|
1.25,
|
|
],
|
|
[
|
|
0,
|
|
'',
|
|
],
|
|
[
|
|
0,
|
|
'2.5',
|
|
],
|
|
[
|
|
0,
|
|
'TRUE',
|
|
],
|
|
[
|
|
0,
|
|
'ABCDE',
|
|
],
|
|
[
|
|
1,
|
|
true,
|
|
],
|
|
[
|
|
'#DIV/0!',
|
|
'#DIV/0!',
|
|
],
|
|
[
|
|
'#NUM!',
|
|
'#NUM!',
|
|
],
|
|
[
|
|
0,
|
|
[
|
|
null,
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
123,
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
[
|
|
123,
|
|
456,
|
|
],
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
[
|
|
123,
|
|
'A',
|
|
],
|
|
],
|
|
],
|
|
[
|
|
0,
|
|
[
|
|
[
|
|
'A',
|
|
123,
|
|
],
|
|
],
|
|
],
|
|
[
|
|
0,
|
|
[
|
|
[
|
|
'A',
|
|
123,
|
|
],
|
|
[
|
|
456,
|
|
789,
|
|
],
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
[
|
|
123,
|
|
'A',
|
|
],
|
|
[
|
|
456,
|
|
789,
|
|
],
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
[
|
|
123,
|
|
456,
|
|
],
|
|
[
|
|
'A',
|
|
789,
|
|
],
|
|
],
|
|
],
|
|
[
|
|
123,
|
|
[
|
|
[
|
|
123,
|
|
456,
|
|
],
|
|
[
|
|
789,
|
|
'A',
|
|
],
|
|
],
|
|
],
|
|
];
|