SubAddress Element

Specifies a location within the target document to link to.

For example, for a given Hyperlink element:

Syntax


<SubAddress>
    [Unit]
    [F]
    [Err]
    [V]>
</SubAddress>

Attributes

Unit

Optional string. Represents a unit of measure. The default is STR. For details about STR, see Units of measure.

F

Optional string. Represents the element's formula. This attribute can contain one of the following strings: "someFormula" if the formula exists locally, "No Formula" if the formula is locally deleted or blocked, or "Inh" if the formula is inherited.

If the attribute is not present, the element's formula is a simple constant, for example, <element>5</element>.

Err

Optional string. Indicates that the formula evaluates to an error. The value of Err is the current value (an error message string); the value of the element is the last valid value.

V

Optional string. Represents the null string condition for a string cell value. In some cases it is helpful to distinguish between an empty string cell null and a null string cell value. This attribute is used to distinguish between these forms of an empty value.

Element properties

PropertyValue
NameSubAddress
Minimum Occurrences0
Maximum Occurrences1

Element information

Parent elements

Hyperlink

Child elements

None

Remarks

The SubAddress element is relevant only when contained in a DocumentSheet, PageSheet, or Shape element. It is ignored when contained in a StyleSheet element.

See also

SubAddress cell (Hyperlinks section)

©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp