SetRegion(String,CellReferenceMode) Method

Sets the region where the filter settings should be applied

Syntax

C#

public void SetRegion( 
   string address,
   CellReferenceMode cellReferenceMode
)

Parameters

address

The address of the new region.

cellReferenceMode

The reference to use the parse the address.

Exceptions

Exception	Description
System.InvalidOperationException	If the region intersects with a table of other reserved area in the worksheet.

Remarks

Note: setting the region will clear any applied filters or sort criteria.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+