PHPOffice /
PhpSpreadsheet
| @@ 1659-1663 (lines=5) @@ | ||
| 1656 | // Extract range |
|
| 1657 | $extractedRange = (string) $definedName; |
|
| 1658 | $extractedRange = preg_replace('/\'(\w+)\'\!/', '', $extractedRange); |
|
| 1659 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1660 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1661 | } else { |
|
| 1662 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1663 | } |
|
| 1664 | ||
| 1665 | // Valid range? |
|
| 1666 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
| @@ 1734-1738 (lines=5) @@ | ||
| 1731 | // Extract range |
|
| 1732 | $extractedRange = (string) $definedName; |
|
| 1733 | $extractedRange = preg_replace('/\'(\w+)\'\!/', '', $extractedRange); |
|
| 1734 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1735 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1736 | } else { |
|
| 1737 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1738 | } |
|
| 1739 | ||
| 1740 | // Valid range? |
|
| 1741 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
