PHPOffice /
PhpSpreadsheet
| @@ 340-345 (lines=6) @@ | ||
| 337 | ||
| 338 | // Create absolute coordinate and write as raw text |
|
| 339 | $range = Cell::splitRange($pNamedRange->getRange()); |
|
| 340 | for ($i = 0; $i < count($range); ++$i) { |
|
| 341 | $range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . Cell::absoluteReference($range[$i][0]); |
|
| 342 | if (isset($range[$i][1])) { |
|
| 343 | $range[$i][1] = Cell::absoluteReference($range[$i][1]); |
|
| 344 | } |
|
| 345 | } |
|
| 346 | $range = Cell::buildRange($range); |
|
| 347 | ||
| 348 | $objWriter->writeRawData($range); |
|
| @@ 676-681 (lines=6) @@ | ||
| 673 | foreach ($namedRanges as $namedRange) { |
|
| 674 | // Create absolute coordinate |
|
| 675 | $range = Cell::splitRange($namedRange->getRange()); |
|
| 676 | for ($i = 0; $i < count($range); ++$i) { |
|
| 677 | $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . Cell::absoluteCoordinate($range[$i][0]); |
|
| 678 | if (isset($range[$i][1])) { |
|
| 679 | $range[$i][1] = Cell::absoluteCoordinate($range[$i][1]); |
|
| 680 | } |
|
| 681 | } |
|
| 682 | $range = Cell::buildRange($range); // e.g. Sheet1!$A$1:$B$2 |
|
| 683 | ||
| 684 | // parse formula |
|
