RowCollection.Unhide(Int32, Int32) Method

Displays the hidden rows on a worksheet.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void Unhide(
    int first,
    int last
)

VB.NET

Sub Unhide(
    first As Integer,
    last As Integer
)

Parameters

Name	Type	Description
first	Int32	A zero-based integer representing the index of the first row to be unhidden.
last	Int32	A zero-based integer representing the index of the last row to be unhidden.

Remarks

Use the Unhide method to show multiple hidden rows at once. To display an individual row, set its Row.Visible property to true.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Unhide(Int32, Int32) method.

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#

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.cs#L137

if (!sheet.Rows[4].Visible)
    sheet.Rows.Unhide(2, 9);
spreadsheetControl.SelectedCell = sheet["C4"];

winforms-spreadsheet-bind-to-ms-sql-server-database/CS/SuppliersExample/Form1.cs#L116

if (!sheet.Rows[4].Visible)
    sheet.Rows.Unhide(2, 9);
spreadsheetControl1.SelectedCell = sheet["C4"];

VB.NET

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/VB/WpfSpreadsheet_BindToDataSource/MainWindow.xaml.vb#L116

' Display the data entry form on the worksheet to add a new record to the "Suppliers" data table.
If Not sheet.Rows(4).Visible Then sheet.Rows.Unhide(2, 9)
Me.spreadsheetControl.SelectedCell = sheet("C4")

winforms-spreadsheet-bind-to-ms-sql-server-database/VB/SuppliersExample/Form1.vb#L110

' Display the data entry form on the worksheet to add a new record to the "Suppliers" data table.
If Not sheet.Rows(4).Visible Then sheet.Rows.Unhide(2, 9)
spreadsheetControl1.SelectedCell = sheet("C4")