IgnoreHiddenRowsWhenPaging Property

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

Syntax

Visual Basic
C#

'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;

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members