Range.ShowDetail Property
Definition
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.
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
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기