DataColumn Element

Defines how a data column appears in the External Data window in the Visio user interface and qualifies the data in the column by defining its data type and formatting.

Syntax

<DataColumn
   ColumnNameID
   Name
   Label
   [OrigLabel]
   [LangID]
   [Calendar]
   [DataType]
   [UnitType]
   [Currency]
   [Degree]
   [DisplayWidth]
   [DisplayOrder]
   [Mapped]
   [Hyperlink]>
</DataColumn>

Attributes

ColumnNameID

Required String. External name of the data column. Appears in the headings in the External Data window and in labels in data graphics.

Name

Required String. Internal name of the data column. Used as the row name for the shape-data item (custom property) added to a shape when the shape is linked to a data row.

Label

Required String. Label of the data column.

OrigLabel

Optional String. Column label returned to Visio by the underlying ADO interface.

LangID

Optional unsigned Long. The language ID of the data column.

Calendar

Optional unsigned Short. Calendar ID of the data column.

DataType

Optional unsigned Short. Type of the data in the data column.

UnitType

Optional String. Unit type of the data in the data column.

Currency

Optional unsigned Short. Currency ID of the data column.

Degree

Optional unsigned Long. Specifies the degree (power) of the units, for example squared, or cubed. The default (attribute absent) is 1.

DisplayWidth

Optional unsigned Long. Width of the data column in the External Data window.

DisplayOrder

Optional unsigned Long. Defines the display position of the data column in the External Data window, from the left-most column (0) to the right-most column (largest value).

Mapped

Optional Boolean. Specifies whether the column is visible in the External Data window. True (1) for the column to be visible; False (0) for the column not to be visible. The default (attribute absent) is for the column to be visible.

Hyperlink

Optional Boolean. Whether the data column creates a hyperlink in a shape when the shape is linked to data.

Element properties

Property

Value

Name

DataColumn

Minimum Occurrences

1

Maximum Occurrences

Unbounded

Element information

Parent elements

VisioDocument

DataRecordsets

DataColumns

Child elements

None

Remarks

The ColumnNameID, DisplayWidth, DisplayOrder, and Mapped attributes determine the appearance of the data column itself in the External Data window.

The remaining attributes determine how Visio displays and formats the data in the column in the External Data window, how Visio displays the data when it is linked to a shape, and how Visio uses the data in internal calculations.