Enumeration: HighlightPosition

Sheets.DataValidation.HighlightPosition

Indicates the data validation highlightposition.

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;

Table of contents

Enumeration members

• bottomLeft
• bottomRight
• outsideLeft
• outsideRight
• topLeft
• topRight

Enumeration members

bottomLeft

• bottomLeft = 3

Specifies highlight flag on the bottomleft of the invalid data cell.

bottomRight

• bottomRight = 2

Specifies highlight flag on the bottomright of the invalid data cell.

outsideLeft

• outsideLeft = 4

Specifies image which type is icon on the left of the invalid data cell.

outsideRight

• outsideRight = 5

Specifies image which type is icon on the Right of the invalid data cell.

topLeft

• topLeft = 0

Specifies highlight flag on the topleft of the invalid data cell.

topRight

• topRight = 1

Specifies highlight flag on the topright of the invalid data cell.