reset メソッド

このインスタンスをリセットします。

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args);
var value; // Type: any
value = instance.reset();

function reset() : any;

使用例

次のサンプルコードは、resetメソッドを使用します。

Javascript

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(); });

Javascript

<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();
    });

Javascript

<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();
    });

参照

Condition タイプ