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>