title: Custom PHPExcel cell format only shown after double-click
body: <p>I encountered a weird problem setting a custom date format with PHPExcel: I'm writing an sql formatted date to a cell and setting it's format with setFormatCode to 'd/m/y'. When I open it in Excel 2007, it shows the orignial date format until I double click the cell and then it's updated to my desired format.
  Is there a way to have it refreshing itself without me helping?</p>
  
  <pre><code>$sheet-&gt;setCellValueByColumnAndRow($column, $row, '2010-07-16');
  $sheet-&gt;getStyleByColumnAndRow($column, $row)-&gt;getNumberFormat()-&gt;setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH);
  </code></pre>