Skip to main content
.NET Framework 4.5.2+

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.v22.1.Core.dll

Declaration

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

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:

Library Object Type Path to AutoFitMergedCellRowHeight
WinForms Controls SpreadsheetControlOptions
.Cells.AutoFitMergedCellRowHeight
Office File API DocumentOptions
.Cells.AutoFitMergedCellRowHeight
WorkbookOptions
.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:

spreadsheetControl.Options.Cells.AutoFitMergedCellRowHeight = true;

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

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