<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-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:38629283;
mso-list-template-ids:821563270;}
@list l0: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 l0: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 l0: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 l0: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 l0: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 l0: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 l0: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 l0: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 l0: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;}
@list l1
{mso-list-id:217515483;
mso-list-template-ids:-1089051940;}
@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;}
@list l2
{mso-list-id:335154336;
mso-list-template-ids:185882602;}
@list l2: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 l2: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 l2: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 l2: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 l2: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 l2: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 l2: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 l2: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 l2: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;}
@list l3
{mso-list-id:517354875;
mso-list-template-ids:-531862112;}
@list l3: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 l3: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 l3: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 l3: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 l3: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 l3: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 l3: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 l3: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 l3: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;}
@list l4
{mso-list-id:965354263;
mso-list-template-ids:-940823876;}
@list l4: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 l4: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 l4: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 l4: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 l4: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 l4: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 l4: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 l4: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 l4: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;}
@list l5
{mso-list-id:1402679202;
mso-list-type:hybrid;
mso-list-template-ids:-1464711676 -1078032486 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l5: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 l5: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 l5: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 l5: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 l5: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 l5: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 l5: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 l5: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 l5: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 l6
{mso-list-id:1622295834;
mso-list-type:hybrid;
mso-list-template-ids:1845367170 -1826715552 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l6:level1
{mso-level-start-at:0;
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 l6: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 l6: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 l6: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 l6: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 l6: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 l6: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 l6: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 l6: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;}
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 a further 12 elements in DR 16-0007.<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.8.7 cellStyle (@name) (complex type: CT_CellStyle)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There is a note on this attribute in MS-OE376 (limiting the name length – see section 2.1.724, page 310, note a), but no mention of the attribute being optional in the standard or how to interpret its omission.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I pointed out on 2016-08-08 that this issue relates to DR 16-0016. Any further clarification of the prose will need to take account of the resolution of DR 16-0016. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On further reading of the current specification, and after running some tests in Excel, I conclude that @name is optional because it is not required if @builtinId is specified. . See Annex G.2 for a list of built-in style names. If @builtinId is specified and @name is either omitted or has a value other than the one specified in Annex G.2, Excel opens the document without complaint and restores the correct built-in style name when the document is saved. If both @builtinId and @name are omitted, Excel opens the document without complaint and silently discards the unnamed style.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution</i>: Add the following to the description of @name in prose: “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><b>§18.8.34 rgbColor (@rgb) (complex type: CT_RgbColor)<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-OE376. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The element <span style='font-family:"Cambria",serif'>rgbColor</span> has only this one attribute and no content, so is meaningless if the attribute is omitted. Yet the schema explicitly specifies that the attribute is optional. The complex type CT_RgbColor is only used for this element. I therefore conclude that there is a mistake in the schema.<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. No change to prose.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.2 b (@cp, @f, @u) (complex type: CT_Boolean)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.763 (page 339) 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>c. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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'><i>d. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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>g. The standard does not define the relation between the u attribute and the sharedItems parent.<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, the u attribute only applies when the parent is sharedItems.<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>h. The standard does not define restrictions on when the cp attribute should be present.<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, the cp attribute applies to OLAP-based PivotTables only and the parent is sharedItems.<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>i. The standard does not specify restrictions on value of the cp attribute.<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, the value of the cp attribute shall be equal to the number of x child elements and less than or equal to the mappingCount attribute of the corresponding cacheField element.<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 does not define the relation between the f attribute and the sharedItems parent.<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, the f attribute only applies when the parent is sharedItems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attributes @f and @u indicate binary properties of an item in a PivotTable: is a calculated item or not; is an unused item or not. Omitting the attribute would logically imply that these properties don’t apply to the item, so I conclude that Excel’s usage is the only logical usage and should be documented in the standard.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Should some of the Excel restrictions on the use of @cp, @f and @u be documented in the standard, or are they implementation-specific?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The complex type CT_Boolean in SpreadsheetML is only used for this element, but this element appears in content models defined by the following complex types:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><ul style='margin-top:0cm' type=disc><li class=MsoNormal style='margin-left:0cm;mso-list:l5 level1 lfo3'>CT_GroupItems<o:p></o:p></li><li class=MsoNormal style='margin-left:0cm;mso-list:l5 level1 lfo3'>CT_Record<o:p></o:p></li><li class=MsoNormal style='margin-left:0cm;mso-list:l5 level1 lfo3'>CT_SharedItems<o:p></o:p></li></ul><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376 states that @cp is only used by Office in <span style='font-family:"Cambria",serif'>sharedItems</span> (§18.10.1.90). Strangely, it is only <span style='font-family:"Cambria",serif'>groupItems</span> (§18.10.1.38) that explicitly mentions OLAP. There are no examples in the standard of the use of @cp, although it is available on six SpreadsheetML elements: <span style='font-family:"Cambria",serif'>b</span>, <span style='font-family:"Cambria",serif'>d</span>, <span style='font-family:"Cambria",serif'>e</span>, <span style='font-family:"Cambria",serif'>m</span>, <span style='font-family:"Cambria",serif'>n</span> and <span style='font-family:"Cambria",serif'>s</span>. Judging by the notes on these elements in MS-OE376, the usage of @cp varies according to the element, so examples in each case would be useful to promote interoperability.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.8 calculatedItem (@formula) (complex type: CT_CalculatedItem)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There is a note on this attribute in MS-OE376 (limiting the maximum value – see section 2.1.769, page 343, note a), but no mention of the attribute being optional in the standard or how to interpret its omission.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This element specifies a formula associated with a specific PivotTable field. It does not make any sense for the PivotTable field not to be specified. However, the presence of extLst in the complex type CT_CalculatedItem suggests that there might be other ways in which associated the PivotTable field could be determined.<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 clarify under what circumstances @field can be omitted. Depending upon their response, decide whether or not to change prose or 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.10.1.21 d (@cp, @f, @u) (complex type: CT_DateTime)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.777 (page 346) 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>a. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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'><i>b. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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>g. The standard does not define the relationship between the cp attribute and the datasource type.<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, the cp attribute applies to OLAP-based PivotTables only.<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>h. The standard does not define the relation between the cp attribute and the sharedItems parent.<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, the cp attribute applies when the parent is sharedItems.<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>i. The standard does not define the relation between @f and the sharedItems parent.<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, @f applies when the parent is sharedItems.<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 does not define restrictions on the value of @cp.<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 Excel, @cp shall be equal to the count of child x elements and be less than or equal to the @mappingCount of the corresponding cacheField element.<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>k. The standard does not define the relation between @u and the sharedItems parent.<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 Excel, @u applies when the parent is sharedItems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>See discussion above for §18.10.1.2 <span style='font-family:"Cambria",serif'>b</span>. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.27 e (@bc, @cp, @f, @fc, @in, @u) (complex type: CT_Error)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.781 (page 348) 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 does not define the relation between the cp attribute and child 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, the value of the cp attribute shall be equal to the count of child elements and be less than or equal to the @mappingCount of the corresponding cacheField element.<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>e. The standard does not define the relation between the cp attribute and the datasource type.<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, the cp attribute applies only to OLAP-based PivotTables.<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>f. The standard does not define relation between the cp attribute and sharedItems node.<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, the cp attribute applies only when the node parent is sharedItems.<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>g. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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>i. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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>k. The standard does not define relation between the f attribute and sharedItems node.<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, the f attribute applies only when the node parent is sharedItems.<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>l. The standard does not define relation between the u attribute and sharedItems node.<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, the u attribute applies only when the node parent is sharedItems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @cp, @f and @u, see discussion above for §18.10.1.2 <span style='font-family:"Cambria",serif'>b</span>. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @bc (Background Color) and @fc (Foreground Color), no default value can be given, because one would expect the defaults in these cases to be controlled by the application.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding the attribute @in (Format Index), this clearly only applies if the format string for this entry in the PivotTable is stored in an OLAP <span style='font-family:"Cambria",serif'>serverformat</span> (§18.10.1.86) element.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available. No action for the other attributes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.45 item (@x) (complex type: CT_Item)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.793 (page 353) 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>k. The standard restricts the x attribute to non-OLAP PivotTables only.<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 allows the x attribute in both OLAP and non-OLAP PivotTables.<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>m. The standard does not specify when the x attribute is required.<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 the x attribute when the value of the t attribute is data.<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>n. The standard states that the x attribute specifies an index to an item in the pivotFields collection.<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 uses the x attribute to specify an index to an item in the sharedItems collection for this pivotField.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>There no mention of OLAP in the description of the attribute @x for this element in the standard, so note k above can be ignored.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Should note m be documented in the standard? The value <span style='font-family:Consolas'>data</span> is the default value for @t, so it might be useful to document that @x is required if @t is either omitted or has the value <span style='font-family:Consolas'>data</span>.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Note n does not quite agree with the current description of @x in the standard, which states that @x “specifies the item index in <span style='font-family:"Cambria",serif'>pivotFields</span> collection in the PivotCache”. But §18.10.1.67 suggests that a PivotCache in fact contains <span style='font-family:"Cambria",serif'>cacheFields</span>, not <span style='font-family:"Cambria",serif'>pivotFields</span>.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Further exploration of the normative text in §18.10 Pivot Tables tends to lead to more confusion. For example, in §18.10.1.46 there is an example which is unintelligible, until one realises that it relates to a longer example in §L.2.9 in the Primer. However, this doesn’t completely resolve the confusion: for example, a value “Adam L Flores” is referred to in §18.10.1.46 and in §L.2.9.3.4.3, but is not included in the example pivotCacheDefinition in §L.2.9.3.2.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed action:</i> A thorough review of Pivot Table normative text and Primer material is needed to clarify how to implement Pivot Tables in SpreadsheetML, which might well lead to a need for more wholesale revision of §18.10 and §L.2.9. Tinkering with the description of attribute values here and there will not suffice.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§<b>18.10.1.50 m (@bc, @cp, @f, @fc, @in, @u) (complex type: CT_Missing)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.797 (page 357) 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>c. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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'><i>d. The standard does not define the relation between @cp and child 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, the value of @cp shall be equal to the count of child x elements and be less than or equal to the @mappingCount of the corresponding cacheField element.<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>e. The standard does not define the relation between @cp and the datasource type.<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, @cp applies only to OLAP-based PivotTables.<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>f. The standard does not define relation between @cp and sharedItems node.<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, @cp applies only when the node parent is sharedItems.<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>i. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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'><i>j. The standard does not define relation between @f and sharedItems node.<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, @f applies only when the node parent is sharedItems.<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>k. The standard does not define relation between @u and sharedItems node.<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, @u applies only when the node parent is sharedItems.<o:p></o:p></p><p class=MsoNormal><b><o:p> </o:p></b></p><p class=MsoNormal>Regarding attributes @cp, @f and @u, see discussion above for §18.10.1.2 <span style='font-family:"Cambria",serif'>b</span>. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @bc, @fc and @in, see discussion above for §18.10.1.27 <span style='font-family:"Cambria",serif'>e</span>.<o:p></o:p></p><p class=MsoNormal><b><o:p> </o:p></b></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available. No action for the other attributes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.51 map (@dimension, @measureGroup) (complex type: CT_MeasureDimensionMap)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.798 (page 358) 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>a. The standard does not place any restrictions on the value of the measureGroup attribute.<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, the value of the measureGroup attribute must be less than the number of items in measureGroups collection.<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>b. The standard does not restrict the value of @dimension.<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, @dimension must be less than number of items the dimensions collection.<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 specify the base of the dimension attribute index.<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 treats the dimension attribute as a zero-based index.<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>d. The standard does not specify the base of the measureGroup attribute index.<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 treats the measureGroup attribute as a zero-based index.<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>e. The standard states that the dimension 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'><i>f. The standard implies that the measureGroup 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 has these two attributes and no content. There seems no point in having the element without specifying the two elements that are being mapped/associated: a <span style='font-family:"Cambria",serif'>map</span> and a <span style='font-family:"Cambria",serif'>measureGroup</span>. It would seem to be a mistake in the schema that these attributes are declared to be optional.<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 these two attributes required. No change to the prose.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.60 n (@bc, @cp, @f, @fc, @in, @u) (complex type: CT_Number)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.804 (pages 360–361) 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>a. The standard does not define relation between @cp and the datasource type.<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 @cp only with OLAP PivotTables.<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>e. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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'><i>f. The standard does not restrict the value of @cp.<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 @cp be equal to the count of child x elements and be less than or equal to the mappingCount of the corresponding cacheField element.<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>g. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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>n. The standard does not state when @f is valid.<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, @f is valid only when the parent of the n element is of CT_SharedItems type.<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>o. The standard does not define relation of @u with CT_SharedItems node.<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, @u is used only when the n element's parent is of CT_SharedItems type.<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>q. The standard does not place a restriction for on the value of the cp attribute.<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, the cp attribute applies only when the node parent is sharedItems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Notes f and q appear to answer the same question, but in different ways. Are both correct?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @cp, @f and @u, see discussion above for §18.10.1.2 <span style='font-family:"Cambria",serif'>b</span>. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @bc, @fc and @in, see discussion above for §18.10.1.27 <span style='font-family:"Cambria",serif'>e</span>.<o:p></o:p></p><p class=MsoNormal><b><o:p> </o:p></b></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available. No action for the other attributes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.74 pivotTableStyleInfo (@showColHeaders, @showColStripes, @showLastColumn, @showRowHeaders, @showRowStripes) (complex type: CT_PivotTableStyle)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.815 (page 381) 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>a. The standard defines the @showLastColumn to determine if the last column of formatting is shown.<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 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'><i>b. The standard does not specify a default value for the showRowHeaders attribute.<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 uses a default value of 0 for 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'><i>c. The standard does not specify a default value for the showRowStripes attribute.<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 uses a default value of 0 for 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'><i>d. The standard does not specify a default value for the showColStripes attribute.<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 uses a default value of 0 for 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'><i>e. The standard does not specify a default value for the showColHeaders attribute.<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 uses a default value of 0 for this attribute.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Given that Excel ignores @showLastColumn, it probably makes sense for the default value to be <span style='font-family:Consolas'>false</span>.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Since all the other attributes have Boolean values, it would make sense for their omission to imply a default value <span style='font-family:Consolas'>false</span>. One might be able to conceive of a more limited implementation in which a default value <span style='font-family:Consolas'>true</span> might be appropriate, but this seems unlikely.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i>Proposed resolution:</i> For clarity, add <span style='font-family:Consolas'>use=“optional”</span> to the schema attribute declarations for @showColHeaders, @showColStripes, @showRowHeaders and @showRowStripes. Add <span style='font-family:Consolas'>default=“false”</span> to all five attribute declarations.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>§18.10.1.85 s (@bc, @cp, @f, @fc, @in, @u) (complex type: CT_String)<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>MS-OE376, subsection 2.1.821 (page 385) 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>a. The standard does not specify a default value for the u attribute.<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 uses a default value of false for 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'><i>b. The standard does not specify a default value for the f attribute.<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 uses a default value of false for 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>f. The standard does not state that @cp is required in certain cases.<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 @cp shall be equal to the count of child x elements and be less than or equal to the @mappingCount of the corresponding cacheField element.<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>g. The standard does not state that the presence of @cp is related to the datasource type.<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, @cp is specific to OLAP-based PivotTables.<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>h. The standard does not define a relationship between @cp and the parent element of s.<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, @cp applies only when the parent of the s element is of type CT_SharedItems.<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>i. The standard does not define a relationship between @f and the parent element of s.<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, @f applies only when the parent of the s element is of type CT_SharedItems.<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 does not define a relationship between @u and the parent element of s.<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, @u applies only when the parent of the s element is of type CT_SharedItems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @cp, @f and @u, see discussion above for §18.10.1.2 <span style='font-family:"Cambria",serif'>b</span>. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding attributes @bc, @fc and @in, see discussion above for §18.10.1.27 <span style='font-family:"Cambria",serif'>e</span>.<o:p></o:p></p><p class=MsoNormal><b><o:p> </o:p></b></p><p class=MsoNormal><i>Proposed resolution:</i> Add the default value <span style='font-family:Consolas'>false</span> to the schema for both @f and @u. Provide an example of the use of @cp on at least one of the six elements on which it is available. No action for the other attributes.<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>ELEMENTS IN DR 16-0007 NOT YET CONSIDERED<o:p></o:p></b></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The following 9 elements in the DR have yet to be considered:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.86 serverFormat (@culture, @format) (complex type: CT_ServerFormat)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.92 tpl (@fld, @hier) (complex type: CT_Tuple)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.1 connection (@name, @type) (complex type: CT_Connection)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.3 dbPr (@command) (complex type: CT_DbPr)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.5 olapPr (@rowDrillCount) (complex type: CT_OlapPr)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§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></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.13 webPr (@url) (complex type: CT_WebPr)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.14.1 cell (@r) (complex type: CT_ExternalCell)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.14.15 definedName (@refersTo) (complex type: CT_ExternalDefinedName)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>