var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args);
function Condition;
var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args);
function Condition;
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.averageCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.AverageConditionType.above}); nCondition.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 3)]); var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition); validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom); activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator); spread.options.highlightInvalidData = true; activeSheet.setValue(0, 0, 5); activeSheet.setValue(1, 0, 15);
Object
GC.Spread.Sheets.ConditionalFormatting.Condition
Name | Description | |
---|---|---|
Condition Constructor | Represents a conditional item using the parameter object. |
Name | Description | |
---|---|---|
compareType | Gets or sets the rule compare type. | |
evaluate | Evaluates the condition using the specified evaluator. | |
expected | Gets or sets the expected value. | |
formula | ||
fromDay | Creates a date extend condition object from the specified day. | |
fromFormula | Creates the area condition from formula data. | |
fromMonth | Creates a date extend condition object from the specified month. | |
fromQuarter | Creates a date extend condition object from the specified quarter. | |
fromSource | Creates the area condition from source data. | |
fromWeek | Creates a date extend condition object from the specified week. | |
fromYear | Creates a date extend condition object from the specified year. | |
getExpected | Gets the expected value. | |
getValidList | Returns the list of valid data items. | |
ignoreBlank | Gets or sets whether to ignore the blank cell. | |
ignoreCase | Gets or sets whether to ignore case when performing the comparison. | |
item1 | Gets or sets the first condition. | |
item2 | Gets or sets the second condition. | |
ranges | Gets or sets the condition ranges. | |
reset | Resets this instance. | |
treatNullValueAsZero | Gets or sets whether to treat the null value in a cell as zero. | |
useWildCards | Gets or sets whether to compare strings using wildcards. |