title: PHPExcel - Existing array functions get converted into normal functions?
body: <p>Greetings all,</p>
  
  <p>I'm trying to write a script that loads an existing spreadsheet containing a number of array formulas, add data to a worksheet and save it.  When opening the file after the script runs, the spreadsheet's formulas are no longer array formulas.</p>
  
  <p>Below is the stripped down version of what I'm attempting:</p>
  
  <pre><code>$excelFile = new PHPExcel();
  $fileName = 'blah.xlsx';
  
  $excelReader = PHPExcel_IOFactory::createReader('Excel2007');
  $excelFile = $excelReader-&gt;load($fileName);
  
  //first sheet contains formulas to process the resulting dump
  $excelFile-&gt;setActiveSheetIndex(1);
  
  // just to illustrate what's used when retrieving data
  ...
  while($record =  db_fetch_object($queryResult)) {
    $excelFile-&gt;getActiveSheet()-&gt;setCellValueByColumnAndRow($col, $row, $record-&gt;field);
  }
  
  $excelWriter = PHPExcel_IOFactory::createWriter($excelFile, 'Excel2007');
  $excelWriter-&gt;save($fileName);
  </code></pre>
  
  <p>After the script runs, a formula that once appeared as:</p>
  
  <blockquote>
    <p>{=SUM(A1:C6)}</p>
  </blockquote>
  
  <p>Now appears as:</p>
  
  <blockquote>
    <p>=SUM(A1:C6)</p>
  </blockquote>
  
  <p>Thanks in advance for your insight and input</p>
  
  <p>Tony</p>