IgnoreHiddenRowsWhenPaging Property

Gets or sets if the hidden rows are ignored when paging.

Syntax

'Declaration
 
Public Property IgnoreHiddenRowsWhenPaging As Boolean

'Usage
 
Dim instance As SheetView
Dim value As Boolean
 
instance.IgnoreHiddenRowsWhenPaging = value
 
value = instance.IgnoreHiddenRowsWhenPaging

public bool IgnoreHiddenRowsWhenPaging {get; set;}

Remarks

This property will also work on rows that have been hidden by filtering.

Example

This example sets the IgnoreHiddenRowsWhenPaging property.

FpSpread1.Sheets[0].RowCount = 40;
FpSpread1.Sheets[0].Rows[9].Visible = false;
FpSpread1.Sheets[0].IgnoreHiddenRowsWhenPaging = true;

FpSpread1.Sheets(0).RowCount = 40
FpSpread1.Sheets(0).Rows(9).Visible = False
FpSpread1.Sheets(0).IgnoreHiddenRowsWhenPaging = True