<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:Cambria;
panose-1:2 4 5 3 5 4 6 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;}
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.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
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.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;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{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;}
/* List Definitions */
@list l0
{mso-list-id:1402679202;
mso-list-type:hybrid;
mso-list-template-ids:-1464711676 -1078032486 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l0:level1
{mso-level-start-at:8;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:2110347684;
mso-list-template-ids:1640384780;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.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>Dear all<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here are proposed resolutions and actions for the final 9 elements in DR 16-0007. At least I’m not having to correct the references to MS-OI29500 this time…<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><b>§18.10.1.86 serverFormat (@culture, @format) (complex type: CT_ServerFormat)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.792 (page 352) includes the following note:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>a. The standard allows for both culture and format attributes.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Office allows only one of culture and format attributes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Clearly, this element must have either one or other of the two attributes, since it is an empty element and has no meaning without one or other attribute being specified. However, an implementation might choose to allow both attributes, even though Excel does not.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Change the normative text above the attribute description table by adding two sentences: <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Represents the numeric format specified by the OLAP server for a tuple. <u><span style='color:#0070C0'>At least one of the attributes culture and format shall be specified. If both attributes are specified, the result is application-dependent.</span></u><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[Nit note: I think we prefer “application-dependent” to “implementation-dependent”. There is one instance of “implementation-dependent in 29500-1, in the first paragraph of §17.18.24.]<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.92 tpl (@fld, @hier) (complex type: CT_Tuple)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.796 (page 361) includes the following note:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>a. The standard does not require that @fld is mutually exclusive with @hier in a SpreadsheetML document.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Office requires that @fld and @heir be mutually exclusive in SpreadsheetML documents.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The usage of this element is not clear, as the only example only shows a single tuple, but it would seem to be the case that a tuple may specify <i>either</i> a pivotField <i>or</i> a pivotHierarchy, but not both. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed action:</i> Ask the Excel team to confirm that a tuple (OLAP sheet data entry member) may only specify one or other of these attributes. If confirmed, change the normative text above the attribute table by adding two sentences:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Represents an OLAP sheet data entry member. <u><span style='color:#0070C0'>At least one of the attributes fld and hier shall be specified. If both attributes are specified, the result is application-dependent.</span></u><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.1 connection (@name, @type) (complex type: CT_Connection)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.826 (page 371) includes the following notes:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>d. The standard states that the name attribute is optional.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Excel requires this attribute.<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>…<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>j. The standard states that the type attribute is optional.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Excel requires this attribute.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The description of @name in the standard says: “Each connection shall have a unique name.” This is contradicted by the schema, in which @name is declared to be optional.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @type might be omitted in a more limited implementation than Excel, where only one connection type is supported. However, that would be an argument for there to be a default value, possibly a value that means “Custom data connection source”. Given that there is no obvious default value, it probably makes most sense for this attribute to be required.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[Nit note: Some faux change-tracking seems to have been preserved on page 2000, where values 7 and 8 of @type are underlined, and the description of value 8 ends <s><u>DSP</u></s>.]<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Change the schema so that @name is required. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.3 dbPr (@command) (complex type: CT_DbPr)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There is no note on this attribute in MS-OI29500.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Having reviewed the specification of this element, there is insufficient information in the standard to determine whether there might be circumstances in which this attribute may correctly be omitted. Might <span style='font-family:"Cambria",serif'>it be</span> omitted when the external data connection has been deleted? See notes under §18.3.13 below.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed action:</i> Either take no action, or ask the Excel team to confirm whether or not Excel requires @command in all circumstances, and specifically when the external data connection has been deleted. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.5 olapPr (@rowDrillCount) (complex type: CT_OlapPr)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500 contains a note about this attribute (limiting its value – see subsection 2.1.828, page 372, note a), but says nothing about how to interpret its omission.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This attribute specifies a maximum number of “drill-through rows” to return. Its omission appears to imply that there is no explicit maximum number, although in the case of Excel the maximum number must presumably be no larger than the maximum value of this attribute. Other implementations might wish to specify different limitations. The largest maximum number that can be specified is the largest value of an unsigned integer according to the W3C unsignedInt datatype, which is 4294967295.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> No action.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.12 textPr (@characterSet) (complex type: CT_TextPr) – the attribute @codePage was moved to Part 4, but is still mentioned here and in §18.2.24 webPublishing.<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.833 (page 374) includes the following note:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>j. The standard states that characterSet is a valid attribute, and that when it is present, codePage should be ignored.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Office ignores the characterSet attribute if it is present, and does not ignore the codePage attribute if characterSet is present.<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>This note applies to the following products: Office 2010, Office 2010 Server, Office 2010 SP1.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @codePage is a legacy attribute specified in 29500-4, §15.7.1, page 218. It is referred to normatively in the description of @characterSet on page 2011 of 29500-1 – this should not be normative.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Change the description of @characterSet as follows: “If this attribute is not present<s><span style='color:red'> then the codepage attribute are used</span></s><u><span style='color:#0070C0'>, the behaviour is application-dependent</span></u>.”<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.13.13 webPr (@url) (complex type: CT_WebPr)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.834 (page 374) includes the following notes:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>b. The standard states that @url may be an empty string.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>In Office @url cannot be an empty string, and must have a length less than or equal to 230 characters.<o:p></o:p></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>c. The standard does not state the relationship between the url, xml, and connection@deleted elements.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>In Office, if @xml= true and the @deleted of the parent connection element is false, a non-empty @url shall be specified. If @xml is false, @url shall be specified if the @deleted of the parent connection element is false and not specified otherwise.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>These two notes imply that, for Excel at least, @url is required and must be non-empty except when the external data connection has been deleted, in which case the parent <span style='font-family:"Cambria",serif'>connection</span> element will specify <span style='font-family:Consolas'>deleted= “true”</span> and in this case @url must be omitted.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This series of constraints might not apply to another implementation.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Either take no action, or add the following text to the description of @url: “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><b>§18.14.1 cell (@r) (complex type: CT_ExternalCell)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500, subsection 2.1.835 (page 374) includes the following note:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'><i>d. The standard implies that the r attribute is optional.<o:p></o:p></i></p><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:36.0pt'>Excel requires this attribute.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The element is used to store cached values from external sources. It is unclear how this element would be interpreted if @r is omitted. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Change the schema to make this attribute required.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.14.5 definedName (@refersTo) (complex type: CT_ExternalDefinedName)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OI29500 contains a note on this attribute (restricting its value – see subsection 2.1.838, page 375, note b), but does not say how to interpret its omission.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed action:</i> Ask the Excel team whether Excel requires this attribute.<o:p></o:p></p></div></body></html>