See Also

IValidation Interface  | SpreadsheetGear Namespace

See Also SpreadsheetGear The Performance Spreadsheet Component Company 

IValidation Interface Members

SpreadsheetGear Namespace : IValidation Interface

IValidation overview

Public Properties

 Property AlertStyle Gets the alert style to be used when validation fails.
 Property ErrorMessage Gets or sets the error message to display when validation fails.
 Property ErrorTitle Gets or sets the error title to display when validation fails.
 Property Formula1 Returns the first validation formula.
 Property Formula2 Returns the second validation formula.
 Property IgnoreBlank Gets or sets the property which specifies whether validation should be skipped if either validation formula refers to a blank cell.
 Property InCellDropdown Gets or sets the property which specifies whether an in-cell dropdown listbox should be used for validation with a ValidationType of ValidationType.List.
 Property InputMessage Gets or sets the input message to be displayed when one of the represented cells is active.
 Property InputTitle Gets or sets the input title to be displayed when one of the represented cells is active.
 Property Operator Returns the ValidationOperator.
 Property ShowError Gets or sets the property which specifies whether errors should be shown when validation fails.
 Property ShowInputMessage Gets or sets the property which specifies whether an input message should be displayed when one of the represented cells is active.
 Property Type Returns the type of validation.
 Property Value Returns true if all represented cells meet their validation criteria.

Public Methods

 Method Add Adds data validation to a range of cells using the specified options.
 Method Delete Deletes data validation
 Method Modify Modifies existing data validation for a range of cells using the specified options.

See Also

IValidation Interface  | 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.