FormatContent.Key Property (ExPivot)

The Key property specifies the key of the FormatContent object. The Expression property defines the format to be applied. The Name property specifies the HTML caption to be displayed on the control's context menu. The ToolTip property specifies the HTML tooltip to be displayed on the control's context menu, when the cursor hovers the object.

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

		Type	Description
		String	A String expression that defines the key of the FormatContent object. The Key must includes alpha-numeric characters, any other character is ignored.