SpreadsheetCellOptions.AutoFitMergedCellRowHeight Property

Indicates whether the row height can be automatically adjusted for cells that are merged across a row and contain wrapped text.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[DefaultValue(false)]
public bool AutoFitMergedCellRowHeight { get; set; }

VB.NET

<DefaultValue(False)>
Public Property AutoFitMergedCellRowHeight As Boolean

Property Value

Type	Default	Description
Boolean	false	true to automatically adjust the height of a row that has cells merged across; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AutoFitMergedCellRowHeight
DocumentOptions	.Cells .AutoFitMergedCellRowHeight

Remarks

When you merge a cell that contains wrapped text with the other cells in a row, the height of the resulting merged cell cannot be adjusted automatically to accommodate cell content. To avoid this behavior and enable AutoFit for rows that have cells merged across, set the AutoFitMergedCellRowHeight property to true.

The following code snippet demonstrates how to enable the AutoFitMergedCellRowHeight option for the WinForms Spreadsheet control:

C#

spreadsheetControl.Options.Cells.AutoFitMergedCellRowHeight = true;

VB.NET

spreadsheetControl.Options.Cells.AutoFitMergedCellRowHeight = True

Use the code below to activate this option for a non-visual Workbook instance.

C#

using(var workbook = new Workbook())
{
    workbook.Options.Cells.AutoFitMergedCellRowHeight = true;
}

VB.NET

Using workbook As New Workbook()
    workbook.Options.Cells.AutoFitMergedCellRowHeight = True
End Using