[Libreoffice-ux-advise] [Bug 98255] New: Excel keyboard shortcut bindings for Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=98255

            Bug ID: 98255
           Summary: Excel keyboard shortcut bindings for Calc
           Product: LibreOffice
           Version: 5.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: philipz85 at hotmail.com
                CC: dennisfrancis.in at gmail.com,
                    libreoffice-ux-advise at lists.freedesktop.org

After learning about the ability to use the OO.o legacy keyboard shortcuts
through Tools > Options > LibreOffice Calc > Compatibility in bug 97906, I felt
it would be a good idea to provide Excel users with that ability to change
Calc's default shortcuts to those found in Excel. This would reduce the barrier
of entry for Excel shortcut/power users and make it easy for shortcut users who
use both Excel and Calc on a regular basis.

Looking at Dennis's patch in bug 97906, it would be useful if the
ScDocShell::ResetKeyBindings() function in sc/source/ui/docshell/docsh.cxx
could load shortcuts from an external xml source, so that it is not hardcoded
and easier to modify by non-programmers (like me :D). Here is an example for
the shortcuts

 <node oor:name="KeyEvent">
   <node oor:name="aCtrlShiftF4">
     <prop oor:name="KeyCode" oor:type="xs:string">
       <value>F4</value>
     </prop>
     <prop oor:name="Modifiers" oor:type="xs:string">
       <value>MOD1</value>
       <value>SHIFT</value>
     </prop>
   </node>
 </node>

and here is an example for the bindings

 <node oor:name="Binding">
   <node oor:name="KEY_DEFAULT">
     <node oor:name="aDelete" oor:type="xs:string">
       <value>.uno:ClearContents</value>
     </node>
     <node oor:name="aBackspace" oor:type="xs:string">
       <value>.uno:Delete</value>
     </node>
     <node oor:name="aCtrlShiftF4" oor:type="xs:string">
       <value>.uno:ViewDataSourceBrowser</value>
     </node>
   </node>
 </node>

I'm currently gathering the list of Excel shortcuts and their associations with
LO's UNO commands.

-- 
You are receiving this mail because:
You are on the CC list for the bug.