title: PHPExcel conditional formatting off by one row
body: <p>My conditional formatting is off by one row for some reason and I cannot figure out why.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>$conditional = new PHPExcel_Style_Conditional();                                                                                
  $conditional-&gt;setConditionType(PHPExcel_Style_Conditional::CONDITION_CONTAINSTEXT);                                             
  $conditional-&gt;setOperatorType(PHPExcel_Style_Conditional::OPERATOR_CONTAINSTEXT);                                               
  $conditional-&gt;setText('~?');                                                                          
  $conditional-&gt;getStyle()-&gt;getFill()-&gt;applyFromArray(array('type' =&gt; PHPExcel_Style_Fill::FILL_SOLID, 'endcolor' =&gt; array('rgb' =&gt; '7FA0D1')));  
  
  ...
  
  $conditionalStyles = $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A:J')-&gt;getConditionalStyles();
  array_push($conditionalStyles, $conditional);
  $objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A:J')-&gt;setConditionalStyles($conditionalStyles);
  </code></pre>
  
  <p>In the spreadsheet that this generates, I have</p>
  
  <pre><code>?
  A
  </code></pre>
  
  <p>And for some reason it formats the A instead of the ? above it. If I go into Excel's conditional formatting "Manage Rules", select this rule, "Edit Rule", click "Ok" without changing anything, then click "Ok" in the main window, it fixes itself. So I'm not sure why its off on the first load?</p>