Cell element (Scratch Section) ('Visio XML')

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Office 365 | Visio 2013

In this article
Element information
Definition
Elements and attributes

Specifies a work area for entering and testing formulas that can be referred to by other cells.

Element information

Element type	Cell_Type
Namespace	http://schemas.microsoft.com/office/visio/2012/main
Schema file	VisioSchema15.xsd
Document parts	document.xml, masters.xml, master#.xml, pages.xml, page#.xml

Definition

XML

< xs:element name="Cell" type="Cell_Type" minOccurs="0" maxOccurs="unbounded" >
</xs:element >

Elements and attributes

If the schema defines specific requirements, such as sequence, minOccurs, maxOccurs, and choice, see the definition section.

Parent elements

Element	Type	Description
Row element (Scratch Section)	ScratchRow_Type	Specifies a work area for entering and testing formulas that can be referred to by other cells.

Child elements

Element	Type	Description
RefBy	RefBy_Type	Specifies a reference to a page.

Attributes

Attribute	Type	Required	Description	Possible values
E	xsd:string	optional	Indicates that the formula evaluates to an error. The value of E is the current value (an error message string); the value of the V attribute is the last valid value.	An error message string.
F	xsd:string	optional	Represents the element’s formula. This attribute can contain one of the following strings: ‘(some formula)’ if the formula exists locally No Formula if the formula is locally deleted or blocked Inh if the formula is inherited.	A formula.
N	xsd:string	required	Represents the name of the ShapeSheet cell.	The name of the ShapeSheet cell. See the Remarks section below.
U	xsd:string	optional	Represents a unit of measure The default is DL.	The units of the cell.
V	xsd:string	optional	Represents the value of the cell.	The value of the ShapeSheet cell.

Remarks

The N attribute of this Cell element must be one of a limited set of values that correspond to ShapeSheet cells. Refer to the table below to determine the values of the N attribute that are permitted for this Cell element.

Value	Description	More information
A	A scratch cell that you can use for entering or testing formulas.	Scratch Section
B	A scratch cell that you can use for entering or testing formulas.	Scratch Section
C	A scratch cell that you can use for entering or testing formulas.	Scratch Section
D	A scratch cell that you can use for entering or testing formulas.	Scratch Section
X	A scratch cell that you can use for entering or testing formulas.	Scratch Section
Y	A scratch cell that you can use for entering or testing formulas.	Scratch Section