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)

C#
C++
F#
VB
Copy 
property bool SaveSortOrder {
	bool get();
	void set(bool value);
}

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
Show: