title: I cannot format a row copied from one sheet to another as string in PHPExcel
body: <p>I am having trouble when copying a row from one sheet to another in the same Excel file. Some cells contain large numbers, which creates a problem when copying them because they get rounded up and I don't want that to happen. I heard I can overcome that problem by pasting them as a string, <a href="https://stackoverflow.com/questions/33696191/phpexcel-set-cells-as-string-while-uploading-from-array">as shown here</a>. But no matter what I do the values of the cells are still formatted as numbers, which messes up the whole process.</p>
  
  <p>Can you please help me? Thanks!</p>
  
  <p>Excerpt code:</p>
  
  <pre><code>//por ultimo lo demas
      for($i=2; $i&lt;$rowCount;$i++){
          $order = $objPHPExcel-&gt;getActiveSheet()-&gt;getCell('B'.$i)-&gt;getValue();
          if($order != 'xxx'){
              $cellValues = $objPHPExcel-&gt;getActiveSheet()-&gt;rangeToArray("A$i:AP$i", null, true, true, false);
              $objPHPExcel-&gt;setActiveSheetIndex(1);
              PHPExcel_Cell::setValueBinder(new PHPExcel_Cell_MyColumnValueBinder($cellValues));
              $objPHPExcel-&gt;getActiveSheet()-&gt;fromArray($cellValues, null, 'A'.$newRow);
              $newRow++;
              $objPHPExcel-&gt;setActiveSheetIndex(0);
              $objPHPExcel-&gt;getActiveSheet()-&gt;setCellValue('B'.$i, 'xxx');
          }
      }
  </code></pre>