Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Developer's Guide / Keyboard Interaction / Using Excel-compatible Keyboard Shortcuts
In This Topic
    Using Excel-compatible Keyboard Shortcuts
    In This Topic

    By using keyboard shortcuts, you can save your time and increase efficiency. Spread for WinForms provides ExcelCompatibleKeyboardShortcuts property which when set to true, allows you to use Excel-compatible keyboard shortcuts. 

    Note: The supported shortcuts and their behavior when ExcelCompatibleKeyboardShortcuts is true, may change in next releases to match with Excel behavior.

    The below table lists the Excel-compatible keyboard shortcuts:

    Shortcut Description
    Ctrl+` Toggle between displaying formulas in cells and displaying calculated values as in Excel
    Ctrl+1 Show "Format Cells" dialog
    Ctrl+Shift+F5 Show card (for .NET data object)
    Ctrl+K Show Insert Hyperlink dialog
    Ctrl+Enter Input data for multiple cells

     The below example code sets ExcelCompatibleKeyboardShortcuts property to true which allows you to use above mentioned shortcuts.

    C#
    Copy Code
    // Set ExcelCompatibleKeyboardShortcuts features to true
     fpSpread1.Features.ExcelCompatibleKeyboardShortcuts = true;
    // Set value in Cells
     fpSpread1.ActiveSheet.Cells["A1"].Value = 10;
     fpSpread1.ActiveSheet.Cells["B1"].Value = 20;
     // Set formula in Cell
     fpSpread1.ActiveSheet.Cells["C1"].Formula = "SUM(A1: B2)";
    

    VB
    Copy Code
    ' Set ExcelCompatibleKeyboardShortcuts features to true
    fpSpread1.Features.ExcelCompatibleKeyboardShortcuts = True
    ' Set value in Cells
    fpSpread1.ActiveSheet.Cells("A1").Value = 10
    fpSpread1.ActiveSheet.Cells("B1").Value = 20
    ' Set formula in Cell
    fpSpread1.ActiveSheet.Cells("C1").Formula = "SUM(A1: B2)"