title: CFSpreadSheet - format column not formatting the entire column
body: <p>Using CF10 Standard to create a spreadsheet from a query.  No matter what I've tried so far, the formatting for a specific column stops at row 32 (1 header row, 31 data), even though the entire sheet is populated to 186 rows.</p>
  
  <pre><code>&lt;cfscript&gt;
   dfStyle=StructNew();
   dfStyle.fgcolor="pale_blue";
   dfStyle.dataformat="mm/dd/yyyy";
   theSheet = SpreadSheetNew('mysheet');
   SpreadSheetAddRow(theSheet,'SID,FIRST,LAST,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,EMAIL,ADDED,PID');
   SpreadSheetAddRows(theSheet,qry);
   SpreadSheetFormatColumn(theSheet,dfStyle,10);
  &lt;/cfscript&gt;
  </code></pre>
  
  <p>I'm trying to get a consistent mm/dd/yyyy format on the 'ADDED' column.  Instead, I'm getting that through row 31, and then getting dates like 41937.56594 on the of the rows.</p>
  
  <p><img src="https://i.stack.imgur.com/cuEYP.png" alt="enter image description here"></p>
  
  <p>In the formula bar I show "10/20/2014  12:25:23 PM" as the first value and "41932.552037037" as the 2nd value.</p>
  
  <p>If I format the date in the query (i.e. date_format(sp_add,'%c/%e/%Y') AS spadd) I do get a nice date format all the way down the column, but the blue still stops at row 32.</p>
  
  <p>Here is the cfoutput of the anonymized query - top row is formatted, bottom row loses formatting (background color - formatting dates in query).  I also dropped the ADDRESS2 column from the query for now.</p>
  
  <p><img src="https://i.stack.imgur.com/wfdKo.png" alt="enter image description here"></p>