다음을 통해 공유

NamedRange.ShowDetail Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.dll

Gets or sets an object that indicates whether the outline is expanded for the NamedRange control (so that the detail of the column or row is visible).

public:
 property System::Object ^ ShowDetail { System::Object ^ get(); void set(System::Object ^ value); };
public object ShowDetail { get; set; }
member this.ShowDetail : obj with get, set
Public Property ShowDetail As Object

Property Value

Object

true if the outline is expanded for the specified range (so that the detail of the column or row is visible); otherwise, false.

Remarks

The NamedRange control must contain a single summary column or row in an outline.

If the NamedRange control is in a PivotTable report, this property is set to true if the item is showing detail.

If the NamedRange control is not in a PivotTable report, the following statements are true:

  • The NamedRange control must be in a single summary row or column.

  • This property returns false if any of the children of the row or column are hidden.

  • Setting this property to true is equivalent to showing all the children of the summary row or column.

  • Setting this property to false is equivalent to hiding all the children of the summary row or column.

  • If the NamedRange control is in a PivotTable report, it is possible to set this property for more than one cell at a time. This property can be returned only if the NamedRange control is a single cell.

Applies to