Udostępnij za pośrednictwem

ListObject.SaveSortOrder Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

public:
 property bool SaveSortOrder { bool get(); void set(bool value); };
public bool SaveSortOrder { get; set; }
member this.SaveSortOrder : bool with get, set
Public Property SaveSortOrder As Boolean

Property Value

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.

Applies to