Range.ShowDetail Property

Definition

Returns True if the outline is expanded for the specified range (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; }
Public Property ShowDetail As Object

Property Value

Remarks

The specified range must be a single summary column or row in an outline.

If the range is in a PivotTable report, this property is set to True if the item is showing detail.

If the specified range isn’t in a PivotTable report, the following statements are true:

  • The range 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 specified range is in a PivotTable report, it’s possible to set this property for more than one cell at a time if the range is contiguous. This property can be returned only if the range is a single cell.

This property isn’t available for OLAP data sources.

Applies to