FormatContents Object (ExPivot)

The FormatContents object holds a collection of FormatContent objects. The FormatContent object holds information about how a column or row can be displayed, formatted or converted. The FormatContents property accesses the FormatContents collection. The following sample shows the control's context menu with a different appearance and more converting functions:

If the PivotBarVisible property includes the exPivotBarAllowFormatContent flag, the control's context menu includes the FormatContent objects. If the exPivotBarAllowFormatContent flag is missing from the PivotBarVisible property, the control's context menu displays no FormatContent objects.

By default, the FormatContents collection contains the following keys:

"numeric", with the Expression as "len(value) ? (value format '') : ''"
"currency", with the Expression as "len(value) ? currency(value) :''"
"date", with the Expression as "date(dbl(value))"

The FormatContents collection supports the following properties and methods:

		Name	Description
		Add	Adds a FormatContent object and returns a reference to the newly created object.
		Clear	Removes all objects in a collection.
		Count	Returns the number of objects in a collection.
		Item	Returns a specific FormatContent object giving its key.
		Remove	Removes a specific member from the collection.