Export (0) Print
Expand All
Expand Minimize

NamedRange.ShowDetail Property

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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).

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Object ShowDetail { get; set; }

Property Value

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

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.

Show:
© 2014 Microsoft