highlightInvalidData Method

Gets or sets whether to highlight invalid data.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Spread(host, options);
var returnValue; // Type: Object
returnValue = instance.highlightInvalidData(value);

function highlightInvalidData( 
   value : boolean
) : Object;

Parameters

value: Whether to highlight invalid data.

Return Value

true if invalid data is highlighted; otherwise, false.

Example

This example uses the highlightInvalidData method.

Javascript

spread.highlightInvalidData(true);
var dv = GcSpread.Sheets.DefaultDataValidator.createDateValidator(GcSpread.Sheets.ComparisonOperator.Between, new Date(2012, 11, 31), new Date(2013, 11, 31));
dv.showInputMessage = true;
dv.inputMessage = "Enter a date between 12/31/2012 and 12/31/2013.";
dv.inputTitle = "Tip";
var style = new GcSpread.Sheets.Style();
style.validator = dv;
activeSheet.setStyle(1,1,style,GcSpread.Sheets.SheetArea.viewport);

Remarks

The default value is false.

Reference

Spread type