ASPxClientSpreadsheet.ProtectionWarning Event

Occurs when attempting to edit a locked cell in a protected worksheet.

Declaration

ProtectionWarning: ASPxClientEvent<ASPxClientCancelEventHandler<ASPxClientSpreadsheet>>

Event Data

The ProtectionWarning event's data class is ASPxClientCancelEventArgs. The following properties provide information specific to this event:

Property	Description
cancel	Gets or sets a value indicating whether the action which raised the event should be canceled.

Remarks

You can prevent displaying the warning dialog which appears each time a user attempts to modify a locked cell by setting the cancel event parameter to true. Then, you can invoke an own dialog within the event handler.

Usage Example

ASPX

<dx:ASPxSpreadsheet ID="ASPxSpreadsheet1" runat="server" Width="100%" Height="750px"
    ShowConfirmOnLosingChanges="False"
    ClientInstanceName="ss" WorkDirectory="~/App_Data/WorkDirectory" >
    <ClientSideEvents ProtectionWarning="onProtectionWarning" />
</dx:ASPxSpreadsheet>

JS

function onProtectionWarning(s, args) {
    args.cancel = true;
}