PHPOffice /
PhpSpreadsheet
| @@ 319-324 (lines=6) @@ | ||
| 316 | ||
| 317 | // Create absolute coordinate and write as raw text |
|
| 318 | $range = \PhpSpreadsheet\Cell::splitRange($pNamedRange->getRange()); |
|
| 319 | for ($i = 0; $i < count($range); $i++) { |
|
| 320 | $range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . \PhpSpreadsheet\Cell::absoluteReference($range[$i][0]); |
|
| 321 | if (isset($range[$i][1])) { |
|
| 322 | $range[$i][1] = \PhpSpreadsheet\Cell::absoluteReference($range[$i][1]); |
|
| 323 | } |
|
| 324 | } |
|
| 325 | $range = \PhpSpreadsheet\Cell::buildRange($range); |
|
| 326 | ||
| 327 | $objWriter->writeRawData($range); |
|
| @@ 653-658 (lines=6) @@ | ||
| 650 | foreach ($namedRanges as $namedRange) { |
|
| 651 | // Create absolute coordinate |
|
| 652 | $range = \PhpSpreadsheet\Cell::splitRange($namedRange->getRange()); |
|
| 653 | for ($i = 0; $i < count($range); $i++) { |
|
| 654 | $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . \PhpSpreadsheet\Cell::absoluteCoordinate($range[$i][0]); |
|
| 655 | if (isset($range[$i][1])) { |
|
| 656 | $range[$i][1] = \PhpSpreadsheet\Cell::absoluteCoordinate($range[$i][1]); |
|
| 657 | } |
|
| 658 | } |
|
| 659 | $range = \PhpSpreadsheet\Cell::buildRange($range); // e.g. Sheet1!$A$1:$B$2 |
|
| 660 | ||
| 661 | // parse formula |
|
