-
Spread Windows Forms 18 Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
-
Customizing Interaction in Cells
- Using Edit Mode and Focus
- Customizing User Selection and Deselection of Data
- Using Drag Operations to Fill Cells
- Using Double Click to Fill Cells
-
Using Validation
-
Using Validation in Cells
- Using a Cell Comparison Validator
- Using a Character Format Validator
- Using a String Comparison Validator
- Using a Value Comparison Validator
- Using an Encoding Validator
- Using the Exclude List Validator
- Using the Include List Validator
- Using a Pair Validator
- Using the Range Validator
- Using a Regular Expression Validator
- Using a Required Field Validator
- Using a Required Type Validator
- Using a Surrogate Character Validator
- Using a Text Length Validator
- Validating User Input
- Customizing the User Error Messages
- Displaying Error Icons in Cells or Rows
-
Using Validation in Cells
- Using Visible Indicators in the Cell
- Customizing Undo and Redo Actions
- Customizing Interaction Based on Events
- Displaying Context Menu at Runtime
- Adding Custom Context Menu to a Component
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
Using a String Comparison Validator
You can create a validator that compares string values.
A validation error occurs if the value does not match the specified conditions. You can also create an action, such as displaying an icon in the cell, that lets the user know the value is invalid.
Use the CompareStringValidator class to create the string validator. Specify a notification type such as IconNotify. Then use the AddValidators method to add the validator to a cell range.
The following image displays an error icon with a text tip.
Using Code
The following example displays an icon if you type a string that does not contain "Test".
//Type a value in cell 1,1
FarPoint.Win.Spread.IconNotify iconn = new FarPoint.Win.Spread.IconNotify();
iconn.Icon = new System.Drawing.Icon("C:\\Program Files (x86)\\Mescius\\spread.ico");
iconn.IconAlignment = ContentAlignment.MiddleCenter;
iconn.IconTip = "Must contain Test";
FarPoint.Win.Spread.CompareStringValidator svalid = new FarPoint.Win.Spread.CompareStringValidator();
svalid.ComparedOperator = FarPoint.Win.Spread.CompareStringValidatorOperator.Contains;
svalid.ComparedString = "Test";
svalid.Actions.Add(iconn);
fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), svalid);
fpSpread1.Sheets[0].Columns[1].Width = 140;
fpSpread1.Sheets[0].Rows[1].Height = 50;'Type a value in cell 1,1
Dim iconn As New FarPoint.Win.Spread.IconNotify()
iconn.Icon = New System.Drawing.Icon("C:\Program Files (x86)\Mescius\spread.ico")
iconn.IconAlignment = ContentAlignment.MiddleCenter
iconn.IconTip = "Must contain Test"
Dim svalid As New FarPoint.Win.Spread.CompareStringValidator()
svalid.ComparedOperator = FarPoint.Win.Spread.CompareStringValidatorOperator.Contains
svalid.ComparedString = "Test"
svalid.Actions.Add(iconn)
fpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), svalid)
fpSpread1.Sheets(0).Columns(1).Width = 140
fpSpread1.Sheets(0).Rows(1).Height = 50See Also
Using a Cell Comparison Validator
Using a Character Format Validator
Using a Value Comparison Validator
Using the Exclude List Validator
Using the Include List Validator
Using a Regular Expression Validator
Using a Required Field Validator
Using a Required Type Validator