SpreadsheetCustomDocumentProcessor.SettingsDialogs(Action<SpreadsheetDialogSettings>) Method

Enables you to customize the built-in dialog settings.

Namespace: DevExpress.Web.Mvc

Assembly: DevExpress.Web.Mvc5.v24.1.dll

NuGet Package: DevExpress.Web.Mvc5

Declaration

C#

public SpreadsheetCustomDocumentProcessor SettingsDialogs(
    Action<SpreadsheetDialogSettings> method
)

VB.NET

Public Function SettingsDialogs(
    method As Action(Of SpreadsheetDialogSettings)
) As SpreadsheetCustomDocumentProcessor

Parameters

Name	Type	Description
method	Action<SpreadsheetDialogSettings>	A delegate method that accepts SpreadsheetDialogSettings as a parameter.

Returns

Type	Description
SpreadsheetCustomDocumentProcessor	A SpreadsheetCustomDocumentProcessor object.

Remarks

The SettingsDialogs method’s parameter provides access to settings that allow you to customize the availability of elements within the built-in dialog forms.

controller

public ActionResult ActionMethodThatHandlesSpreadsheetCallbacks() {
    return SpreadsheetExtension.GetCallbackResult("SpreadsheetNameHere", p => {
        p.Saving(e => {
        p.SettingsDialogs(dialogs => {
            dialogs.SaveFileDialog.DisplaySectionMode = DevExpress.Web.ASPxSpreadsheet.SaveFileDialogDisplaySectionMode.ShowDownloadSection;
            dialogs.InsertLinkDialog.ShowEmailAddressSection = false;
         });
            byte[] docBytes = SpreadsheetExtension.SaveCopy("SpreadsheetNameHere", DocumentFormat.Xlsx);
            //saving "docBytes" to db
            e.Handled = true;
        });
    });
}

(PartialView)

@Html.DevExpress().Spreadsheet(settings => {
    settings.Name = "SpreadsheetNameHere";
    settings.CallbackRouteValues = new { Controller = ..., Action = "ActionMethodThatHandlesSpreadsheetCallbacks" }; 
    ...
}).GetHtml()