# Worksheet Editor Dialogs

The `RadWorksheetEditor` class provides the `Dialog` property, which is of the type of `WorksheetEditorDialogs`. This class contains properties for each of the dialogs used in the `RadSpreadsheet` control.

The `WorksheetEditorDialogs` class contains the following properties:

* `HeaderFooterDialog`—Gets or sets the header/footer dialog. To set a custom header/footer dialog, extend the `HeaderFooterDialogContent` class.
* `FormatShapesDialog`—Gets or sets the format shapes dialog. To set a custom format shapes dialog, extend the `FormatShapesDialogContent` class.
* `SortingDialog`—Gets or sets the sorting dialog. To set a custom sorting dialog, extend the `SortingDialogContent` class.
* `TopFilterDialog`—Gets or sets the top10 filter dialog. To set a custom top10 filter dialog, extend the `TopFilterDialogContent` class.
* `CustomFilterDialog`—Gets or sets the custom filter dialog. To set a custom custom filter dialog, extend the `CustomFilterDialogContent` class.
* `CustomSortListsDialog`—Gets or sets the custom sort lists dialog. To set a custom custom sort lists dialog, extend the `CustomSortListsDialogContent` class.
* `DataValidationDialog`—Gets or sets the data validation dialog. To set a custom data validation dialog, extend the `DataValidationDialogContent` class.
* `AlertDialog`—Gets or sets the alert dialog. To set a custom alert dialog, extend the `AlertDialogContent` class.
* `ConfirmDialog`—Gets or sets the confirm dialog. To set a custom confirm dialog, extend the `ConfirmDialogContent` class.
* `StopDialog`—Gets or sets the stop dialog. To set a custom stop dialog, extend the `StopDialogContent` class.
* `WarningDialog`—Gets or sets the warning dialog. To set a custom warning dialog, extend the `WarningDialogContent` class.
* `InformationDialog`—Gets or sets the information dialog. To set a custom information dialog, extend the `InformationDialogContent` class.
* `UnhideSheetDialog`—Gets or sets the unhide sheet dialog. To set a custom unhide sheet dialog, extend the `UnhideSheetDialogContent` class.
* `InsertChartDialog`—Gets or sets the insert chart dialog. To set a custom insert chart dialog, extend the `InsertChartDialogContent` class.
* `ManageConditionalFormattingDialog`—Gets or sets the manage conditional formatting dialog. To set a custom manage conditional formatting dialog, extend the `ManageConditionalFormattingDialogContent` class.
* `FormatFontDialog`—Gets or sets the Format Font dialog. To set a custom Format Font dialog, extend the `FormatFontDialogContent` class.
* `ConditionalFormattingDialog`—Gets or sets the new/edit conditional formatting dialog. To set a custom new/edit conditional formatting dialog, extend the `ConditionalFormattingDialogContent` class.
* `PageSetupDialog`—Gets or sets the page setup dialog. To set a custom page setup dialog, extend the `PageSetupDialogContent` class.
* `NameManagerDialog`—Gets or sets the name manager dialog. To set a custom name manager dialog, extend the `NameManagerDialogContent` class.
* `DecimalNumberPromptDialog`—Gets or sets the decimal number prompt dialog. To set a custom decimal number prompt dialog, extend the `DecimalNumberPromptDialogContent` class.
* `FormatCellsDialog`—Gets or sets the format cells dialog. To set a custom format cells dialog, extend the `FormatCellsDialogContent` class.
* `InsertCellsDialog`—Gets or sets the insert cells dialog. To set a custom insert cells dialog, extend the `InsertCellsDialogContent` class.
* `RemoveCellsDialog`—Gets or sets the remove cells dialog. To set a custom remove cells dialog, extend the `RemoveCellsDialogContent` class.
* `ScaleFactorDialog`—Gets or sets the scale factor dialog. To set a custom scale factor dialog, extend the `ScaleFactorDialogContent` class.
* `SelectColorDialog`—Gets or sets the select color dialog. To set a custom select color dialog, extend the `SelectColorDialogContent` class.
* `InsertFunctionDialog`—Gets or sets the insert function dialog. To set a custom insert function dialog, extend the `InsertFunctionDialogContent` class.
* `StyleDialog`—Gets or sets the style dialog. To set a custom style dialog, extend the `StyleDialogContent` class.
* `CreateNewThemeColorsDialog`—Gets or sets the create new theme colors dialog. To set a custom create new theme colors dialog, extend the `CreateNewThemeColorsDialogContent` class.
* `ProtectDialog`—Gets or sets the protect dialog. To set a custom protect dialog, extend the `ProtectDialogContent` class.
* `UnprotectDialog`—Gets or sets the unprotect dialog. To set a custom unprotect dialog, extend the `UnprotectDialogContent` class.
* `CreateNewThemeFontsDialog`—Gets or sets the create new theme fonts dialog. To set a custom create new theme fonts dialog, extend the `CreateNewThemeFontsDialogContent` class.
* `SeriesDialog`—Gets or sets the series dialog. To set a custom series dialog, extend the `SeriesDialogContent` class.
* `HyperlinkDialog`—Gets or sets the hyperlink dialog. To set a custom hyperlink dialog, extend the `HyperlinkDialogContent` class.
* `FindAndReplaceDialog`—Gets or sets the find and replace dialog. To set a custom find and replace dialog, extend the `FindAndReplaceDialogContent` class.
* `CreateUpdateSpreadsheetNameDialog`—Gets or sets the create update spreadsheet name dialog. To set a custom create update spreadsheet name dialog, extend the `CreateUpdateSpreadsheetNameDialogContent` class.
* `SimpleConditionalFormattingDialog`—Gets or sets the simple conditional formatting dialog. To set a custom simple conditional formatting dialog, extend the `SimpleConditionalFormattingDialogContent` class.

## Accessing the Dialogs

The RadSpreadsheet control provides the `ActiveWorksheetEditor` property that gives you access to the active worksheet editor. You can use this property to access the `Dialogs` property of the active worksheet editor and utilize the dialogs as needed.

**Accessing the Dialogs**

```C#
var findAndReplaceDialog = this.radSpreadsheet.ActiveWorksheetEditor.Dialogs.FindAndReplaceDialog;
```

## Customizing the Dialogs

You can customize the dialogs by creating a new class that inherits from the dialog that you want to customize and override the necessary methods to implement your custom logic.

The following example showcases how to customize one of the properties provided by the WorksheetEditorDialogs class. It showcases how to introduce a custom `FindAndReplaceDialogContent` type for the `FindAndReplaceDialog` property. In the example, the `OnKeyDown` method is overridden to add custom logic for handling the Escape and Enter keys.

**Extending the FindAndReplaceDialogContent**

```C#
public class CustomFindAndReplaceDialogContent : FindAndReplaceDialogContent
{
    public CustomFindAndReplaceDialogContent()
    {
    }

    protected override void OnKeyDown(KeyEventArgs e)
    {
        if (e.Key == Key.Escape)
        {
            this.Close();
        }
        else if (e.Key == Key.Enter)
        {
            FindNextCommand.Execute(null);
        }
    }
}
```

**Setting the CustomFindAndReplaceDialogContent**

```C#
this.radSpreadsheet.ActiveWorksheetEditor.Dialogs.FindAndReplaceDialog = new CustomFindAndReplaceDialogContent();
```

## See Also

* [Text Orientation](https://www.telerik.com/products/wpf/documentation/controls/radspreadsheet/text-orientation)
