Share via

2.3.4.2.6 CellDef_Type

  • Article

Target namespace: http://schemas.microsoft.com/office/visio/2011/1/core

Referenced by: Extensions_Type, SectionDef_Type, RowDef_Type

A complex type that specifies the definition of a cell that is not specified in this specification.

Attributes:

N: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the cell. It MUST be unique amongst all the FunctionDef_Type, CellDef_Type, and SectionDef_Type elements in the Web drawing. It MUST NOT be equal to the name of a function token listed in the Function Token Definitions section of this specification. It MUST NOT be equal to the name of a section listed in the Sections section of this specification. It MUST NOT be equal to the name of a cell listed in the Cells section of this specification.

T: An xsd:token ([XMLSCHEMA2] section 3.3.2) attribute that specifies the operand token used to specify the Value of the cell. It MUST be equal to a value from the following table.

Value

Operand Token

BYTE

PtgByte

BOOL

PtgBool

WORD

PtgUnsShort

SHORT

PtgShort

LONG

PtgInt

DOUBLE

PtgNum

PERCENT

PtgNum

MULTIDIM

PtgNumMultiDim

CAL

vCalendar

 

F: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the default formula expression of the cell.

IX: An xsd:unsignedByte ([XMLSCHEMA2] section 3.3.24) attribute that specifies the zero-based identifier of a collection of cells. It MUST be unique amongst all of the CellDef_Type elements of the containing RowDef_Type element. It MUST be greater than the IX attribute of any preceding CellDef_Type element of the containing Extensions_Type, SectionDef_Type or RowDef_Type element. If the containing element is a RowDef_Type element and if the RowDef_Type element’s containing element is a SectionDef_Type element with T attribute equal to "Indexed" or N attribute equal to "Character", "Field", "FillGradient", "Geometry", "Layer", "LineGradient", "Paragraph", "Reviewer", "Scratch", or "Tabs", IX MUST exist.

S: An xsd:unsignedByte ([XMLSCHEMA2] section 3.3.24) attribute that is unused and MUST be ignored.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CellDef_Type">
   <xsd:attribute name="N" type="xsd:string" use="required"/>
   <xsd:attribute name="T" type="xsd:token" use="required"/>
   <xsd:attribute name="F" type="xsd:string"/>
   <xsd:attribute name="IX" type="xsd:unsignedByte"/>
   <xsd:attribute name="S" type="xsd:unsignedByte"/>
 </xsd:complexType>