SpreadsheetGear
IValidation Interface Members
See Also  Properties  Methods  Send Feedback
SpreadsheetGear Namespace : IValidation Interface


The following tables list the members exposed by IValidation.

Public Properties

 NameDescription
 PropertyAlertStyle Gets the alert style to be used when validation fails.  
 PropertyErrorMessage Gets or sets the error message to display when validation fails.  
 PropertyErrorTitle Gets or sets the error title to display when validation fails.  
 PropertyFormula1 Returns the first validation formula.  
 PropertyFormula2 Returns the second validation formula.  
 PropertyIgnoreBlank Gets or sets the property which specifies whether validation should be skipped if either validation formula refers to a blank cell.  
 PropertyInCellDropdown Gets or sets the property which specifies whether an in-cell dropdown listbox should be used for validation with a ValidationType of ValidationType.List.  
 PropertyInputMessage Gets or sets the input message to be displayed when one of the represented cells is active.  
 PropertyInputTitle Gets or sets the input title to be displayed when one of the represented cells is active.  
 PropertyOperator Returns the ValidationOperator.  
 PropertyShowError Gets or sets the property which specifies whether errors should be shown when validation fails.  
 PropertyShowInputMessage Gets or sets the property which specifies whether an input message should be displayed when one of the represented cells is active.  
 PropertyType Returns the type of validation.  
 PropertyValue Returns true if all represented cells meet their validation criteria.  
Top

Public Methods

 NameDescription
 MethodAdd Adds data validation to a range of cells using the specified options.  
 MethodDelete Deletes data validation  
 MethodModify Modifies existing data validation for a range of cells using the specified options.  
Top

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.