title: comma in array element breaks spreadsheet
body: <p>When adding data to an array, one of the elements has commas in its value.  An example of the value is "Trim marks at 103, 96, and 90".</p>
  
  <p>Using the following code to add the array elements to the spreadsheet object, the partdescription element, as described above, has its data span multiple columns in the spreadsheet.  It is handled as separate elements and not one.</p>
  
  <pre><code>&lt;!---Create file name variable---&gt;
      &lt;cfset filenametouse = 'PartLevel_Report' /&gt;
      &lt;!---Set directory and full file path---&gt;
      &lt;cfset theDir = GetDirectoryFromPath(GetCurrentTemplatePath()) /&gt; 
      &lt;!---Attach file extension to full file path and file name---&gt;
      &lt;cfset theFile = theDir &amp; filenametouse &amp; ".xls" /&gt; 
  
      &lt;cflock name="fileActionSentItems" type="exclusive" timeout="30" throwontimeout="true"&gt;
          &lt;cfset SpreadsheetObj = spreadsheetNew()&gt;
          &lt;cfset fcol = {}&gt;
          &lt;cfset fcol.dataformat = "@"&gt;
  
          &lt;!---Create the column headings---&gt;
          &lt;cfset SpreadsheetAddRow(SpreadsheetObj, "Part ##, Reorder ##, Description, Bin ##, Current Inv., Staged, Allocations, Available Inv., Shelf Count, Total Shipped, Total ## of Stores, Total Ordered, Avg. Per Store, Lead Time (in days), Low Water Mark, Total ## of Stores Remaining")&gt;
  
              &lt;cfoutput query="getParts" group="partnum"&gt;
  
      &lt;cfset aColumns = [ partnum , shortchar08 , partdescription , binlist , inventory.currinv , staged.stagedqty , alloc.allocqty , available , shelfCount , shipdtl.shipqty , getNumberofStores.numStores , tordered , APS, paddedLeadTime, LWM , storesRemain] /&gt;
  
      &lt;!---add the column data to the spreadsheet---&gt;
      &lt;cfset SpreadsheetAddRow(SpreadsheetObj, ArrayToList(aColumns)) /&gt;
  &lt;/cfoutput&gt;
  
          &lt;!---Generate the spreadsheet---&gt;
          &lt;cfspreadsheet action="write" filename="#theFile#" name="SpreadsheetObj" sheetname="Sheet1" overwrite="true" /&gt;
  </code></pre>
  
  <p>How may I alleviate this issue?</p>
  
  <p>Solved: I set a variable to the partdescription with all commas replaced with semicolons.  Now the data appears all in the same column:</p>
  
  <pre><code> &lt;cfset cleanDesc = rereplace(partdescription, ",", ";", "all")&gt;
      &lt;cfset aColumns = [ partnum , shortchar08 , cleanDesc , binlist , inventory.currinv , staged.stagedqty , alloc.allocqty , available , shelfCount , shipdtl.shipqty , getNumberofStores.numStores , tordered , APS, paddedLeadTime, LWM , storesRemain] /&gt;
  </code></pre>