ig.excel.AverageConditionalFormat
Exposes properties which control the visual attributes of a WorksheetCell
based on whether a cell's value is above or below the average or standard deviation
for the associated range.
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.
-
aboveBelow
- .aboveBelow( );
- Return Type:
- ig.excel.FormatConditionAboveBelow
- Return Type Description:
- Returns a FormatConditionAboveBelow.
Returns a value which determines the manner in which cell values are compared against the average or standard deviation for the associated range.
See Also
-
aboveBelow
- .aboveBelow( value:ig.excel.FormatConditionAboveBelow );
- Return Type:
- ig.excel.FormatConditionAboveBelow
- Return Type Description:
- Returns a FormatConditionAboveBelow.
Sets a value which determines the manner in which cell values are compared against the average or standard deviation for the associated range.
- value
- Type:ig.excel.FormatConditionAboveBelow
See Also
-
numericStandardDeviation
- .numericStandardDeviation( );
Returns the numeric standard deviation for this condition. Applicable only when the AverageConditionalFormat.aboveBelow property is set to 'AboveStandardDeviation' or 'BelowStandardDeviation'.
-
numericStandardDeviation
- .numericStandardDeviation( value:number );
Sets the numeric standard deviation for this condition. Applicable only when the AverageConditionalFormat.aboveBelow property is set to 'AboveStandardDeviation' or 'BelowStandardDeviation'.
- value
- Type:number