<div dir="ltr"><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Charlie Clark</b> <span dir="ltr"><<a href="mailto:charlie.clark@clark-consulting.eu" target="_blank">charlie.clark@clark-<wbr>consulting.eu</a>></span><br>Date: 2016-08-09 17:58 GMT+09:00<br>Subject: Re: DR-16-0016, "SML: Named Styles". New DR<br>To: MURATA Makoto <<a href="mailto:eb2m-mrt@asahi-net.or.jp" target="_blank">eb2m-mrt@asahi-net.or.jp</a>><br>Cc: "<a href="mailto:francis@franciscave.com" target="_blank">francis@franciscave.com</a>" <<a href="mailto:francis@franciscave.com" target="_blank">francis@franciscave.com</a>>, Rex Jaeschke <<a href="mailto:Rex@rexjaeschke.com" target="_blank">Rex@rexjaeschke.com</a>><br><br><br><span>Am .08.2016, 10:33 Uhr, schrieb MURATA Makoto <<a href="mailto:eb2m-mrt@asahi-net.or.jp" target="_blank">eb2m-mrt@asahi-net.or.jp</a>>:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Charlie,<br>
<br>
Hello. I am the convenor of WG4. We have been always very<br>
grateful to your significant contributions to WG4. Your input helps<br>
to ensure that OOXML documents are accessible by a variety<br>
of application programs.<br>
<br>
Here is the link to DR 16-0007.<br>
<br>
<a href="https://onedrive.live.com/view.aspx?cid=c8ba0861dc5e4adc&page=view&resid=c8ba0861dc5e4adc!820&parId=c8ba0861dc5e4adc!813&app=Word" rel="noreferrer" target="_blank">https://onedrive.live.com/view<wbr>.aspx?cid=c8ba0861dc5e4adc&pag<wbr>e=view&resid=c8ba0861dc5e4adc!<wbr>820&parId=c8ba0861dc5e4adc!<wbr>813&app=Word</a><br>
</blockquote>
<br></span>
Dear Makoto,<br>
<br>
thank you very much. I don't think this the same issue. The problem with DR 16-006 is how to handle what are essentially denormalised relations such as between CellStyle and CellStyleXfs such as the following:<br>
<br>
<cellStyles ><br>
<cellStyle name="20% - Accent1" xfId="3" builtinId="30"/><br>
<cellStyle name="Heading 1" xfId="2" builtinId="16"/><br>
<cellStyle name="Normal" xfId="0" builtinId="0"/><br>
<cellStyle name="Title" xfId="1" builtinId="15"/><br>
</cellStyles><br>
<br>
<cellStyleXfs><br>
<xf numFmtId="0" fontId="0" fillId="0" borderId="0"/><br>
<xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyNumberFormat="0"<br>
applyFill="0" applyBorder="0" applyAlignment="0" applyProtection="0"/><br>
</cellStyleXfs><br>
<br>
As things stand I thing this would be valid XML but likely to cause problems for applications.<br>
<br>
There should be a constraint such that len(//cellsStyle/*) = len(//cellStyleXfs/*) I'm not so hot on XSL but maybe there should be relevant ref attributes in the schema?<br>
<br>
<xsd:complexType name="CT_CellStyle" ref="xf"><br>
<xsd:sequence><br>
<xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/><br>
</xsd:sequence><br>
<xsd:attribute name="name" type="s:ST_Xstring" use="optional"/><br>
<xsd:attribute name="xfId" type="ST_CellStyleXfId" use="required"/><br>
<xsd:attribute name="builtinId" type="xsd:unsignedInt" use="optional"/><br>
<xsd:attribute name="iLevel" type="xsd:unsignedInt" use="optional"/><br>
<xsd:attribute name="hidden" type="xsd:boolean" use="optional"/><br>
<xsd:attribute name="customBuiltin" type="xsd:boolean" use="optional"/><br>
</xsd:complexType><br>
<br>
Unfortunately, a constraint the other way is not possible because the xf type is used in different contexts with different elements (I've submitted a DR in the past along these lines): a base type would help here.<div><div><br>
<br>
Charlie<br>
-- <br>
Charlie Clark<br>
Managing Director<br>
Clark Consulting & Research<br>
German Office<br>
Kronenstr. 27a<br>
Düsseldorf<br>
D- 40217<br>
Tel: <a href="tel:%2B49-211-600-3657" value="+492116003657" target="_blank">+49-211-600-3657</a><br>
Mobile: <a href="tel:%2B49-178-782-6226" value="+491787826226" target="_blank">+49-178-782-6226</a><br>
</div></div></div><br><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><br>Praying for the victims of the Japan Tohoku earthquake<br><br>Makoto</div>
</div>