title: How to create a cfspreadsheet with protected cells
body: <p>I am creating a spreadsheet object using cfspreadsheet. Would like to make some of the individual cells as protected (read-only). Please let me know if anybody has tried this before.</p>
  
  <p>I did try putting cell format as locked but it did not seems to work. Here is the sample code:</p>
  
  <pre><code>&lt;cfset a = spreadsheetnew()&gt;
  &lt;cfset format1 = structNew()&gt;
  &lt;cfset format1.locked=true&gt;
  &lt;cfset SpreadsheetFormatCell(a,format1,1,1)&gt;
  &lt;cfspreadsheet action="write" filename="#expandpath('.')#/test.xls" name="a" overwrite="true"&gt;
  </code></pre>
  
  <p>Thanks.</p>