Expand Minimize

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

Office 2013

Last modified: January 09, 2014

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 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

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

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

Show:
© 2015 Microsoft