ListObject.SaveSortOrder Property (2007 System)
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.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public Property SaveSortOrder As Boolean
'Usage
Dim instance As ListObject
Dim value As Boolean
value = instance.SaveSortOrder
instance.SaveSortOrder = value
public bool SaveSortOrder { get; set; }
public:
property bool SaveSortOrder {
bool get ();
void set (bool value);
}
public function get SaveSortOrder () : boolean
public function set SaveSortOrder (value : boolean)
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
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.
See Also
Reference
Microsoft.Office.Tools.Excel Namespace