Udostępnij za pośrednictwem


ChartSheetBase.CheckSpelling Method

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

Syntax

'Declaration
Public Sub CheckSpelling ( _
    customDictionary As Object, _
    ignoreUppercase As Object, _
    alwaysSuggest As Object, _
    spellLang As Object _
)
public void CheckSpelling(
    Object customDictionary,
    Object ignoreUppercase,
    Object alwaysSuggest,
    Object spellLang
)

Parameters

  • customDictionary
    Type: System.Object
    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
    Type: System.Object
    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
    Type: System.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 will be used.

Remarks

Microsoft Office Excel displays the Spelling dialog box

Optional Parameters

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

Examples

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

Private Sub CheckForSpellingErrors()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

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

    Me.CheckSpelling(IgnoreUppercase:=False, AlwaysSuggest:=True, _
        SpellLang:=Office.MsoLanguageID.msoLanguageIDEnglishUS)
End Sub
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);
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace