Subversion Repositories eFlore/Applications.cel

Rev

Rev 970 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 970 Rev 996
Line 644... Line 644...
644 
    {
 644 
    {
645 
        $class = 2; // as far as I know, this is magick.
 645 
        $class = 2; // as far as I know, this is magick.
Line 646... Line 646...
646
646
647 
        // Split the range into 2 cell refs
 647 
        // Split the range into 2 cell refs
648 
        if(preg_match("/^([A-I]?[A-Z])(\d+)\:([A-I]?[A-Z])(\d+)$/",$range)) {
 648 
        if(preg_match("/^([A-I]?[A-Z])(\d+)\:([A-I]?[A-Z])(\d+)$/",$range)) {
649 
            list($cell1, $cell2) = split(':', $range);
 649 
            list($cell1, $cell2) = explode(':', $range);
650 
        }
 650 
        }
651 
        elseif(preg_match("/^([A-I]?[A-Z])(\d+)\.\.([A-I]?[A-Z])(\d+)$/",$range)) {
 651 
        elseif(preg_match("/^([A-I]?[A-Z])(\d+)\.\.([A-I]?[A-Z])(\d+)$/",$range)) {
Line 652... Line 652...
652 
            list($cell1, $cell2) = split('\.\.', $range);
 652 
            list($cell1, $cell2) = explode('\.\.', $range);
653
653
654 
        }
 654 
        }
655 
        else {
 655 
        else {
Line 696... Line 696...
696 
    function _convertRange3d($token)
 696 
    function _convertRange3d($token)
697 
    {
 697 
    {
698 
        $class = 2; // as far as I know, this is magick.
 698 
        $class = 2; // as far as I know, this is magick.
Line 699... Line 699...
699
699
700 
        // Split the ref at the ! symbol
 700 
        // Split the ref at the ! symbol
Line 701... Line 701...
701 
        list($ext_ref, $range) = split('!', $token);
 701 
        list($ext_ref, $range) = explode('!', $token);
702
702
703 
        // Convert the external reference part
 703 
        // Convert the external reference part
704 
        $ext_ref = $this->_packExtRef($ext_ref);
 704 
        $ext_ref = $this->_packExtRef($ext_ref);
705 
        if ($this->isError($ext_ref)) {
 705 
        if ($this->isError($ext_ref)) {
Line 706... Line 706...
706 
            return $ext_ref;
 706 
            return $ext_ref;
707 
        }
 707 
        }
Line 708... Line 708...
708
708
709 
        // Split the range into 2 cell refs
 709 
        // Split the range into 2 cell refs
710 
        list($cell1, $cell2) = split(':', $range);
 710 
        list($cell1, $cell2) = explode(':', $range);
711
711
Line 794... Line 794...
794 
    function _convertRef3d($cell)
 794 
    function _convertRef3d($cell)
795 
    {
 795 
    {
796 
        $class = 2; // as far as I know, this is magick.
 796 
        $class = 2; // as far as I know, this is magick.
Line 797... Line 797...
797
797
798 
        // Split the ref at the ! symbol
 798 
        // Split the ref at the ! symbol
Line 799... Line 799...
799 
        list($ext_ref, $cell) = split('!', $cell);
 799 
        list($ext_ref, $cell) = explode('!', $cell);
800
800
801 
        // Convert the external reference part
 801 
        // Convert the external reference part
802 
        $ext_ref = $this->_packExtRef($ext_ref);
 802 
        $ext_ref = $this->_packExtRef($ext_ref);
Line 838... Line 838...
838 
        $ext_ref = preg_replace("/'$/", '', $ext_ref); // Remove trailing ' if any.
 838 
        $ext_ref = preg_replace("/'$/", '', $ext_ref); // Remove trailing ' if any.
Line 839... Line 839...
839
839
840 
        // Check if there is a sheet range eg., Sheet1:Sheet2.
 840 
        // Check if there is a sheet range eg., Sheet1:Sheet2.
841 
        if (preg_match("/:/", $ext_ref))
 841 
        if (preg_match("/:/", $ext_ref))
842 
        {
 842 
        {
Line 843... Line 843...
843 
            list($sheet_name1, $sheet_name2) = split(':', $ext_ref);
 843 
            list($sheet_name1, $sheet_name2) = explode(':', $ext_ref);
844
844
845 
            $sheet1 = $this->_getSheetIndex($sheet_name1);
 845 
            $sheet1 = $this->_getSheetIndex($sheet_name1);
846 
            if ($sheet1 == -1) {
 846 
            if ($sheet1 == -1) {