Date: prev next · Thread: first prev next last
February 2016 Archives by date, by thread · List index


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@lists.freedesktop.org
          Reporter: philipz85@hotmail.com
                CC: dennisfrancis.in@gmail.com,
                    libreoffice-ux-advise@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.

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.