|
@@ 1321-1326 (lines=6) @@
|
| 1318 |
|
$this->advance(); |
| 1319 |
|
|
| 1320 |
|
return $result; |
| 1321 |
|
} elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) { |
| 1322 |
|
// If it's an external reference (Sheet1!A1 or Sheet1:Sheet2!A1 or Sheet1!$A$1 or Sheet1:Sheet2!$A$1) |
| 1323 |
|
$result = $this->createTree($this->currentToken, '', ''); |
| 1324 |
|
$this->advance(); |
| 1325 |
|
|
| 1326 |
|
return $result; |
| 1327 |
|
} elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?[A-Ia-i]?[A-Za-z]\\$?[0-9]+$/u", $this->currentToken)) { |
| 1328 |
|
// If it's an external reference ('Sheet1'!A1 or 'Sheet1:Sheet2'!A1 or 'Sheet1'!$A$1 or 'Sheet1:Sheet2'!$A$1) |
| 1329 |
|
$result = $this->createTree($this->currentToken, '', ''); |
|
@@ 1341-1348 (lines=8) @@
|
| 1338 |
|
$this->advance(); |
| 1339 |
|
|
| 1340 |
|
return $result; |
| 1341 |
|
} elseif (preg_match('/^' . self::REGEX_SHEET_TITLE_UNQUOTED . "(\:" . self::REGEX_SHEET_TITLE_UNQUOTED . ")?\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) { |
| 1342 |
|
// If it's an external range (Sheet1!A1:B2 or Sheet1:Sheet2!A1:B2 or Sheet1!$A$1:$B$2 or Sheet1:Sheet2!$A$1:$B$2) |
| 1343 |
|
// must be an error? |
| 1344 |
|
$result = $this->createTree($this->currentToken, '', ''); |
| 1345 |
|
$this->advance(); |
| 1346 |
|
|
| 1347 |
|
return $result; |
| 1348 |
|
} elseif (preg_match("/^'" . self::REGEX_SHEET_TITLE_QUOTED . "(\:" . self::REGEX_SHEET_TITLE_QUOTED . ")?'\!\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+:\\$?([A-Ia-i]?[A-Za-z])?\\$?[0-9]+$/u", $this->currentToken)) { |
| 1349 |
|
// If it's an external range ('Sheet1'!A1:B2 or 'Sheet1'!A1:B2 or 'Sheet1'!$A$1:$B$2 or 'Sheet1'!$A$1:$B$2) |
| 1350 |
|
// must be an error? |
| 1351 |
|
$result = $this->createTree($this->currentToken, '', ''); |
PHPOffice /
PhpSpreadsheet
