ExcelWebRenderer.AllowSorting Property
Allows users to sort when using autofilter, table, and PivotTables.
Namespace: Microsoft.Office.Excel.WebUI
Assembly: Microsoft.Office.Excel.WebUI (in Microsoft.Office.Excel.WebUI.dll)
Syntax
'Declaration
<WebPartStorageAttribute(Storage.Shared)> _
<PersonalizableAttribute(PersonalizationScope.Shared)> _
<WebBrowsableAttribute(True)> _
Public Property AllowSorting As Boolean
Get
Set
'Usage
Dim instance As ExcelWebRenderer
Dim value As Boolean
value = instance.AllowSorting
instance.AllowSorting = value
[WebPartStorageAttribute(Storage.Shared)]
[PersonalizableAttribute(PersonalizationScope.Shared)]
[WebBrowsableAttribute(true)]
public bool AllowSorting { get; set; }
Property Value
Type: System.Boolean
true if PivotTable-related operations are allowed; otherwise, false. The default is true.
Remarks
The user interfaces' entry points are hidden and all sorting functionalities in the user interfaces are disabled if this property is set to false. The sorting functionalities that are disabled are:
Autofilter
table
PivotTables
When this property is set to false, sorting that is already applied to the workbook is still displayed.