mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 21:08:29 +00:00
Mark Baker
d2e6db71fa
* Additional unit tests for VLOOKUP() and HLOOKUP() * Additional unit tests for CHOOSE() * Unit tests for HYPERLINK() function * Fix CHOOSE() test for spillage
37 lines
656 B
PHP
37 lines
656 B
PHP
<?php
|
|
|
|
return [
|
|
[
|
|
'brown',
|
|
4, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'blue',
|
|
2, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'green',
|
|
3, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'red',
|
|
1, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
5, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
0, 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
'#VALUE!',
|
|
'NaN', 'red', 'blue', 'green', 'brown',
|
|
],
|
|
[
|
|
['blue', 'purple'],
|
|
3, ['red', 'orange'], ['yellow', 'green'], ['blue', 'purple'],
|
|
],
|
|
];
|