<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
p.MsoListBullet, li.MsoListBullet, div.MsoListBullet
{mso-style-priority:99;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
mso-add-space:auto;
text-indent:-18.0pt;
line-height:115%;
mso-list:l0 level1 lfo1;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpFirst, li.MsoListBulletCxSpFirst, div.MsoListBulletCxSpFirst
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-18.0pt;
line-height:115%;
mso-list:l0 level1 lfo1;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpMiddle, li.MsoListBulletCxSpMiddle, div.MsoListBulletCxSpMiddle
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
mso-add-space:auto;
text-indent:-18.0pt;
line-height:115%;
mso-list:l0 level1 lfo1;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-CA;}
p.MsoListBulletCxSpLast, li.MsoListBulletCxSpLast, div.MsoListBulletCxSpLast
{mso-style-priority:99;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
mso-add-space:auto;
text-indent:-18.0pt;
line-height:115%;
mso-list:l0 level1 lfo1;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-CA;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Term
{mso-style-name:Term;
font-style:italic;}
span.Element
{mso-style-name:Element;
font-family:"Calibri Light",sans-serif;}
span.Attribute
{mso-style-name:Attribute;
font-family:"Calibri Light",sans-serif;}
span.Attributevalue
{mso-style-name:"Attribute value";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:-119;
mso-list-type:simple;
mso-list-template-ids:492321126;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-style-link:"List Bullet";
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">DR is <a href="https://onedrive.live.com/view.aspx/Public%20Documents/2014/DR-14-0008.docx?cid=C8BA0861DC5E4ADC">
here</a>.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">The standard specifies the notation of the external references index in section 18.17.2.3, “Cell references”, as shown below (highlight is my own). So I think we should close this DR without action and report this information
back to the submitter.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Chris<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal">A <span class="Term">link</span> or <span class="Term">external reference</span> to a workbook is a reference that specifies the location of the workbook, including file or network path, book name, sheet name, and cell reference. Instead
of writing the full file path or network location and workbook name directly in the
<span class="Element">f </span>(formula) element, in order to make all external references more accessible, the workbook name shall be written in a Relationship part according to the Relationships semantic:<o:p></o:p></p>
<p class="MsoListBulletCxSpFirst" style="mso-list:none"><span class="Attributevalue"><span lang="EN-CA" style="font-size:10.0pt;line-height:115%;font-family:Symbol">·
</span></span><span class="Attribute"><span lang="EN-CA">Type</span></span><span lang="EN-CA"> shall be set to http://purl.oclc.org/ooxml/officeDocument/relationships/externalLinkPath</span><span class="Attributevalue"><span lang="EN-CA" style="font-size:10.0pt;line-height:115%">,</span></span><span class="Attributevalue"><span lang="EN-CA" style="font-size:10.0pt;line-height:115%"><o:p></o:p></span></span></p>
<p class="MsoListBulletCxSpMiddle" style="mso-list:none"><span lang="EN-CA" style="font-family:Symbol">·
</span><span class="Attribute"><span lang="EN-CA">Target</span></span><span lang="EN-CA"> shall specify the full file path and file name, and<o:p></o:p></span></p>
<p class="MsoListBulletCxSpLast" style="mso-list:none"><span lang="EN-CA" style="font-family:Symbol">·
</span><span class="Attribute"><span lang="EN-CA">TargetMode</span></span><span lang="EN-CA"> shall be set to
</span><span class="Attributevalue"><span lang="EN-CA" style="font-size:10.0pt;line-height:115%">External</span></span><span lang="EN-CA">.<o:p></o:p></span></p>
<p class="MsoNormal">Additionally, in order to support the possibility that the external workbook is offline or otherwise inaccessible, a cache of the relevant sheet values in the referenced external workbook shall be stored within the referencing workbook
according to §18.14. <o:p></o:p></p>
<p class="MsoNormal">This Supplementary Workbook Data part shall be the source part of the relationship that points to the external workbook as a target resource, and the Id of this relationship shall be referenced within the markup of the Supplementary Workbook
Data part, using the <span class="Element">externalBook</span> element (§18.14.7).<o:p></o:p></p>
<p class="MsoNormal">The Supplementary Workbook Data part shall also be the target of a relationship whose source is the Workbook part (§18.2). The markup within the Workbook part shall reference this relationship Id using the
<span class="Element">externalReference</span> element (§18.2.8).<o:p></o:p></p>
<p class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">Finally, a 1-based index referencing an
</span><span class="Element"><span style="background:yellow;mso-highlight:yellow">externalReference</span></span><span style="background:yellow;mso-highlight:yellow"> within the collection
</span><span class="Element"><span style="background:yellow;mso-highlight:yellow">externalReferences</span></span><span style="background:yellow;mso-highlight:yellow"> shall be written inline within the formula expression containing the reference to the external
workbook. The index in this context shall be enclosed within square brackets, i.e.; left square bracket ([), followed by the index, followed by a right square bracket (]).</span><o:p></o:p></p>
<p class="MsoNormal">In this way, external resource files can more easily be accessed and updated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>