GC.Spread.Sheets.ConditionalFormatting Namespace > Condition type : reset Method |
var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args); var value; // Type: any value = instance.reset();
function reset() : any;
<input type="button" id="button1" value="button1"/> var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.numberCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan); nCondition.expected(5); 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); $("#button1").click(function () { activeSheet.suspendPaint(); nCondition.reset(); activeSheet.resumePaint(); });
<input type="button" id="button1" value="button1"/> var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.uniqueCondition, {expected: true, ranges: new GC.Spread.Sheets.Range(0, 5, 1, 1)}); 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); $("#button1").click(function () { activeSheet.suspendPaint(); nCondition.reset(); activeSheet.resumePaint(); });