Row.Height Property

Gets or sets the row height in units of measurement used in the workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

double Height { get; set; }

VB.NET

Property Height As Double

Property Value

Type	Description
Double	A Double value that is the row height in units of measurement that are in effect.

Remarks

To automatically fit the column width to the content, call the Row.AutoFit method.

Example

This example demonstrates how to control the row height on a worksheet.

• Set Height for Individual Rows

  Use the row’s Row.Height property or the CellRange.RowHeight property of the cell or cell range object to set the row height in the workbook’s units of measure.

  Note

  If the row height is set to 0, the row is hidden. You can also use the Row.Visible property to hide a row or display the hidden row again (see How to: Show or Hide a Row or Column).

• AutoFit Row Height

  To automatically change the row height to fit the contents, use the row’s Row.AutoFit method. To quickly autofit several rows on a worksheet, use the RowCollection.AutoFit method.

  Use the SpreadsheetCellOptions.AutoFitMergedCellRowHeight property to enable the AutoFit functionality for rows that have cells merged across and containing wrapped text.

• Match the Height of Two Rows

  To match one row height to another, make their Row.Height property values equal.

• Set the Default Row Height

  To set the default height for worksheet rows, use the Worksheet.DefaultRowHeight property. This property does not affect rows with an explicitly specified height.

• Set the Height for All Rows on a Worksheet

  To change the height of all rows on a worksheet, use the CellRange.RowHeight property of the Column object corresponding to any column on a worksheet. This sets the height of all rows to the same value, overriding all previously applied row height settings.

View Example

RowAndColumnActions.cs

// Set the height of the 3rd row to 50 points
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Rows[2].Height = 50;

// Set the height of the row that contains the "C5" cell to 2 inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
worksheet.Cells["C5"].RowHeight = 2;

// Set the height of the 7th row to the height of the 3rd row.
worksheet.Rows["7"].Height = worksheet.Rows["3"].Height;

// Set the default row height to 30 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.DefaultRowHeight = 30;

RowAndColumnActions.vb

' Set the height of the 3rd row to 50 points
workbook.Unit = DevExpress.Office.DocumentUnit.Point
worksheet.Rows(2).Height = 50

' Set the height of the row that contains the "C5" cell to 2 inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch
worksheet.Cells("C5").RowHeight = 2

' Set the height of the 7th row to the height of the 3rd row.
worksheet.Rows("7").Height = worksheet.Rows("3").Height

' Set the default row height to 30 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point
worksheet.DefaultRowHeight = 30

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Height property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs#L98

worksheet.Cells["A2"].Value = "Row 2";
worksheet.Rows["2"].Height = 150;
worksheet.Rows["2"].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/CS/DevAVInvoicing/Form1.cs#L185

sheet.Rows.Insert(rowIndex);
sheet.Rows[rowIndex].Height = sheet.Rows[rowIndex + 1].Height;
CellRange range = invoiceItems.Range;

VB.NET

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.vb#L101

worksheet.Cells("A2").Value = "Row 2"
worksheet.Rows("2").Height = 150
worksheet.Rows("2").Alignment.Vertical = SpreadsheetVerticalAlignment.Center

how-to-use-custom-cell-editors-to-create-a-data-entry-form-t419595/VB/DevAVInvoicing/Form1.vb#L191

sheet.Rows.Insert(rowIndex)
sheet.Rows(rowIndex).Height = sheet.Rows(rowIndex + 1).Height
Dim range As CellRange = invoiceItems.Range

winforms-spreadsheetcontrol-api-part1/VB/SpreadsheetControl/SpreadsheetActions/RowAndColumnActions.vb#L113

worksheet.Cells("A2").Value = "Row 2"
worksheet.Rows("2").Height = 50
worksheet.Rows("2").Alignment.Vertical = SpreadsheetVerticalAlignment.Center

wpf-spreadsheetcontrol-api-part-1-e4938/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/RowAndColumnActions.vb#L112

worksheet.Cells("A2").Value = "Row 2"
worksheet.Rows("2").Height = 50
worksheet.Rows("2").Alignment.Vertical = SpreadsheetVerticalAlignment.Center