<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;
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:11.0pt;
font-family:"Calibri",sans-serif;}
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:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>My thanks to Aarti and the Excel team for their response.<o:p></o:p></span></p><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'>Here are my conclusions so far as resolution of the outstanding issues in DR 16-0007 are concerned.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b>§18.8.34 rgbColor<o:p></o:p></b></p><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'>My original proposal was to make the attribute @rgb required in the schema. On the basis of the response from the Excel team, I now propose that instead we leave the attribute as optional but add a default value of 0 to the schema.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b>§18.10.1.8 calculatedItem<o:p></o:p></b></p><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'>This is a pivotTable element, so this issue has been moved to DR 18-0007. The Excel team have responded that the @field attribute is not used by Excel, which always uses references contained within the child element pivotArea (see CT_PivotArea). I therefore propose that an extra sentence be added to the description of the attribute @field:<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='mso-fareast-language:EN-US'>Specifies the index of the pivotField with which this calculated item is associated. <u><span style='color:#0070C0'>If this attribute is omitted, the associated fields are specified by the contents of the element.</span></u><o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b>§18.13.3 dbPr<o:p></o:p></b></p><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'>The Excel team have explained that, although Excel requires the use of the @command attribute, other implementations may not require a command to be specified. We could add a sentence to the description of the @command attribute to make it clear that an implementation is not required to specify it, but probably the best approach is to do nothing.<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><b>§18.14.5 definedName<o:p></o:p></b></p><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'>The explanation from the Excel team indicates that omission of the @refersTo attribute is possible and may, for example, indicate that the range in the external workbook to which the name applies cannot be resolved (e.g. named sheet does not exist in the external workbook). I therefore propose the following revision of the description of this attribute:<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span style='mso-fareast-language:EN-US'>Name<u><span style='color:#0070C0'>d</span></u> range definition string. <u><span style='color:#0070C0'>The attribute is optional.</span></u><o:p></o:p></span></p><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'>If we’re happy with these proposed resolutions, I think that clears up all the remaining items in DR 16-0007 (excluding those moved to DR 18-0007), so we should be able to close DR 16-0007.<o:p></o:p></span></p><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'>Kind regards,<o:p></o:p></span></p><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'>Francis<o:p></o:p></span></p><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><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 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> Aarti Nankani <anankani@microsoft.com> <br><b>Sent:</b> 17 April 2018 00:17<br><b>To:</b> Francis Cave <francis@franciscave.com><br><b>Cc:</b> SC 34/WG 4 mailing list <e-SC34-WG4@ecma-international.org><br><b>Subject:</b> RE: DR 16-0007 - specific requests for clarification from the Excel team<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>Hi Francis,<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 style='color:black'>For this DR, response from Product Team:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><b>§18.8.34 rgbColor<o:p></o:p></b></p><p class=MsoNormal>The attribute @rgb on element rgbColor is optional in the SpreadsheetML schema, but the element rgbColor would appear to be meaningless without the attribute having a value. Can the Excel team confirm whether or not this attribute is required by Excel, and if not, how Excel interprets its omission?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> <span style='color:red'>If this attribute is omitted, Excel will treat it as ‘0’</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.8 calculatedItem<o:p></o:p></b></p><p class=MsoNormal>The attribute @field on element calculatedItem is optional in the SpreadsheetML schema. Since there has to be some mechanism for referencing the PivotTable field to which the formula (specified by @formula) is to be applied, can the Excel team clarify whether @field is in fact required by Excel, or whether there could be some alternative mechanism (e.g. using the contents of a child extLst element) for locating the field in question, in which case @field would be omitted?<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal> <span style='color:red'>Excel will omit the “field” attribute and does not use it. We use the “reference” child elements to specify formula fields. For this specific example, the pivotArea child element of calculatedItem contains the references.</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.3 dbPr<o:p></o:p></b></p><p class=MsoNormal>The attribute @command on element dbPr is optional in the SpreadsheetML schema. Can the Excel team explain under what circumstances this attribute may be omitted? In particular, would it be omitted if the external data connection had been deleted?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> <span style='color:red'>The attribute is optional because it’s up to the data provider to specify if they require a command. Usually it’s required, but a custom provider may not use one.<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.14.5 definedName<o:p></o:p></b></p><p class=MsoNormal>The attribute @refersTo on element definedName is optional in the SpreadsheetML schema. Can the Excel team confirm whether or not Excel requires this attribute and, if not, how its omission is interpreted when a document is opened?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> <span style='color:red'>Excel does not require the attribute, and will in certain cases produce files that omit it. The refersTo attribute being omitted indicates that we were unable to resolve that name to anything, possibly because the name doesn’t exist, or because there was some issue accessing the target book.<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>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Aarti<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> Francis Cave <</span><a href="mailto:francis@franciscave.com"><span lang=EN-US>francis@franciscave.com</span></a><span lang=EN-US>> <br><b>Sent:</b> Thursday, August 31, 2017 8:15 AM<br><b>To:</b> Aarti Nankani <</span><a href="mailto:anankani@microsoft.com"><span lang=EN-US>anankani@microsoft.com</span></a><span lang=EN-US>><br><b>Cc:</b> SC 34/WG 4 mailing list <</span><a href="mailto:e-SC34-WG4@ecma-international.org"><span lang=EN-US>e-SC34-WG4@ecma-international.org</span></a><span lang=EN-US>><br><b>Subject:</b> DR 16-0007 - specific requests for clarification from the Excel team<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal>Hi Aarti<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Following the discussions on the WG 4 call yesterday, I have compiled a list of questions to the Excel team, requesting clarification of various points which don’t appear to be covered by implementer notes in MS-OI29500. References are to sections in IS 29500.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Kind regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Francis<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.8.34 rgbColor<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @rgb on element rgbColor is optional in the SpreadsheetML schema, but the element rgbColor would appear to be meaningless without the attribute having a value. Can the Excel team confirm whether or not this attribute is required by Excel, and if not, how Excel interprets its omission?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.8 calculatedItem<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @field on element calculatedItem is optional in the SpreadsheetML schema. Since there has to be some mechanism for referencing the PivotTable field to which the formula (specified by @formula) is to be applied, can the Excel team clarify whether @field is in fact required by Excel, or whether there could be some alternative mechanism (e.g. using the contents of a child extLst element) for locating the field in question, in which case @field would be omitted?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.3 dbPr<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @command on element dbPr is optional in the SpreadsheetML schema. Can the Excel team explain under what circumstances this attribute may be omitted? In particular, would it be omitted if the external data connection had been deleted?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.14.5 definedName<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @refersTo on element definedName is optional in the SpreadsheetML schema. Can the Excel team confirm whether or not Excel requires this attribute and, if not, how its omission is interpreted when a document is opened?<o:p></o:p></p></div></body></html>