mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-21 22:03:40 +00:00
Adrian
276f7813d5
* check if coordinate is inside range * Added coordinateIsInsideRange tests * fix coordinateIsInsideRange error throwing * fix coordinateIsInsideRange error throwing * add support to worksheet name * validateReferenceAndGetData type * change validate and add tests data * fix tests data reference * fix absolute reference error * fix boundaries to get range * fix scrutinizer erros * Additional Test Cases --------- Co-authored-by: oleibman <10341515+oleibman@users.noreply.github.com>
34 lines
1.2 KiB
PHP
34 lines
1.2 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
return [
|
|
[true, 'A1:E20', 'B4'],
|
|
[false, 'A1:E20', 'F36'],
|
|
[true, '$A$1:$E$20', '$B$4'],
|
|
[false, '$A$1:$E$20', '$F$36'],
|
|
[true, '$A$1:$E$20', 'B4'],
|
|
[false, '$A$1:$E$20', 'F36'],
|
|
[true, 'A1:E20', '$B$4'],
|
|
[false, 'A1:E20', '$F$36'],
|
|
[true, 'Sheet!A1:E20', 'Sheet!B4'],
|
|
'case insensitive' => [true, 'Sheet!A1:E20', 'sheet!B4'],
|
|
'apostrophes 1st sheetname not 2nd' => [true, '\'Sheet\'!A1:E20', 'sheet!B4'],
|
|
'apostrophes 2nd sheetname not 1st' => [true, 'Sheet!A1:E20', '\'sheet\'!B4'],
|
|
[false, 'Sheet!A1:E20', 'Sheet!F36'],
|
|
[true, 'Sheet!$A$1:$E$20', 'Sheet!$B$4'],
|
|
[false, 'Sheet!$A$1:$E$20', 'Sheet!$F$36'],
|
|
[false, 'Sheet!A1:E20', 'B4'],
|
|
[false, 'Sheet!A1:E20', 'F36'],
|
|
[false, 'Sheet!$A$1:$E$20', '$B$4'],
|
|
[false, 'Sheet!$A$1:$E$20', '$F$36'],
|
|
[false, 'A1:E20', 'Sheet!B4'],
|
|
[false, 'A1:E20', 'Sheet!F36'],
|
|
[false, '$A$1:$E$20', 'Sheet!$B$4'],
|
|
[false, '$A$1:$E$20', 'Sheet!$F$36'],
|
|
[true, '\'Sheet space\'!A1:E20', '\'Sheet space\'!B4'],
|
|
[false, '\'Sheet space\'!A1:E20', '\'Sheet space\'!F36'],
|
|
[true, '\'Sheet space\'!$A$1:$E$20', '\'Sheet space\'!$B$4'],
|
|
[false, '\'Sheet space\'!$A$1:$E$20', '\'Sheet space\'!$F$36'],
|
|
];
|