| GC.Spread.Sheets.ConditionalFormatting 名前空間 > Condition タイプ : compareType メソッド |
| Javascript (Usage) | |
|---|---|
var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args); var returnValue; // Type: any returnValue = instance.compareType(value); | |
| Javascript (Specification) | |
|---|---|
function compareType( value : undefined ) : any; | |
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.numberCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.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);
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.dateCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.DateCompareType.before); nCondition.expected(new Date(2012, 11, 31)); 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, new Date(2012, 12, 12));
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.TextCompareType.contains); nCondition.expected("test"); 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, "testing");
var textLengthCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textLengthCondition); textLengthCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.greaterThan); textLengthCondition.expected(5); var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(textLengthCondition); 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, "abcf");
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.cellValueCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators.greaterThan); nCondition.formula("$C$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); activeSheet.setValue(0, 2, 4);
activeSheet.suspendPaint(); var rowFilter = new GC.Spread.Sheets.Filter.HideRowFilter(new GC.Spread.Sheets.Range(-1, 0, -1, 1)); activeSheet.rowFilter(rowFilter); activeSheet.getCell(0, 0).value("A1").backColor("blue"); activeSheet.getCell(1, 0).value("A2").backColor("yellow"); activeSheet.getCell(2, 0).value("A3").backColor("red"); activeSheet.getCell(3, 0).value("A4").backColor("green"); activeSheet.getCell(4, 0).value("A5").backColor("yellow"); var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.colorCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.ColorCompareType.backgroundColor); nCondition.expected("yellow"); var filter = activeSheet.rowFilter(); filter.addFilterItem(0, nCondition); filter.filter(0); activeSheet.resumePaint();
var condition1 = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.dateCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.DateCompareType.afterEqualsTo, expected: new Date(2012, 11, 31)}); var condition2 = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.dateCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.DateCompareType.beforeEqualsTo, expected: new Date(2013, 11, 31)}); var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.relationCondition); nCondition.compareType(GC.Spread.Sheets.ConditionalFormatting.LogicalOperators.and); nCondition.item1(condition1); nCondition.item2(condition2); 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, new Date(2012, 11, 25));