1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01085723"><META NAME="lcid" CONTENT="1033"><title>User Element</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>User Element</h1><p>
<p>Contains a work area for entering formulas in user-specific elements that are referred to by other elements and add-on tools.</p>
</p><h2>Syntax</h2><pre><code>
<User
[Name]
[NameU]
[Del]
[ID]>
</User>
</code></pre><h2>Attributes</h2><p><b class="bterm">Name</b></p><p>Optional string. The name of the element.</p><p><b class="bterm">NameU</b></p><p>Optional string. The universal name of the element.</p><p><b class="bterm">Del</b></p><p>Optional boolean. A flag indicating whether the element has been deleted locally. A value of 1 indicates that the element was deleted locally.</p><p><b class="bterm">ID</b></p><p>Optional int. The unique ID of the element within its parent element.</p><h2>Element properties</h2><table><tr><th>Property</th><th>Value</th></tr>
<tr><td>Name</td><td>User </td></tr>
<tr><td>Minimum Occurrences</td><td>0 </td></tr>
<tr><td>Maximum Occurrences</td><td>Unbounded </td></tr>
</table><h2>Element information</h2><p><b class="bterm">Parent elements</b></p><p><a href="vixmlelemPageSheet.htm" id="HV01085573" lcid=""><b class="bterm">PageSheet</b></a></p><p><a href="vixmlelemShape.htm" id="HV01085631" lcid=""><b class="bterm">Shape</b></a></p><p><a href="vixmlelemStyleSheet.htm" id="HV01085684" lcid=""><b class="bterm">StyleSheet</b></a></p><p><a href="vixmlelemDocumentSheet.htm" id="HV01085388" lcid=""><b class="bterm">DocumentSheet</b></a></p><p><b class="bterm">Child elements</b></p><p><a href="vixmlelemValue.htm" id="HV01085725" lcid=""><b class="bterm">Value</b></a></p><p><a href="vixmlelemPrompt.htm" id="HV01085610" lcid=""><b class="bterm">Prompt</b></a></p><h2>Remarks</h2><p>
<p>Like the <a href="vixmlelemScratch.htm" id="HV01085629" lcid=" "><b class="bterm">Scratch</b></a> element, the <b class="bterm">User</b> element can be used by your solution in many different ways. The advantage of the <b class="bterm">User</b> element is that the elements it contains can be named<nbsp />— elements in the <b class="bterm">Scratch</b> element cannot be named.</p>
<p>If your solution has a well-defined purpose, it is suggested that you use elements that can be named and therefore provide clarity, such as those contained in the <b class="bterm">User</b> element. Elements contained in the <b class="bterm">Scratch</b> element are typically used to isolate repeated complex calculations.</p>
<p>The <b class="bterm">Name</b>, <b class="bterm">NameU</b>, and <b class="bterm">ID</b> attributes of the <b class="bterm">User</b> element are optional; however, at least one of the three must be present in a <b class="bterm">User</b> element.</p>
<p>The <b class="bterm">User</b> element is relevant only when contained in a <a href="vixmlelemDocumentSheet.htm" id="HV01085388" lcid=" "><b class="bterm">DocumentSheet</b></a>, <a href="vixmlelemPageSheet.htm" id="HV01085573" lcid=" "><b class="bterm">PageSheet</b></a>, or <a href="vixmlelemShape.htm" id="HV01085631" lcid=" "><b class="bterm">Shape</b></a> element. It is ignored when contained in a <a href="vixmlelemStyleSheet.htm" id="HV01085684" lcid=" "><b class="bterm">StyleSheet</b></a> element.</p>
</p><h2>Example</h2><p></p><h2>See also</h2><p><a target="_blank" href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vissdk11/html/DSS_Sections_(S-Z)_1377.asp" id="HV82251377" lcid=" ">User-Defined Cells</a> section</p><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
