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)

bool SaveSortOrder { get; set; }

Property Value

Type: System.Boolean

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

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.

Return to top