Missing definition on SpreadsheetML?

[Francis Cave]

This looks like an error in the OpenXML SDK documentation. I've tested what Excel stores for merged cells and it is consistent with the documentation in Part 1, i.e. the element 'mergeCell' is contained within the element 'mergeCells' within 'worksheet'.

Can someone (Chris?) explain why some collection elements - e.g. 'mergeCells' - have an @count attribute, while others - e.g. 'hyperlinks' - do not?

Francis



-----Original Message-----
From: Charlie Clark [mailto:charlie.clark at clark-consulting.eu] 
Sent: 22 June 2015 11:57
To: Rex Jaeschke
Cc: 'SC 34 WG4'
Subject: Missing definition on SpreadsheetML?

Hi Rex,

I've received some bug reports to my library about "mergeCell" missing in cell alignment definitions. I've checked both the transitional and the strict scheme and cannot find it there.

<xsd:complexType name="CT_CellAlignment">
   <xsd:attributename="horizontal" type="ST_HorizontalAlignment"  
use="optional"/>
   <xsd:attributename="vertical" type="ST_VerticalAlignment"  
use="optional"/>
   <xsd:attributename="textRotation" type="xsd:unsignedInt" use="optional"/>
   <xsd:attributename="wrapText" type="xsd:boolean" use="optional"/>
   <xsd:attributename="indent" type="xsd:unsignedInt" use="optional"/>
   <xsd:attributename="relativeIndent" type="xsd:int" use="optional"/>
   <xsd:attributename="justifyLastLine" type="xsd:boolean" use="optional"/>
   <xsd:attributename="shrinkToFit" type="xsd:boolean" use="optional"/>
   <xsd:attributename="readingOrder" type="xsd:unsignedInt" use="optional"/>
</xsd:complexType>	

However, in the Microsoft Office OpenXML SDK documentation, mergeCell is listed as a possible property. This seems to reflect the use of the control in the GUI. Can you clarify this?

Horizontal: Represents the following attribute in the schema: horizontal

Indent: Represents the following attribute in the schema: indent

JustifyLastLine: Represents the following attribute in the schema:  
justifyLastLine

LocalName Gets the local name of the element.

MergeCell:Represents the following attribute in the schema: mergeCell

ReadingOrder: Represents the following attribute in the schema:  
readingOrder

RelativeIndent: Represents the following attribute in the schema:  
relativeIndent

ShrinkToFit: Represents the following attribute in the schema: shrinkToFit

TextRotation: Represents the following attribute in the schema:  
textRotation

Vertical: Represents the following attribute in the schema: vertical

WrapText:Represents the following attribute in the schema: wrapText

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226