Share via


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.

See Also

Reference

ExcelWebRenderer Class

ExcelWebRenderer Members

Microsoft.Office.Excel.WebUI Namespace