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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01107512"><META NAME="lcid" CONTENT="1033"><title>calculatedField 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><p id="ExpandAllLine" class="ExpFav"><a href="#" onclick="ExpandAll()" onkeypress="ExpandAll()" class="DropDown"><img id="picHeader" border="0" src="expandtri.gif" alt="Show All"><span id="ExpandAll">Show All</span></a></p><h1>calculatedField Element</h1><div class="ofvbanav"><span class="ofvbanavreuse" id="seealso" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="parentelements" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="childelements" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="attributeslinks" onclick="toggleList()" onkeypress="toggleList()"></span></div><p>Defines an individual calculation, including the <a href="#" class="glossary" onclick="AppendPopup(this,'xdformula')" onkeypress="AppendPopup(this,'xdformula')">formula</a>, when the calculation is to be performed, and where the result will be stored.</p><h2>Type</h2><p><code>xsd:complexType</code></p><h2>Child Elements</h2><p>None.</p><h2>Attributes</h2><table>
<tr>
<th>Attribute</th>
<th>Type</th>
<th>Required</th>
<th>Description</th>
<th>Possible Values</th>
</tr>
<tr>
<td><a href="xsfatrtarget_calculatedField_HV01107639.htm" id="HV01107639" lcid=""><b class="bterm">target</b></a></td>
<td><code>xsd:string</code></td>
<td>Yes</td>
<td>Contains the <a href="#" class="glossary" onclick="AppendPopup(this,'xdxpath')" onkeypress="AppendPopup(this,'xdxpath')">XPath</a> location where the result of the expression will be stored.</td>
<td>string</td>
</tr>
<tr>
<td><a href="xsfatrexpression_calculatedField_HV01107595.htm" id="HV01107595" lcid=""><b class="bterm">expression</b></a></td>
<td><code>xsd:string</code></td>
<td>Yes</td>
<td>Contains the <a href="#" class="glossary" onclick="AppendPopup(this,'xdformula')" onkeypress="AppendPopup(this,'xdformula')">formula</a>, in the form of an <a href="#" class="glossary" onclick="AppendPopup(this,'xdxpath')" onkeypress="AppendPopup(this,'xdxpath')">XPath</a> expression, to be evaluated. The result is stored in the target location.</td>
<td>string</td>
</tr>
<tr>
<td><a href="xsfatrrefresh_HV01107626.htm" id="HV01107626" lcid=""><b class="bterm">refresh</b></a></td>
<td><code>xsd:string</code></td>
<td>Yes</td>
<td>Specifies when the expression will be evaluated.</td>
<td><ul><li>onInit</li><li>onChange</li></ul></td>
</tr>
</table><h2>Definition</h2><pre><code><xsd:element name="calculatedField">
<xsd:complexType>
<xsd:attribute name="target" type="xsd:string" use="required"></xsd:attribute>
<xsd:attribute name="expression" type="xsd:string" use="required"></xsd:attribute>
<xsd:attribute name="refresh" type="xsd:string" use="required"></xsd:attribute>
</xsd:complexType>
</xsd:element>
</code></pre><h2>Remarks</h2><p><p><b>Note</b> This item is not supported when the <b class="ui">Disable Service Pack features</b> option on the <b class="ui">Advanced</b> tab of the <b class="ui">Options</b> dialog box in InfoPath is selected or when Microsoft Office 2003 Editions Service Pack 1 or later is not installed. Any form defined by a form definition file (.xsf) that includes this item cannot be opened in InfoPath when service pack features are disabled or unavailable.</p></p><h2><a id="#example" name="#example">Example</a></h2><p>The following is an example of the <b class="bterm">calculatedField</b> element:</p><pre><code><xsf:calculations>
<xsf:<b class="bterm">calculatedField</b>
target="/my:myFields/my:average"
expression="xdMath:Avg(../my:expenses/my:expense/my:amount)"
refresh="onChange"/>
</xsf:calculations></code></pre><script type="text/javascript" language="JScript" src="ofvbanl.js"></script><span id="ofVBAISpan" class="ofvbaispan"><iframe id="ofVBAIFrame" frameborder="0" marginheight="0" marginwidth="4" scrolling="auto" width="100%" src="../links/xsfelmcalculatedField_HV01107512_l.htm"></iframe></span><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>
|
