Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

XmlMappedRange.ShowPrecedents Method

Draws tracer arrows to the direct precedents of the XmlMappedRange control.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public Object ShowPrecedents (
	[OptionalAttribute] Object Remove
)

Parameters

Remove

true to remove one level of tracer arrows to direct precedents; false to expand one level of tracer arrows. The default value is false.

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

The following code example makes cell A1 a precedent of an XmlMappedRange. The example then uses the ShowPrecedents method to draw an arrow between an XmlMappedRange and the precedent cell. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerAddress1Cell with a corresponding schema element of type int.

private void DisplayPrecedents()
{
    this.Range["A1", missing].Value2 = 1710;
    this.CustomerAddress1Cell.Value2 = "=A1";
    this.CustomerAddress1Cell.ShowPrecedents(false);
}

Show:
© 2015 Microsoft