title: How can I set the row height for a defined name (range) in Spreadsheet Light?
body: <p>I am trying to convert Excel Interop code to Spreadsheet Light. The legacy Interop code I want to emulate is:</p>
  
  <pre><code>var columnHeaderRowRange = _xlSheetFillRateByDistributorByCustomer.Range[
      _xlSheetFillRateByDistributorByCustomer.Cells[1, 1],
      _xlSheetFillRateByDistributorByCustomer.Cells[1, 16]];
  columnHeaderRowRange.Interior.Color = Color.LightBlue;
  columnHeaderRowRange.RowHeight = 12;
  columnHeaderRowRange.Font.Bold = true;
  columnHeaderRowRange.Font.Size = 11;
  </code></pre>
  
  <p>I'm creating a defined name (new designation, or Spreadsheet Light's description, of a range) like so, in Spreadsheet Light-ese:</p>
  
  <pre><code>SLDocument sl;
  . . .
  sl.SetDefinedName("columnHeaderRowRange", "Sheet1!$A$1:$P$4");
  </code></pre>
  
  <p>I would think I could set the row height for the range something like this:</p>
  
  <pre><code>sl.SetRowHeight("columnHeaderRowRange", 12);
  </code></pre>
  
  <p>...but that doesn't work; the first arg must be an int (row index).</p>
  
  <p>So I thought maybe I could add it to a style that I could then apply to the defined name:</p>
  
  <pre><code>SLStyle headerStyle = sl.CreateStyle();
  </code></pre>
  
  <p>..and then apply that style to the defined name like so:</p>
  
  <pre><code>sl.SetCellStyle("columnHeaderRowRange", headerStyle); // Remember Merle Haggard!    
  </code></pre>
  
  <p>...but I see no properties in SLStyle that will allow me to do that, either.</p>
  
  <p>How can I control the height of all the rows within a defined name?</p>
  
  <p>I think I have everything from the Excel Interop range converted over besides that in my style:    </p>
  
  <pre><code>headerStyle.Fill.SetPattern(DocumentFormat.OpenXml.
      Spreadsheet.PatternValues.Solid, Color.Black, Color.LightBlue);
  headerStyle.Font.Bold = true;
  headerStyle.Font.FontSize = 12;
  </code></pre>