Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Format Element (ASSL)

Contains the required format of the DataItem element.


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

Characteristic Description

Data type and length

String

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Relationship Element

Parent element

DataItem

Child elements

None

Allowed values for the Format element are Microsoft Office Excel formats, and the strings TrimRight, TrimLeft, TrimAll, and TrimNone. For trimming, TrimRight is the default.

The value of this element is limited to one of the strings in the following table.

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 element that corresponds to the parent of Format in the Analysis Management Objects (AMO) object model is DataItem.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.