PhpSpreadsheet/tests/data/Calculation/Logical/SWITCH.php

47 lines
615 B
PHP
Raw Permalink Normal View History

<?php
return [
// Must be C
[
2020-05-18 04:49:57 +00:00
'C',
'A',
'A',
'C',
'B',
'D',
'??',
],
// Must be Female
[
2020-05-18 04:49:57 +00:00
'Female',
2,
2020-05-18 04:49:57 +00:00
'1',
'Male',
'2',
'Female',
],
// Must be X using default
[
2020-05-18 04:49:57 +00:00
'X',
'U',
'ABC',
'Y',
'DEF',
'Z',
'X',
],
// Must be N/A default value not defined
[
2020-05-18 04:49:57 +00:00
'#N/A',
'U',
'ABC',
'Y',
'DEF',
'Z',
],
// Must be value - no parameter
[
2020-05-18 04:49:57 +00:00
'#VALUE!',
],
];