<html defang_xmlns:v="urn:schemas-microsoft-com:vml" defang_xmlns:o="urn:schemas-microsoft-com:office:office" defang_xmlns:w="urn:schemas-microsoft-com:office:word" defang_xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" defang_xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:KO;}
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;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xxmsonormal, li.xxmsonormal, div.xxmsonormal
{/*mso-style-name:x_xmsonormal;*/
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--/*SC*/[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]/*EC*/--><!--/*SC*/[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]/*EC*/--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='mso-fareast-language:EN-US'>From:</span></b><span style='mso-fareast-language:EN-US'> Alfred Hellstern <Alfred.Hellstern@microsoft.com> <br><b>Sent:</b> Monday, October 15, 2018 7:05 PM<br><b>To:</b> Rex Jaeschke <rex@RexJaeschke.com><br><b>Subject:</b> 17-0029 -- response -- SML: Quoting of Worksheet Names Containing Periods<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=xxmsonormal><b><span style='font-size:12.0pt;color:black'>17-0029 </span></b>– the response here is:<b><span style='font-size:12.0pt;color:black'><o:p></o:p></span></b></p><p class=MsoNormal style='margin-left:35.4pt'>2018-10-15 MS Experts via Alfred:<o:p></o:p></p><p class=xxmsonormal><o:p> </o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;color:black'>Implementor note referenced in our previous response is also present in the standard in section 18.17.2.3. So the location issue Charlie mentioned should already be addressed. The regex Charlie has is mostly incomplete around its specification of operators, which he only covers a handful of. Given that the rest of the formula syntax is EBNF specified we would recommend maintaining consistency on that point. Given that our proposal here is to amend this section of the EBNF as indicated below.</span><span style='font-size:12.0pt'> </span>In addition there are some special cases that xl requires quoting. Sheets named “R”, “C”, “TRUE”, or “FALSE” (case-insensitive) require quoting.<o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;color:black'> </span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:black'>sheet-name=</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><span style='font-size:12.0pt;font-family:Consolas;color:black'>sheet-name-characters ;</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:black'>sheet-name-character=</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><span style='font-size:12.0pt;font-family:Consolas;color:black'>character – (operator | apostrophe | "[" | "]" | "\" | "?" </span><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'>| “;” | “{“ | “}” | “(“ | “)” </span><span style='font-size:12.0pt;font-family:Consolas;color:black'>) ;</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><span style='font-size:12.0pt;font-family:Consolas;color:black'>(* any character except operator or ', [, ], \, ? </span><s><span style='font-size:12.0pt;font-family:Consolas;color:#C00000'>or </span></s><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'>, ;, {, }, (, or ) </span><span style='font-size:12.0pt;font-family:Consolas;color:black'>*)</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:black'>sheet-name-characters=</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><s><span style='font-size:12.0pt;font-family:Consolas;color:#C00000'>sheet-name-character, {sheet-name-character} ;</span></s><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'>sheet-name-character-start, {sheet-name-character};</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'>sheet-name-character-start=</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'> sheet-name-character – (“.” | [0-9]) ;</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;font-family:Consolas;color:#00B0F0'> (* any sheet-name-character except . or digits *)</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt;text-indent:.5in'><span style='font-size:12.0pt;color:#C00000'> </span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;color:black'>Since Charlie confirmed the most recent versions of Excel no longer reproduce the issue with quotes on a sheet name with ‘.’ in the middle or the chart error I think we can close that out as a technical defect in the product which has been fixed with no need to update standards or implementor’s notes around it.</span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;color:black'> </span><o:p></o:p></p><p class=xxmsonormal style='margin-left:35.4pt'><span style='font-size:12.0pt;color:black'>No objections to Charlie’s recommendations around updating narrative prose to indicate quoting can be used more broadly than strictly necessary.</span><o:p></o:p></p><p class=MsoNormal style='margin-left:35.4pt'><o:p> </o:p></p></div><br><br>
<FONT style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">Click <a href="https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ==">here</a> to report this email as spam.</FONT></P></FONT>
<br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been scanned for malware by Forcepoint. </FONT><A href="http://www.forcepoint.com/"><FONT style="BACKGROUND-COLOR: #ffffff" color=#000000>www.forcepoint.com</FONT></A></P>
</body></html>