Udostępnij za pośrednictwem


XmlMappedRange.ShowDetail Property (2007 System)

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

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property ShowDetail As Object
'Usage
Dim instance As XmlMappedRange 
Dim value As Object 

value = instance.ShowDetail

instance.ShowDetail = value
[BrowsableAttribute(false)]
public Object ShowDetail { get; set; }
[BrowsableAttribute(false)]
public:
property Object^ ShowDetail {
    Object^ get ();
    void set (Object^ value);
}
public function get ShowDetail () : Object 
public function set ShowDetail (value : Object)

Property Value

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

Remarks

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

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

  • The XmlMappedRange 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.

.NET Framework Security

See Also

Reference

XmlMappedRange Class

XmlMappedRange Members

Microsoft.Office.Tools.Excel Namespace