Missing definition on SpreadsheetML?

Charlie Clark charlie.clark at clark-consulting.eu
Mon Jun 22 12:57:15 CEST 2015


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


More information about the sc34wg4 mailing list