CheckSpelling Method
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

ChartSheet.CheckSpelling Method

Checks the spelling of an Microsoft.Office.Tools.Excel.ChartSheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual void CheckSpelling (
	[OptionalAttribute] Object CustomDictionary,
	[OptionalAttribute] Object IgnoreUppercase,
	[OptionalAttribute] Object AlwaysSuggest,
	[OptionalAttribute] Object SpellLang
)

Parameters

CustomDictionary

A string that indicates 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

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

AlwaysSuggest

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 will be used.

SpellLang

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

Microsoft Office Excel displays the Spelling dialog box

Optional Parameters

For information on optional parameters, see Understanding Optional Parameters in COM Interop.

The following code example uses the CheckSpelling method to check the spelling in the current Microsoft.Office.Tools.Excel.ChartSheet using the US English dictionary.

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

    this.ChartWizard(Globals.Sheet1.Range["A1", "B5"], 
        Excel.XlChartType.xl3DColumn, missing, 
        Excel.XlRowCol.xlColumns, missing, missing, missing,
        "Salez Datta", missing, missing, missing);

    this.CheckSpelling(missing, false, true,
        Office.MsoLanguageID.msoLanguageIDEnglishUS);
}

Show:
© 2016 Microsoft