mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-11-09 11:26:17 +00:00
oleibman
2527575636
@dkulyk noticed a case which wasn't handled properly. I believe the fix works for everything ... except `COLUMNS` and `ROWS`, where Excel seems to ignore the sheet, and I just can't figure out how to do it.
22 lines
883 B
PHP
22 lines
883 B
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
return [
|
|
'global $e$2-$e$6' => [1, 'namedrangex'],
|
|
'global $f$2:$h$2' => [3, 'namedrangey'],
|
|
'global $f$4:$h$4' => [3, 'namedrange3'],
|
|
'local in scope $f$5:$i$5' => [4, 'namedrange5'],
|
|
'local out of scope' => ['#NAME?', 'localname'],
|
|
'non-existent sheet' => ['incomplete', 'UnknownSheet!B2:K6'],
|
|
'not enough arguments' => ['exception', 'omitted'],
|
|
'other existing sheet' => [6, 'OtherSheet!B1:G1'],
|
|
'qualified in scope $f$5:$i$5' => [4, 'ThisSheet!namedrange5'],
|
|
'single cell absolute' => [1, '$C$15'],
|
|
'single cell relative' => [1, 'C7'],
|
|
'unknown name' => ['#NAME?', 'namedrange2'],
|
|
'unknown name as first part of range' => ['#NAME?', 'Invalid:A2'],
|
|
'unknown name as second part of range' => ['#NAME?', 'A2:Invalid'],
|
|
'qualified out of scope $f$6:$h$6' => [3, 'OtherSheet!localname'],
|
|
];
|