ig.excel.ColorScaleConditionalFormat

Exposes properties which control the coloring of a WorksheetCell based on the cell's value as relative to minimum, midpoint, and maximum threshold values.

Remarks

This class support either a 2-color or 3-color scale, as determined by the value of the colorScaleType parameter of the constructor.

For 2-color scales, cells in the associated range are colored based on how their value relates to the minimum and maximum thresholds.

For 3-color scales, cells in the associated range are colored based on how their value relates to the minimum, midpoint, and maximum thresholds.

This class supports a maximum of three separate and distinct color thresholds.

Specifying only one threshold is not supported and may result in unexpected behavior.

If this instance is created as a 2-color scale, the ColorScaleConditionalFormat.midpointThreshold property is not applicable. Attempting to set a property on the object returned from the MidpointThreshold property in this case will cause an exception to be thrown.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.ext_core.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.