IValidation Interface

Represents the data validation associated with a range of cells.

For a list of all members of this type, see IValidation members.

Syntax

[Visual Basic]
Public Interface IValidation 

[C#]
public interface IValidation 

[C++]
public __gc __interface IValidation 

[C++/CLI]
public interface class IValidation 

Remarks

With the exception of Value and Delete, data validation properties and methods cannot be used unless all of the represented cells currently have the same data validation criteria.

Use Value to determine whether the represented cells meet their data validation criteria.

Use Add to add data validation to cells which currently have no data validation.

Use Modify to modify data validation settings of cells which already have data validation.

Use Delete to delete all data validation criteria currently associated with the represented cells.

Use InputMessage and InputTitle to get and set the input message to be displayed when one of the represented cells is active.

Use ErrorMessage and ErrorTitle to get and set the error message to be displayed when data validation fails.

Requirements

Namespace: SpreadsheetGear

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

IValidation Members  | SpreadsheetGear Namespace

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.