excel/writer/parser.php

734         list($ext_ref, $range) = explode('!', $token);
738             $ext_ref = $this->_packExtRef($ext_ref);
739             if (PEAR::isError($ext_ref)) {
740                 return $ext_ref;
744              $ext_ref = $this->_getRefIndex($ext_ref);
745              if (PEAR::isError($ext_ref)) {
746                  return $ext_ref;
789         return $ptgArea . $ext_ref . $row1 . $row2 . $col1. $col2;
840         list($ext_ref, $cell) = explode('!', $cell);
844             $ext_ref = $this->_packExtRef($ext_ref);
845             if (PEAR::isError($ext_ref)) {
846                 return $ext_ref;
850             $ext_ref = $this->_getRefIndex($ext_ref);
851             if (PEAR::isError($ext_ref)) {
852                 return $ext_ref;
873         return $ptgRef . $ext_ref. $row . $col;
881     * @param string $ext_ref The name of the external reference
884     function _packExtRef($ext_ref)  argument
886         $ext_ref = preg_replace("/^'/", '', $ext_ref); // Remove leading  ' if any.
887         $ext_ref = preg_replace("/'$/", '', $ext_ref); // Remove trailing ' if any.
890         if (preg_match('/:/', $ext_ref))
892             list($sheet_name1, $sheet_name2) = explode(':', $ext_ref);
910             $sheet1 = $this->_getSheetIndex($ext_ref);
912                 return $this->raiseError("Unknown sheet name $ext_ref in formula");
929     * @param string $ext_ref The name of the external reference
933     function _getRefIndex($ext_ref)  argument
935         $ext_ref = preg_replace("/^'/", '', $ext_ref); // Remove leading  ' if any.
936         $ext_ref = preg_replace("/'$/", '', $ext_ref); // Remove trailing ' if any.
939         if (preg_match('/:/', $ext_ref))
941             list($sheet_name1, $sheet_name2) = explode(':', $ext_ref);
959             $sheet1 = $this->_getSheetIndex($ext_ref);
961                 return $this->raiseError("Unknown sheet name $ext_ref in formula");