Format Element (ASSL)

Contains the required format of the DataItem element.

Syntax

  
<DataItem>  
   ...  
   <Format>...</Format>  
      ...  
</DataItem>  

Element Characteristics

Characteristic Description
Data type and length String
Default value None
Cardinality 0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element
Parent element DataItem
Child elements None

Remarks

The Format element accepts Microsoft Office Excel format strings and the TrimRight, TrimLeft, TrimAll, and TrimNone values. The default trimming value is TrimRight.

The following table describes the supported values:

Value Description
Any Excel format string Data is formatted according to the specified named or custom format string. Any format string that Excel supports can be supplied.
TrimAll Data is trimmed on the left and right.
TrimLeft Data is trimmed on the left.
TrimNone Data is not trimmed.
TrimRight Data is trimmed on the right.

The parent element of Format corresponds to DataItem in the Analysis Management Objects (AMO) object model.

See Also

Properties (ASSL)