# Using Validation in Cells

Learn how to validate cell contents and user input in Spread.NET with this comprehensive guide.

## Content



You can use built-in validators and actions to validate data in cells. The validators allow you to set validation conditions such as minimum and maximum values. The actions allow you to notify the user when a validation fails (cell color change, sound, and so on).

The following validators are available:

*   CharFormatValidator
*   CompareCellValidator
*   CompareStringValidator
*   CompareValueValidator
*   EncodingValidator
*   ExcludeListValidator
*   IncludeListValidator
*   PairCharValidator
*   RangeValidator
*   RegularExpressionValidator
*   RequiredFieldValidator
*   RequiredTypeValidator
*   SurrogateCharValidator
*   TextLengthValidator

The following validation actions are available:

*   Underline notifications ([LineNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.LineNotify.html))
*   Cell style notifications ([CellStyleNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.CellStyleNotify.html))
*   Icon notifications ([IconNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.IconNotify.html))
*   Sound notifications ([SoundNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SoundNotify.html))
*   Tooltip notifications ([TipNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.TipNotify.html))
*   Focus change notifications ([FocusProcess](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FocusProcess.html))
*   Previous value notifications ([ValueProcess](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.ValueProcess.html))
*   Message box notifications ([MessageBoxNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.MessageBoxNotify.html))
*   Three-state icon notifications ([ThreeStateIconNotify](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.ThreeStateIconNotify.html))

The following topics provide information about using validators in cells:

*   [Using a Cell Comparison Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellcomparevalidator)
*   [Using a Character Format Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellcharformatv)
*   [Using a String Comparison Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellcomparestring)
*   [Using a Value Comparison Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellcomparevalue)
*   [Using an Encoding Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellencodingvalid)
*   [Using the Exclude List Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellexcludevalidator)
*   [Using the Include List Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellincludevalidate)
*   [Using a Pair Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellpairvalidate)
*   [Using the Range Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellrangevalidator)
*   [Using a Regular Expression Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellregexpression)
*   [Using a Required Field Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellrequiredvalid)
*   [Using a Required Type Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellrequiretypev)
*   [Using a Surrogate Character Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-cellsurrogate)
*   [Using a Text Length Validator](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cellvalidation/spwin-celltextlvalid)

## See Also

[Validating User Input](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-datavalidate)

[Customizing the User Error Messages](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cntrlmessages)

[Displaying Error Icons in Cells or Rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cellvalid/spwin-cell-error)