<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=utf-8">
<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;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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;}
--></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="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">No – localSheetId is a lookup into sheetId values elsewhere.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Chris<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> eb2mmrt@gmail.com [mailto:eb2mmrt@gmail.com]
<b>On Behalf Of </b>MURATA Makoto<br>
<b>Sent:</b> 09 February 2015 14:47<br>
<b>To:</b> Chris Rae<br>
<b>Cc:</b> e-SC34-WG4@ecma-international.org<br>
<b>Subject:</b> Re: DR 14-0013 — SML: definedName attribute localSheetId<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Thanks. This is much better. Should localSheetId be sheetId?<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Makoto<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">2015-02-10 3:15 GMT+09:00 Chris Rae <<a href="mailto:Chris.Rae@microsoft.com" target="_blank">Chris.Rae@microsoft.com</a>>:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Thanks for taking a look at this! That's a good idea - I was struggling a bit with how to talk about local-scoped names which referred to references on different sheets without over-complicating the text.<br>
<br>
I've updated the example to include the sheet definition, and changed it to refer to a locally-scoped name with a local reference. I think that should make it significantly clearer.<br>
<br>
Revised version attached.<br>
<br>
Chris<br>
<br>
From: <a href="mailto:eb2mmrt@gmail.com">eb2mmrt@gmail.com</a> [mailto:<a href="mailto:eb2mmrt@gmail.com">eb2mmrt@gmail.com</a>] On Behalf Of MURATA Makoto<br>
Sent: 07 February 2015 02:00<br>
To: <a href="mailto:e-SC34-WG4@ecma-international.org">e-SC34-WG4@ecma-international.org</a><br>
Subject: Re: DR 14-0013 — SML: definedName attribute localSheetId<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><br>
Chris,<br>
<br>
I do not understand what is meant by "The sheet element with<br>
localSheetId equal to the value of this attribute". An<br>
example of such a sheet element would be nice as part of<br>
the first example.<br>
<br>
Regards,<br>
Makoto<br>
<br>
<br>
2015-02-07 2:59 GMT+09:00 Chris Rae <<a href="mailto:Chris.Rae@microsoft.com">Chris.Rae@microsoft.com</a>>:<br>
<a href="https://onedrive.live.com/view.aspx/Public%20Documents/2014/DR-14-0013.docx?cid=C8BA0861DC5E4ADC" target="_blank">https://onedrive.live.com/view.aspx/Public%20Documents/2014/DR-14-0013.docx?cid=C8BA0861DC5E4ADC</a><br>
<br>
This DR concerns the localSheetID attribute of the SpreadsheetML definedName element, and states that the attribute's meaning is unclear.<br>
<br>
After looking into this, I think the submitter is right and that it's not at all clear what this attribute is intended to represent. I've attached some proposed changes to the standard. A couple of notes:<br>
<br>
* I think that the example mentioned by the submitter is poorly chosen. It mention a "data source" and "external database" - the submitter is correct that this isn't the defined name required for a SpreadsheetML data connected range, and really I don't think
any mention should be made of external data as it complicates the example and isn't relevant. I've reworded it as such.<br>
* Revision records also contain defined names with the same attribute - they have much better descriptions. For example, in 18.11.1.13, the localSheetId is described as " An integer representing the id of the sheet to which this defined name belongs. This shall
be used local defined names only." (sic)<br>
* I notice that Microsoft's MS-OI29500 implementer notes (<a href="https://msdn.microsoft.com/en-us/library/ee908652(v=office.12).aspx" target="_blank">https://msdn.microsoft.com/en-us/library/ee908652(v=office.12).aspx</a>) already cover Excel's behaviour
with this attribute - as the standard is not well-defined at all, many of my changes are from there.<br>
<br>
Chris<br>
<br>
<br>
<br>
<br>
--<br>
<br>
Praying for the victims of the Japan Tohoku earthquake<br>
<br>
Makoto<o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
Praying for the victims of the Japan Tohoku earthquake<br>
<br>
Makoto<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>