<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;
font-family:"Calibri",sans-serif;
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>Hi Aarti<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Following the discussions on the WG 4 call yesterday, I have compiled a list of questions to the Excel team, requesting clarification of various points which don’t appear to be covered by implementer notes in MS-OI29500. References are to sections in IS 29500.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Kind regards,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Francis<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.8.34 rgbColor<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @rgb on element rgbColor is optional in the SpreadsheetML schema, but the element rgbColor would appear to be meaningless without the attribute having a value. Can the Excel team confirm whether or not this attribute is required by Excel, and if not, how Excel interprets its omission?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.10.1.8 calculatedItem<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @field on element calculatedItem is optional in the SpreadsheetML schema. Since there has to be some mechanism for referencing the PivotTable field to which the formula (specified by @formula) is to be applied, can the Excel team clarify whether @field is in fact required by Excel, or whether there could be some alternative mechanism (e.g. using the contents of a child extLst element) for locating the field in question, in which case @field would be omitted?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.13.3 dbPr<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @command on element dbPr is optional in the SpreadsheetML schema. Can the Excel team explain under what circumstances this attribute may be omitted? In particular, would it be omitted if the external data connection had been deleted?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>§18.14.5 definedName<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The attribute @refersTo on element definedName is optional in the SpreadsheetML schema. Can the Excel team confirm whether or not Excel requires this attribute and, if not, how its omission is interpreted when a document is opened?<o:p></o:p></p></div></body></html>