Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{description}
{excerpt}Sets or returns the default row height in points \(1/72 of an inch\). This must be between 0 and 409.{excerpt}
{signature:C#}
 public double StandardHeight{ get; set; }
{signature}{signature:vb.net}
Public Property StandardHeight() As Double
{signature}
{example}{code:csharp|title=C#}

          //--- Get StandardHeight
          ws.StandardHeight = 35;

          //--- Set StandardHeight
          double rowHeight = ws.StandardHeight;
        {code}
{code:vb.net|title=vb.net}

          '--- Get StandardHeight
          ws.StandardHeight = 35

          '--- Set StandardHeight
          Dim rowHeight As Double = ws.StandardHeight
        {code}

{example}
{remarks}
The default value of this property in Excel 2003 and earlier is 12.75.  In Excel 2007 and later, it is 15.  

In general, the default {{StandardHeight}} depends on the workbook's normal font.  If your workbook has a non-default font, the default {{StandardHeight}} will be slightly larger than the size of that font.  The default font in Excel 2003 and earlier is 10pt Arial; in Excel 2007 and later it is 11pt Calibri.
{remarks}