officefileapi-devexpress-dot-spreadsheet-dot-rowcollection-dot-unhide-x28-system-dot-int32-system-dot-int32-x29.md
Displays the hidden rows on a worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void Unhide(
int first,
int last
)
Sub Unhide(
first As Integer,
last As Integer
)
| 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.
|
Use the Unhide method to show multiple hidden rows at once. To display an individual row, set its Row.Visible property to true.
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.
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"];
' 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")
See Also