Articles in this section
Category / Section

How to perform SpellChecker in WinForms GridControl?

3 mins read

Spellchecker

The Essential Grid does not have direct support for SpellChecker. In order to achieve SpellChecker in Grid, you need to customize the Grid by creating the custom cell renderer and cell model. Refer to the following article link to know more about the creating cell renderer and cell model

How to create the Cell Model and Cell Renderer?

Solution:

In this article, the SpellChecker component is used to validate the strings in the cell. Based on the result, the cell text is underlined when the text is misspelled, since customization for multiple words is not provided. To know more about the SpellChecker component, you can refer to the following link: Spellchecker

Creating cell renderer and cell model:

C#

public class SpellCheckCellRenderer : GridTextBoxCellRenderer
{
    //Using SpellChecker tool.
    private SpellChecker spellchecker;
    public SpellCheckCellRenderer(GridControlBase grid, GridCellModelBase cellModel) : base(grid, cellModel)
    {
        spellchecker = new SpellChecker();
    }
    //To underline the word in cell that is misspelled.
    protected override void OnDraw(Graphics g, Rectangle clientRectangle, int rowIndex, int colIndex, GridStyleInfo style)
    {
       //Validate the cell values.
       string check = this.spellchecker.SpellCheck(style.CellValue.ToString());
       //Checking whether the result has suggestions.
       if(check != "")
       {
          style.Font.Underline = true;
       }
       base.OnDraw(g, clientRectangle, rowIndex, colIndex, style);
    }
}
public class SpellCheckCellModel : GridTextBoxCellModel
{
    ///<summary>
    ///Initializes a new <see cref="PercentTextBoxCellModel"/>
    ///</summary>
    ///<param name="grid">GridModel.</param>
    public SpellCheckCellModel(GridModel grid) : base(grid)
    {    }
    /// <summary>
    /// Creates a cell renderer.
    /// </summary>
    /// <param name="control">GridControlBase</param>
    /// <returns>A new <see cref="PercentTextBoxCellRenderer"/>specific for a <see cref="GridControlBase"/></returns>
    public override GridCellRendererBase CreateRenderer(GridControlBase control)
    {
        return new SpellCheckCellRenderer(control, this);
    }
}

VB

Public Class SpellCheckCellRenderer
    Inherits GridTextBoxCellRenderer
    Private spellchecker As SpellChecker
    Public Sub New(ByVal grid As GridControlBase, ByVal cellModel As GridCellModelBase)
       MyBase.New(grid, cellModel)
       spellchecker = New SpellChecker()
    End Sub
    ‘To underline the word in cell that is misspelled.
    Protected Overrides Sub OnDraw(ByVal g As Graphics, ByVal clientRectangle As Rectangle, ByVal rowIndex As Integer, ByVal colIndex As Integer, ByVal style As GridStyleInfo)
       If style.CellValue IsNot Nothing Then
          Dim check As String = Me.spellchecker.SpellCheck(style.CellValue.ToString())
          'To check whether value has suggestion.
          If check <> "" Then
   style.Font.Underline = True
          End If
       End If
       MyBase.OnDraw(g, clientRectangle, rowIndex, colIndex, style)
    End Sub
End Class
Public Class SpellCheckCellModel
    Inherits GridTextBoxCellModel
    '''<summary>  
    '''Initializes a new <see cref="PercentTextBoxCellModel"/>
    '''</summary>
    '''<param name="grid">GridModel.</param>
    Public Sub New(ByVal grid As GridModel) 
        MyBase.New(grid)
    End Sub 
    ''' <summary>
    ''' Creates a cell renderer.  
    ''' </summary>
    ''' <param name="control">GridControlBase</param>
    ''' <returns>A new <see cref="PercentTextBoxCellRenderer"/>specific for a <see cref="GridControlBase"/></returns>
    Public Overrides Function CreateRenderer(ByVal control As GridControlBase) As GridCellRendererBase
       Return New SpellCheckCellRenderer(control, Me)
    End Function
End Class

Adding cell model and assigning CellType:

For GridControl:

C#

//Add the Custom Cell Model to Grid.
this.gridControl1.CellModels.Add("SpellCheckCell", new SpellCheckCellModel(this.gridControl1.Model));
//Set the Custom Cell Type.
this.gridControl1.TableStyle.CellType = "SpellCheckCell";

VB

'Add the Custom Cell Model to Grid.
Me.gridControl1.CellModels.Add("SpellCheckCell", New SpellCheckCellModel(Me.gridControl1.Model))
'Set the Custom Cell Type.
Me.gridControl1.TableStyle.CellType = "SpellCheckCell"

For GridGroupingControl:

C#

//Add the Custom Cell Model to Grid.
this.gridGroupingControl1.TableModel.CellModels.Add("SpellCheckCell", new SpellCheckCellModel(this.gridGroupingControl1.TableModel));
//Set the Custom Cell Type.
this.gridGroupingControl1.TableDescriptor.Columns[1].Appearance.AnyRecordFieldCell.CellType = "SpellCheckCell";

VB

'Add the Custom Cell Model to Grid.
Me.gridGroupingControl1.TableModel.CellModels.Add("SpellCheckCell", New SpellCheckCellModel(Me.gridGroupingControl1.TableModel))
'Set the Custom Cell Type.
Me.gridGroupingControl1.TableDescriptor.Columns(1).Appearance.AnyRecordFieldCell.CellType = "SpellCheckCell"

For GridDataBoundGrid:

C#

//Add the Custom Cell Model to Grid.
this.gridDataBoundGrid1.Model.CellModels.Add("SpellCheckCell", new SpellCheckCellModel(this.gridDataBoundGrid1.Model));
//Set the Custom Cell Type.
this.gridDataBoundGrid1.Binder.InternalColumns[1].StyleInfo.CellType = "SpellCheckCell";

VB

'Add the Custom Cell Model to Grid.
Me.gridDataBoundGrid1.Model.CellModels.Add("SpellCheckCell", New SpellCheckCellModel(Me.gridDataBoundGrid1.Model))
'Set the Custom Cell Type.
Me.gridDataBoundGrid1.Binder.InternalColumns(1).StyleInfo.CellType = "SpellCheckCell"

Screenshot:

Show the spell checking process in grid

Figure 1: Output

Samples:

GridControl:

C#: SpellChecker_GridControl_CS

VB: SpellChecker_GridControl_VB

GridGroupingControl:

C#: SpellChecker_GGC_CS

VB: SpellChecker_GGC_VB

GridDataBoundGrid:

C#: SpellChecker_GDBG_CS

VB: SpellChecker_GDBG_VB


Conclusion

I hope you enjoyed learning about how to perform SpellChecker in WinForms GridControl, GridGroupingControl and GridDataBoundGrid.

You can refer to our WinForms GridControl feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WinForms GridControl example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forumsDirect-Trac, or feedback portal. We are always happy to assist you!

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied