/**
* Write links to external directory names such as 'c:\foo.xls',
* c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'.
*
* @param Range $range Cell range
* @param string $url URL string
* @param string $label Alternative label
* @param mixed $format The cell format
*/
protected function writeUrlExternal(Range $range, $url, $label, $format = null)
{
// Strip URL type and change Unix dir separator to Dos style (if needed)
$url = preg_replace('/^external:/', '', $url);
$url = preg_replace('/\\//', "\\", $url);
$this->writeUrlLabel($range->getStartCell(), $url, $label, $format);
$this->appendRecord('HyperlinkExternal', array($range, $url));
}
