SpreadsheetGear The Performance Spreadsheet Component Company 
AutoFit Method
See Also  Example
SpreadsheetGear Namespace > IRange Interface : AutoFit Method
Automatically sets the width of the specified columns or the height of the specified rows.

Syntax

C# 
virtual void AutoFit()

Example

C#Copy Code
// Automatically set the width on columns B and C. 
worksheet.Cells["B:C"].Columns.AutoFit(); 
  
// Set the row height to automatic on rows 7 through 9. 
worksheet.Cells["7:9"].Rows.AutoFit(); 
    
Visual BasicCopy Code
' Automatically set the width on columns B and C.
worksheet.Cells("B:C").Columns.AutoFit()

' Set the row height to automatic on rows 7 through 9.
worksheet.Cells("7:9").Rows.AutoFit()

Remarks

Whan IRange.AutoFit is used on columns, the width of the columns is set to the appropriate width immediately. However, for rows, the height is set to the default height and a flag is set indicating that the row height is automatic, and Excel will actually set the height when the row is displayed.

Requirements

Platforms: Windows 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also