PHPOffice /
PhpSpreadsheet
| @@ 1647-1651 (lines=5) @@ | ||
| 1644 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1645 | // Extract range |
|
| 1646 | $extractedRange = (string) $definedName; |
|
| 1647 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1648 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1649 | } else { |
|
| 1650 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1651 | } |
|
| 1652 | ||
| 1653 | // Valid range? |
|
| 1654 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
| @@ 1721-1725 (lines=5) @@ | ||
| 1718 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1719 | // Extract range |
|
| 1720 | $extractedRange = (string) $definedName; |
|
| 1721 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1722 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1723 | } else { |
|
| 1724 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1725 | } |
|
| 1726 | ||
| 1727 | // Valid range? |
|
| 1728 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
