ResetIfNoFilteredRow Property (FpSpread)

Gets or sets a value that indicates whether the filtered row list will be reset if there is no filtered row. Set this property to False to be compatible with version 6 or earlier.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ResetIfNoFilteredRow As Boolean

'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.ResetIfNoFilteredRow = value
 
value = instance.ResetIfNoFilteredRow

public bool ResetIfNoFilteredRow {get; set;}

Remarks

If the filtered row list is empty, the filter is reset, and Spread does not display the rows. If the ResetIfNoFilteredRow property is set to false, the rows are displayed.

Example

This example resets the filtered row list if no items meet the filter criteria.

FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
FpSpread1.ResetIfNoFilteredRow = True;

VB.NET

FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
FpSpread1.ResetIfNoFilteredRow = 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

FpSpread Class
FpSpread Members