Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Row Class / AutoFit Method / AutoFit(Double,Double,String,String) Method

The minimum desired Height when auto-fitting a Row.

The default value is 0 point.

The maximum desired Height when auto-fitting a Row.

The default value is 409 points.

The string Id corresponding to the Column used as the starting point of the range affected by the AutoFit process.

The default is A, which is the first Column in a Row.

The string Id corresponding to the Column used as the ending point of the range affected by the AutoFit process.

The default value is XFD, which is the last possible Column in a Row.



In This Topic
    AutoFit(Double,Double,String,String) Method
    In This Topic
    Identifies the start & end of the range affected by the AutoFit process by using string Ids.
    Syntax
    'Declaration
     
    
    Public Overloads Sub AutoFit( _
       Optional ByVal minimumHeight As Double, _
       Optional ByVal maximumHeight As Double, _
       Optional ByVal startColumnId As String, _
       Optional ByVal endColumnId As String _
    ) 
    'Usage
     
    
    Dim instance As Row
    Dim minimumHeight As Double
    Dim maximumHeight As Double
    Dim startColumnId As String
    Dim endColumnId As String
     
    instance.AutoFit(minimumHeight, maximumHeight, startColumnId, endColumnId)

    Parameters

    minimumHeight

    The minimum desired Height when auto-fitting a Row.

    The default value is 0 point.

    maximumHeight

    The maximum desired Height when auto-fitting a Row.

    The default value is 409 points.

    startColumnId

    The string Id corresponding to the Column used as the starting point of the range affected by the AutoFit process.

    The default is A, which is the first Column in a Row.

    endColumnId

    The string Id corresponding to the Column used as the ending point of the range affected by the AutoFit process.

    The default value is XFD, which is the last possible Column in a Row.

    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also