mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-25 05:08:21 +00:00
oleibman
3697352e28
* Fix Unintential Deprecated Calls in Tests - LOGICAL I think it's best to install these before PR #3166. There are no changes to source code, only to doc-blocks and to test members which continue to inadvertently use calls to deprecated functions. * Change Unit Tests to Run in Spreadsheet Context They had been run as direct calls, which is not how most users would use them. Making this change exposed some minor coding errors - SWITCH needs to flatten its arguments, and IFERROR and IFNA were not handling a null testValue in the same manner as Excel.
40 lines
594 B
PHP
40 lines
594 B
PHP
<?php
|
|
|
|
return [
|
|
'match value1 A result is C' => [
|
|
'C',
|
|
'A',
|
|
'A',
|
|
'C',
|
|
'B',
|
|
'D',
|
|
'??',
|
|
],
|
|
'match value2 2 result is female' => [
|
|
'Female',
|
|
2,
|
|
'1',
|
|
'Male',
|
|
'2',
|
|
'Female',
|
|
],
|
|
'defined default value' => [
|
|
'X',
|
|
'U',
|
|
'ABC',
|
|
'Y',
|
|
'DEF',
|
|
'Z',
|
|
'X',
|
|
],
|
|
'undefined default value' => [
|
|
'#N/A',
|
|
'U',
|
|
'ABC',
|
|
'Y',
|
|
'DEF',
|
|
'Z',
|
|
],
|
|
'no arguments' => ['exception'],
|
|
];
|