PHPOffice /
PhpSpreadsheet
| @@ 1689-1693 (lines=5) @@ | ||
| 1686 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1687 | // Extract range |
|
| 1688 | $extractedRange = (string) $definedName; |
|
| 1689 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1690 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1691 | } else { |
|
| 1692 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1693 | } |
|
| 1694 | ||
| 1695 | // Valid range? |
|
| 1696 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
| @@ 1762-1766 (lines=5) @@ | ||
| 1759 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1760 | // Extract range |
|
| 1761 | $extractedRange = (string) $definedName; |
|
| 1762 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1763 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1764 | } else { |
|
| 1765 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1766 | } |
|
| 1767 | ||
| 1768 | // Valid range? |
|
| 1769 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
