<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;
mso-fareast-language:EN-US;}
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;}
.MsoChpDefault
{mso-style-type:export-only;
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="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Dear all<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have an action from today’s WG 4 telecon to confirm the prose changes that I believe need to be made in order to close DR 16-0007. All schema changes that I proposed have already been made by Murata-san, or so I believe. Caroline has already indicated that she is happy with some of my proposed prose changes. There are some outstanding questions to the Excel team for which we still await responses, so this is still work in progress, but here is the current status regarding prose changes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.2.2 calcPr (@forceFullCalc)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On reflection, if we add the default value “false” to the schema, I don’t think we need to change the prose. LibreOffice does not support this attribute, i.e. it ignores it on consumption and throws it away when the document is saved, so I think that the behaviour of Excel is definitive.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.2.7 ext (@uri)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The proposal was either to add the words “If present,” at the start of the description of @uri, or take no action. On August 25<sup>th</sup> 2017 Caroline said “The proposed resolution looks good to me. Assuming we make any changes as a result of this DR, I don't see any problems with making the changes Francis suggests "for clarity."”. That seems to steer us in the direction of adding the words “If present,”.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.3.1.73 row (@r)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I proposed the following be added to the description of @r:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>If this attribute is not specified, the row index shall be interpreted to be 1 greater than that of the previous row in the parent element. If this attribute is not specified and the row is the first in the parent element, the row index shall be interpreted to be ‘1’. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This should go at the end of the first paragraph of the description. No-one has commented on this proposal, so I suggest we agree to make this change.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As a consequence, for consistency, I propose the following change to the description of @r on §18.3.1.4 c (in accordance with the corresponding implementer note in [MS-OI29500].pdf):<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>If this attribute is not specified, the column index part of the cell reference shall be interpreted to be one greater than that of the previous cell in the parent row element. If this attribute is not specified and the cell is the first in the parent row element, the column index part of the cell reference shall be interpreted to be ‘A’.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.3.2.10 top10 (@filterVal)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>No change to normative prose has been suggested, but we should correct the Example as indicated in the DR log.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.8.7 cellStyle (@name)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My original proposal was to add the following text to the end of the first sentence of the attribute description:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>If this attribute and builtinId are both omitted, this cell style shall be ignored.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>However, following further tests in Excel and LibreOffice, I conclude that the behaviour is implementation-dependent. For example, <cellStyle xfId=”0”/> is acceptable to both Excel and LibreOffice and in both cases is saved as <cellStyle xfId=”0” name=”Normal” builtinId=”0”/> (assuming that there is not already a style of this name. However, <cellStyle xfId=”1”/> is acceptable to both Excel and LibreOffice, but Excel saves this as <cellStyle xfId=”1” name=”Style 1”/>, while LibreOffice discards the style. I therefore propose instead:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>If this attribute and builtinId are both omitted, the behaviour is application-dependent.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.2 b (@cp, @f, @u)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I did not propose any change to the prose, except to suggest that an example of the use of @cp on one of the elements b, d, e, m, n or s would be helpful. If no-one in this group has sufficient expertise with Pivot Tables to provide an example, we may need to refer this to the Excel team. The suggested question to the Excel team would be: <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Can you provide one or more suitable examples of the use of the attribute cp on any of the elements b, d, e, m, n or s, to indicate the number of properties of the item, for inclusion in the attribute description table of one or all of these elements in §18.10.1.2, §18.10.1.21, §18.10.1.27, §18.10.1.50, §18.10.1.60 or §18.10.1.85.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.8 calculatedItem (@formula)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We’re awaiting a response to my question to the Excel team.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.21, §18.10.1.27, §18.10.1.50, §18.10.1.60, §18.10.1.85<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>See §18.10.1.2 above.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.45 item (@x)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We don’t have a resolution to this. I’m wondering whether we should move all the preceding Pivot Table related elements/attributes from this DR into a new DR, so that we can reach a resolution of the remainder more quickly. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.86 serverFormat (@culture, @format)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My proposal was to add the following text at the end of the paragraph above the attribute description table:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>At least one of the attributes culture and format shall be specified. If both attributes are specified, the result is application-dependent.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have nothing further to add, so this remains my proposed resolution.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.92 tpl (@fld, @hier)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I suggest a new question to the Excel team in order to try to resolve this:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>What is meant by “Office requires that @fld and @hier be mutually exclusive in SpreadsheetML documents”? Does this mean that a document may only contain one or other of these attributes? Or does it mean that each tuple may only contain one or other of these attributes, but some tuples may contain one while other tuples contain the other attribute?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.3 dbPr (@command)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We’re awaiting a response to my question to the Excel team.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.12 textPr (@characterSet)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My proposal was to change the description of @characterSet to read:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>If this attribute is not present, the behaviour is application-dependent.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There has been no objection to this proposal, so I see no cause to revise it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.13 webPr (@url)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>For clarity, I propose adding the text I proposed previously to the description of @url:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>This attribute is required, unless the attribute deleted of the parent connection element is specified to be true.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.14.5 definedName (@refersTo)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We’re awaiting a response to my question to the Excel team.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>That covers all the elements for which we have discussed possible prose changes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Francis<o:p></o:p></p></div></body></html>