PHPOffice /
PhpSpreadsheet
| @@ 1672-1676 (lines=5) @@ | ||
| 1669 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1670 | // Extract range |
|
| 1671 | $extractedRange = (string) $definedName; |
|
| 1672 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1673 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1674 | } else { |
|
| 1675 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1676 | } |
|
| 1677 | ||
| 1678 | // Valid range? |
|
| 1679 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
| @@ 1745-1749 (lines=5) @@ | ||
| 1742 | foreach ($xmlWorkbook->definedNames->definedName as $definedName) { |
|
| 1743 | // Extract range |
|
| 1744 | $extractedRange = (string) $definedName; |
|
| 1745 | if (($spos = strpos($extractedRange, '!')) !== false) { |
|
| 1746 | $extractedRange = substr($extractedRange, 0, $spos) . str_replace('$', '', substr($extractedRange, $spos)); |
|
| 1747 | } else { |
|
| 1748 | $extractedRange = str_replace('$', '', $extractedRange); |
|
| 1749 | } |
|
| 1750 | ||
| 1751 | // Valid range? |
|
| 1752 | if (stripos((string) $definedName, '#REF!') !== false || $extractedRange == '') { |
|
