ApplicationOptionsSpreadsheetExtensions.AddSpreadsheet(ApplicationOptions, Action<SpreadsheetOptions>) Method

Allows you to configure a Spreadsheet.

Namespace: DevExpress.AspNetCore

Assembly: DevExpress.AspNetCore.Spreadsheet.v21.1.dll

NuGet Package: DevExpress.AspNetCore.Spreadsheet

Declaration

public static ApplicationOptions AddSpreadsheet(
    this ApplicationOptions applicationOptions,
    Action<SpreadsheetOptions> spreadsheetOptions
)

Parameters

Name	Type	Description
applicationOptions	ApplicationOptions	The application options.
spreadsheetOptions	Action<SpreadsheetOptions>	A method that configures the Spreadsheet options.

Returns

Type	Description
ApplicationOptions	An object that can be used to further configure the application options.

Remarks

C#

services.AddDevExpressControls(options => {
    options.AddSpreadsheet(
        spreadsheetOptions => {
            spreadsheetOptions
                .AddCellValueChanged(
                    (object sender, SpreadsheetCellEventArgs e) => {
                        if(!e.OldValue.IsEmpty && e.Value.IsEmpty) {
                            e.Cell.Value = "deleted";
                        }
                    }
                );
            }
        );
});