2.3.4.2.5 Cell_Type

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

Referenced by: StyleSheet_Type, Section_Type, Row_Type, Sheet_Type, DocumentSheet_Type, PageSheet_Type, ShapeSheet_Type

A complex type that specifies a single property, which can also be used to represent an operand token.

Child Elements:

RefBy: A complex type that is unused and MUST be ignored.

Attributes:

N: An xsd:string ([XMLSCHEMA2] section 3.2.1)  attribute that specifies the language-independent name of the property. It MUST be unique amongst all of the Cell_Type elements of the containing Row_Type element, and MUST be equal to a value specified in the Cells (section 2.4.4) section of this specification.

U: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies how this property is formatted and displayed in a user interface, and how it is used in a formula expression. If present, it MUST be equal to a value from the following table.

Value

Meaning

AC

Acres

DEG

Degrees

DA

Radians

AD

Degrees-minutes-seconds

RAD

Radians

BOOL

Boolean

COLOR

RGB color value

CY

Currency

DATE

Days

ED

Days

EH

Hours

EM

Minutes

ES

Seconds

EW

Weeks

HA

Hectare

CM

Centimeters

DL

Inches

FT

Feet

F_I

Feet and inches

IN

Inches

IN_F

Inches

KM

Kilometers

M

Meters

MI

Miles

MI_F

Miles

MM

Millimeters

NM

Nautical miles

PER

Percentage

YD

Yards

DP

Inches

PNT

Coordinates of a two-dimensional point

STR

String

DE

Days

C_D

Ciceros and didots

C

Ciceros

D

Didots

DT

Points

P

Picas

P_PT

Picas and points

PT

Points

E: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the error state of the property, obtained during a formula evaluation. If present, it MUST be equal to a value from the following table.

Value

Meaning

#DIM!

An error value that specifies that a dimensional value exceeds the dimension range.

#DIV/0!

An error value that specifies division by zero.

#VALUE!

An error value that specifies that an operand token is of the wrong type.

#REF!

An error value that specifies that a reference to a cell does not exist.

#NUM!

An error value that specifies an invalid number.

#N/A

An error value that specifies that a value is not available.

F: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the formula expression of the property. It MUST be either a formula expression that satisfies the Formula ABNF and Full Grammar Definition in this specification or equal to a value in the following table.

Value

Meaning

No Formula

Specifies that no formula exists.

Inh

Specifies a formula that is inherited.

V: An xsd:string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the value of the property. It MUST be equal to "1.#INF" if it specifies a floating-point number that is larger than 1.7976e308. If the value of the V attribute is equal to "themed", the value of the property is specified by theme inheritance.

When the F attribute is present, the value of the V attribute MUST be used until a formula evaluation is triggered on the F attribute that does not result in an error value. After formula evaluation is triggered on the F attribute, the value of the property is specified by the most recent result of the formula evaluation that does not produce an error value.

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

 <xsd:complexType name="Cell_Type" mixed="true">
   <xsd:sequence>
     <xsd:element name="RefBy" type="RefBy_Type" minOccurs="0" maxOccurs="unbounded"/>
   </xsd:sequence>
   <xsd:attribute name="N" type="xsd:string" use="required"/>
   <xsd:attribute name="U" type="xsd:string"/>
   <xsd:attribute name="E" type="xsd:string"/>
   <xsd:attribute name="F" type="xsd:string"/>
   <xsd:attribute name="V" type="xsd:string"/>
 </xsd:complexType>