ListObject.SaveSortOrder Property

Gets or sets a value that indicates whether the row order of the ListObject control is saved in the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property SaveSortOrder As Boolean
bool SaveSortOrder { get; set; }

Property Value

Type: System.Boolean
true to save the row order in the worksheet; otherwise, false. The default is false.

Remarks

This property only applies to ListObject controls that are bound to data.

If you do not set this property, the row order of the ListObject will match the row order of the data source the next time the workbook is opened, even if the user made changes to the sorting and saved the workbook.

.NET Framework Security

See Also

Reference

ListObject Interface

Microsoft.Office.Tools.Excel Namespace