<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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 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;}
@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:0in;
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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[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-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>I agree John that this fits into the “Misc. Bin”. I’ve added it to the DR.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Rex<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> John Haug [mailto:johnhaug@exchange.microsoft.com] <br><b>Sent:</b> Friday, January 17, 2014 4:19 PM<br><b>To:</b> WG 4<br><b>Subject:</b> RE: DR 13-0003 - more nits<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>I’m sending this one separately, as I’m not certain whether it fits into this bucket of misc. editorial nits. It seems reasonable, though.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b>Issue #13<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §21.2.2.65 “f (Formula)”<o:p></o:p></b></p><p class=MsoNormal>The reader would benefit from a reference to the subclause on cell references and, in particular, to the detailed description of how link and external references work. There are a lot of pieces working in concert with external references. They are fully described in the standard but one may not know where to find all that detailed information since this “f” element under DrawingML.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'>This reference is in the form of a book, sheet, and cell reference or a book, optional sheet, and defined name<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'>reference. This reference does not include the equals sign. <u><span style='color:red'>Cell references are defined in §18.17. Link and external references are described in detail within §18.17.2.3.<o:p></o:p></span></u></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><u><span style='color:red'>_<o:p></o:p></span></u></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'>[<i>Example</i>:<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-family:Consolas'><c:cat></span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> John Haug [<a href="mailto:johnhaug@exchange.microsoft.com">mailto:johnhaug@exchange.microsoft.com</a>] <br><b>Sent:</b> Friday, January 17, 2014 1:06 PM<br><b>To:</b> WG 4<br><b>Subject:</b> DR 13-0003 - more nits<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’d like to propose some new items for our open DR on miscellaneous editorial nits in Parts 1 and 4.<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>Issue #8<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §18.8.40 “tableStyle (Table Style)”<o:p></o:p></b></p><p class=MsoNormal>The reference to Annex D should be to Annex G. Perhaps make this an automated section reference so it doesn’t occur again?<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><span style='color:black'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><span style='color:black'>All of the built-in, named table styles defined in Annex </span><s><span style='color:red'>D</span></s><u><span style='color:#0070C0'>G</span></u><span style='color:black'> shall be supported by applications that implement table<o:p></o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span style='color:black'>styles.</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>Issue #9<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §18.8.41 “tableStyleElement (Table Style)”<o:p></o:p></b></p><p class=MsoNormal>The three occurrences of “1. ” should be removed.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><span style='font-family:Symbol'>· </span>Last Total Cell<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><s><span style='color:red'>1. </span></s>For instance, row stripe formatting 'wins' over column stripe formatting, and both 'win' over whole table<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'>formatting.<o:p></o:p></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><b><s><span style='color:red'>1.</span><o:p></o:p></s></b></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><b><s><span style='color:red'>1. </span></s>PivotTable Style Element Order<o:p></o:p></b></p><p class=MsoNormal style='margin-left:.5in;text-autospace:none'><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-family:Symbol'>· </span>Whole Table<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>Issue #10<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §18.18.77 “ST_TableStyleType (Table Style Type)”<o:p></o:p></b></p><p class=MsoNormal>The image captions are above each image but are not set to "keep with next" and end up split across pages. The caption is on a preceding page and the image on a following page, immediately followed by the caption for the next image, which is on the subsequent page. This makes it easy to think the following caption applies to the previous image.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'>(Set the paragraph for each caption to “keep with next” paragraph. In Word: Paragraph dialog > Line and Page Breaks tab > check “Keep with next”.)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>Issue #11<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §L.4.5.1 “Introduction”<o:p></o:p></b></p><p class=MsoNormal>The paragraph following the heading “L.4.5.1 Introduction” is formatted as a heading rather than a paragraph text.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'>(Change the formatting and remove the L.4.5.2 heading number. This will renumber L.4.5.2.* to L.4.5.1.*, L.4.5.3 to L.4.5.2, and L.4.5.3.* to L.4.5.2.*.)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>Issue #12<o:p></o:p></b></p><p class=MsoNormal><b>Part 1, §L.4.6.1 “Introduction”<o:p></o:p></b></p><p class=MsoNormal>The paragraph following the heading “L.4.6.1 Introduction” is formatted as a heading rather than a paragraph text.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-left:.5in'>(Change the formatting and remove the L.4.6.2 heading number. This will renumber L.4.6.2.* to L.4.6.1.*, L.4.6.3 to L.4.6.2, and L.4.6.3.* to L.4.6.2.*.)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>