Single cell print area

[char101]

Hi,

I have found a case when an excel file that opens fine in excel viewer and libreoffice but does not open in phpexcel. The problem is that the file has a single cell printarea:

worksheet$O$8

I have fixed it by the following patch

diff --git a/PHPExcel/Reader/Excel5.php b/PHPExcel/Reader/Excel5.php
index 79cd7b0..fd41b97 100755
--- a/PHPExcel/Reader/Excel5.php
+++ b/PHPExcel/Reader/Excel5.php
@@ -973,8 +973,13 @@ class PHPExcel_Reader_Excel5 extends PHPExcel_Reader_Abstract implements PHPExce
                        }
                    }
                    if ($docSheet = $this->_phpExcel->getSheetByName($sheetName)) {
-                       $docSheet->getPageSetup()->setPrintArea(implode(',', $extractedRanges)); // C7:J66,A1:IV2
+                       $printArea = implode(',', $extractedRanges);
+                       if (false === strpos($printArea, ':')) {
+                           $printArea = "$printArea:$printArea";
+                       }
+                       $docSheet->getPageSetup()->setPrintArea($printArea); // C7:J66,A1:IV2
                    }
                    break;

                case pack('C', 0x07):

diff --git a/PHPExcel/Reader/Excel2007.php b/PHPExcel/Reader/Excel2007.php
index 1b3a67e..88f1049 100755
--- a/PHPExcel/Reader/Excel2007.php
+++ b/PHPExcel/Reader/Excel2007.php
@@ -1562,7 +1562,11 @@ class PHPExcel_Reader_Excel2007 extends PHPExcel_Reader_Abstract implements PHPE
                                                    $rangeSet = isset($range[1]) ? $range[1] : $range[0];
                                                    $newRangeSets[] = str_replace('$', '', $rangeSet);
                                                }
-                                               $docSheet->getPageSetup()->setPrintArea(implode(',',$newRangeSets));
+                                               $printArea = implode(',',$newRangeSets);
+                                               if (false === strpos($printArea, ':')) {
+                                                   $printArea = "$printArea:$printArea";
+                                               }
+                                               $docSheet->getPageSetup()->setPrintArea($printArea);
                                                break;

                                            default:

[MarkBaker]

Looking at this now. The code you've updated won't work if there are multiple cell ranges, and one of them is single cell range, so modifying it to work in that sitution; but thanks for bringing it to our attention

[char101]

Thanks for the bugfix.