FormatConditionalAppearances class (Pivot)

new FormatConditionalAppearances(oPivot)

The FormatConditionalAppearances object holds the conditional-formats to apply on the pivot control. For instance, you can change the visual-appearance for positive values only. The FormatConditionalAppearances / GetFormatConditionalAppearances() method returns the control's format-appearances that defines the visual-appearance to apply on pivot-columns, based on conditions.

By default, the FormatConditionalAppearances collection contains the following objects:

"negative", to show negative-numbers in red
"positive", to show positive-numbers in green

Parameters:

Name	Type	Description
`oPivot`	Pivot	Indicates an object of Pivot type that owns the collection

Example

The following sample shows the 0-cells in black and white:

oPivot.FormatConditionalAppearances.Add(
{
 key: "zero",
 shape: {fillColor: "black",tfi: {fgColor: "white"}},
 expression: "value = 0"
})

FormatConditionalAppearances

Methods

Add(oFormatOptions) → {FormatOptions}

The Add() method adds/updates the format based on its key

Parameters:

Name	Type	Description
`oFormatOptions`	object	Indicates an object of FormatOptions type that holds attributes of the format to add/replace

Returns:

Returns undefined (no key provided), or an the object being added of FormatOptions type that holds attributes of the format being added

Type: FormatOptions

Add

Clear()

The Clear() method clears the FormatOptions objects within the collection

Clear

GetCount() → {number}

The GetCount() method returns the number of FormatOptions objects within the collection

Returns:

Returns the number of FormatConditionalAppearances within the collection

Type: number

GetCount

Item(key) → {FormatOptions}

The Item() property gets the format based on the key

Parameters:

Name	Type	Description
`key`	string	Specifies the key of the format to request

Returns:

Returns undefined (no format found), or an the object being added of FormatOptions type that holds attributes of the format being added

Type: FormatOptions

Item

Remove(key) → {boolean}

The Remove() method removes the format giving its key

Parameters:

Name	Type	Description
`key`	string	Specifies the key of the format to remove

Returns:

Returns true, if the key has been removed

Type: boolean

Remove

forEach(callback, thisArg)

The forEach() method enumerates the FormatOptions objects within the current collection

Parameters:

Name	Type	Description
`callback`	callback	Indicates a function of callback(oFormatOptions) type, where oFormatOptions {object}, indicates the format of FormatOptions type
`thisArg`	any	Specifies the value of "this" keyword during the callback. If missing it refers to the current collection.

forEach