Chart.CheckSpelling(Object, Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Checks the spelling of an object. Microsoft Office Excel displays the Spelling dialog box

public void CheckSpelling (object CustomDictionary, object IgnoreUppercase, object AlwaysSuggest, object SpellLang);

abstract member CheckSpelling : obj * obj * obj * obj -> unit

Public Sub CheckSpelling (Optional CustomDictionary As Object, Optional IgnoreUppercase As Object, Optional AlwaysSuggest As Object, Optional SpellLang As Object)

Parameters

CustomDictionary: Object

The file name of the custom dictionary to be examined if the word is not found in the main dictionary. If this argument is omitted, the currently specified dictionary is used.

IgnoreUppercase: Object

true to have Microsoft Office Excel ignore words that are all uppercase. false to have Excel check words that are all uppercase. If this argument is omitted, the current setting is used.

AlwaysSuggest: Object

true to have Excel display a list of suggested alternate spellings when an incorrect spelling is found. false to have Excel wait for you to input the correct spelling. If this argument is omitted, the current setting is used.

SpellLang: Object

The language of the dictionary being used. Can be one of the MsoLanguageID values used by the LanguageID[MsoAppLanguageID] property.

Examples

The following code example creates a Chart with misspellings in the title, and then uses the CheckSpelling method to check the spelling in the chart while ignoring uppercase words and suggesting alternate spellings.

private void CatchSpellingError()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.ChartWizard(this.Range["A1", "B5"], 
        Excel.XlChartType.xl3DColumn, 
        Excel.XlRowCol.xlColumns);

    chart1.CheckSpelling(true, true,
        Office.MsoLanguageID.msoLanguageIDEnglishUS);
}

Private Sub CatchSpellingError()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.ChartWizard(Me.Range("A1", "B5"), _
        Excel.XlChartType.xl3DColumn, PlotBy:=Excel.XlRowCol.xlColumns, _
        Title:="Salez Datta")

    Chart1.CheckSpelling(IgnoreUppercase:=True, AlwaysSuggest:=True, _
        SpellLang:=Office.MsoLanguageID.msoLanguageIDEnglishUS)
End Sub

Remarks

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to

Share via