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