NamedRange.ShowDetail Property

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)

Syntax

'Declaration
Property ShowDetail As Object
    Get
    Set
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.

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.

.NET Framework Security

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace