[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

Name Representation

A formula can contain one or more names. These names shall be defined in the Worksheet part's XML with each being the subject of a definedName element, inside a definedNames element. [Example: Consider the scalar formula SUM(value1,value2). The corresponding XML might be as follows:

<definedNames>
<definedName name="value1" localSheetId="0">Sheet2!$B$2</definedName>
<definedName name="value2" localSheetId="0">Sheet2!$B$3</definedName>
</definedNames>

<c r="E5" s="0">
<f ce="1">SUM(value1,value2)</f>
<v>8</v>
</c>

end example]

Each name shall be the subject of an lpstr element in the Application-Defined File Properties part.

<TitlesOfParts>
<vt:vector … baseType="lpstr">
<vt:lpstr>Sheet1</vt:lpstr>
<vt:lpstr>Sheet2</vt:lpstr>
<vt:lpstr>Sheet3</vt:lpstr>
<vt:lpstr>value1</vt:lpstr>
<vt:lpstr>value2</vt:lpstr>
</vt:vector>
</TitlesOfParts>