XlsExportOptionsEx.AllowSortingAndFiltering Property

Gets or sets whether columns’ sorting and filtering functionality is enabled in the exported document.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

[DefaultValue(DefaultBoolean.Default)]
public DefaultBoolean AllowSortingAndFiltering { get; set; }

VB.NET

<DefaultValue(DefaultBoolean.Default)>
Public Property AllowSortingAndFiltering As DefaultBoolean

Property Value

Type	Default	Description
DefaultBoolean	Default	A value that specifies whether the sorting and filtering functionality is enabled for columns in the exported document.

Available values:

Name	Description	Return Value
True	The value is true.	0
False	The value is false.	1
Default	The value is specified by a global option or a higher-level object.	2

Remarks

The DefaultBoolean.Default value of the AllowSortingAndFiltering property is equivalent to True.

Note

Regardless of the AllowSortingAndFiltering setting, the filtering and sorting functionality is disabled in the output document when data is exported from Advanced Banded Grid Views (these Views allow columns to be arranged one under another).