PHPOffice / PhpSpreadsheet

                // Create absolute coordinate

                $range = Coordinate::splitRange($namedRange->getRange());

                $iMax = count($range);

                for ($i = 0; $i < $iMax; ++$i) {

                    $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . Coordinate::absoluteCoordinate($range[$i][0]);

                    if (isset($range[$i][1])) {

                        $range[$i][1] = Coordinate::absoluteCoordinate($range[$i][1]);

                    }

                }

                $range = Coordinate::buildRange($range); // e.g. Sheet1!$A$1:$B$2

                // parse formula

        // Create absolute coordinate and write as raw text

        $range = Coordinate::splitRange($pNamedRange->getRange());

        $iMax = count($range);

        for ($i = 0; $i < $iMax; ++$i) {

            $range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . Coordinate::absoluteReference($range[$i][0]);

            if (isset($range[$i][1])) {

                $range[$i][1] = Coordinate::absoluteReference($range[$i][1]);

            }

        }

        $range = Coordinate::buildRange($range);

        $objWriter->writeRawData($range);