ASPxSpreadsheet.ViewModeChanging Event

Fires before the control’s view mode is changed and allows you to cancel the action.

Namespace: DevExpress.Web.ASPxSpreadsheet

Assembly: DevExpress.Web.ASPxSpreadsheet.v20.2.dll

NuGet Package: DevExpress.Web.Office

Declaration

C#

public event ViewModeChangingEventHandler ViewModeChanging

VB.NET

Public Event ViewModeChanging As ViewModeChangingEventHandler

Event Data

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

Property	Description
Cancel	Gets or sets a value indicating whether the event should be canceled. Inherited from CancelEventArgs.
NewMode	A value specifying the view mode

Remarks

The Spreadsheet control provides the Reading view mode that simplifies viewing documents on mobile devices. When the control in this view mode, all documents are opened in the read-only mode, and the ribbon toolbar is replaced with the specific toolbar for the Reading view mode. The Reading view mode is an alternative to the Editing view mode - the view mode that provides the standard full-featured Spreadsheet.

Use this event to prepare the control for switching between the Reading and Editing view modes. For example, you can customize the control’s toolbar in the Reading view mode as demonstrated in the following code snippet:

ASPX

<dx:ASPxSpreadsheet ID="Spreadsheet" runat="server" OnViewModeChanging="Spreadsheet_ViewModeChanging">
    <SettingsView Mode="Reading" />
</dx:ASPxSpreadsheet>

C#

protected void Spreadsheet_ViewModeChanging(object sender, ViewModeChangingEventArgs e) {
    PrepareSpreadsheetControl(e.NewMode);
}

void PrepareSpreadsheetControl(SpreadsheetViewMode mode) {
    bool readingViewIsOn = (mode == SpreadsheetViewMode.Reading);

    Spreadsheet.ShowFormulaBar = !readingViewIsOn;
    Spreadsheet.ShowSheetTabs = !readingViewIsOn;

    if(readingViewIsOn) {
        Spreadsheet.CreateDefaultRibbonTabs(true);
        RibbonTab readingViewTab = Spreadsheet.RibbonTabs.Find(tab => tab is SRReadingViewTab);
        if(readingViewTab != null)
            readingViewTab.Groups[0].Items.Add(new SRFullScreenCommand());
    }
}

See the full example in the online demo.