[]
Sheets.DataValidation.HighlightType
Indicates the data validation highlightType.
example
//This example uses the highlightStyle method.
sheet.setValue(1, 1, "sss");
var dv = GC.Spread.Sheets.DataValidation.createListValidator('Fruit,Vegetable,Food');
dv.highlightStyle({
type:GC.Spread.Sheets.DataValidation.HighlightType.dogEar,
color:'blue',
position:GC.Spread.Sheets.DataValidation.HighlightPosition.topLeft
});
sheet.setDataValidator(1,1, dv);
spread.options.highlightInvalidData = true;
• circle = 0
Specifies to use a circle in the invalid data cell.
• dogEar = 1
Specifies to use a dogEar in the invalid data cell.
• icon = 2
Specifies to use a icon in the invalid data cell.