PivotField.PropertyOrder Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Valid only for PivotTable fields that are member property fields. Returns an Integer indicating the display position of the member property within the cube field to which it belongs. Read/write.

public:
 property int PropertyOrder { int get(); void set(int value); };

public int PropertyOrder { get; set; }

Public Property PropertyOrder As Integer

Property Value

Int32

Remarks

Setting this property will rearrange the order of the properties for this cube field. This property is one-based. The allowable range is from one to the maximum number of member property fields being displayed for the hierarchy.

If the IsMemberProperty property is False, using the PropertyOrder property will create a run-time error.

Applies to