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)


<PersonalizableAttribute(PersonalizationScope.Shared)> _
<WebBrowsableAttribute(True)> _
Public Property AllowSorting As Boolean
Dim instance As ExcelWebRenderer
Dim value As Boolean

value = instance.AllowSorting

instance.AllowSorting = value
public bool AllowSorting { get; set; }

Property Value

Type: System.Boolean
true if sorting operations are allowed; otherwise, false. The default is true.


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.

See Also


ExcelWebRenderer Class

ExcelWebRenderer Members

Microsoft.Office.Excel.WebUI Namespace