PHPOffice /
PhpSpreadsheet
| @@ 1701-1705 (lines=5) @@ | ||
| 1698 | // Extract range |
|
| 1699 | $extractedRange = (string)$definedName; |
|
| 1700 | $extractedRange = preg_replace('/\'(\w+)\'\!/', '', $extractedRange); |
|
| 1701 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1702 | $extractedRange = substr($extractedRange, 0, $spos).str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1703 | } else { |
|
| 1704 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1705 | } |
|
| 1706 | ||
| 1707 | // Valid range? |
|
| 1708 | if (stripos((string)$definedName, '#REF!') !== false || $extractedRange == '') { |
|
| @@ 1776-1780 (lines=5) @@ | ||
| 1773 | // Extract range |
|
| 1774 | $extractedRange = (string)$definedName; |
|
| 1775 | $extractedRange = preg_replace('/\'(\w+)\'\!/', '', $extractedRange); |
|
| 1776 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1777 | $extractedRange = substr($extractedRange, 0, $spos).str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1778 | } else { |
|
| 1779 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1780 | } |
|
| 1781 | ||
| 1782 | // Valid range? |
|
| 1783 | if (stripos((string)$definedName, '#REF!') !== false || $extractedRange == '') { |
|
