[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=14
   ||3187

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=65
   ||911

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

 CC||pos...@posteo.eu

--- Comment #11 from V Stuart Foote  ---
*** Bug 128247 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #10 from Yousuf Philips (jay)  ---
(In reply to Dan Dascalescu from comment #9)
> Also, Alt+I, R works in Google Sheets.
>
> Would be nice to allow users to reuse their shortcut muscle memory.

You can customize the menu bar (Tools > Customize > Menus) if your prefer a
different arrangement, but this bug is focused on keyboard shortcuts and not
menu bar shortcuts. :D

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #9 from Dan Dascalescu  ---
Also, Alt+I, R works in Google Sheets.

Would be nice to allow users to reuse their shortcut muscle memory.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #8 from Dan Dascalescu  ---
What I miss the most is Alt+I, R to insert a row. Any chance to add that as a
stopgap measure?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #7 from Cor Nouws  ---
(In reply to Yousuf (Jay) Philips from comment #0)
> 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.

Looks as a good idea.

(In reply to Yousuf (Jay) Philips from comment #5)
> Look forward to seeing your cell management shortcuts, as presently are were
> using only using Ctrl + Plus (insert cell) and Ctrl + Minus (delete cell).
> Ideally we'd need shortcuts to insert rows and columns, delete rows and
> columns, 

Lightning fast for me is Shft+SPACE followed by Ctrl++ / Ctrl+-

> Regarding ctrl+ for text formatting, we are already using alot of
> these, but it would be good to add and improve of them (e.g. Strike Through,
> Superscript, Subscript)

When the discussion tends to include possible change/extend of current short
cuts, there is the complicated validating of costs versus gains and desired
when possible consistency over the various applications :)
(wishing our selves much luck and wisdom ;) )

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #6 from Hillie  ---
(In reply to Yousuf (Jay) Philips from comment #0)
> 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.

Great idea and I agree completly re barrier to entry!  I would add though, the
only shortcut I really missed so far coming from Excel is the F4 for the repeat
command.  Many of the other shortcuts are the same as Excel or they are better
than the ones in Excel.  I especially love the menu system in Libreoffice vs
the ribbon in Excel 2007 and newer.  Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

V Stuart Foote  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=99
   ||595

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

   Keywords||needsDevEval, topicUI

--- Comment #5 from Yousuf (Jay) Philips  ---
(In reply to Heiko Tietze from comment #3)
> I support the idea of having multiple configuration presets. We should
> consider to redefine LibO shortcuts for harmonization purpose and to make
> them different from Excel.

Totally agree.

> I have something in mind like ctr+ for
> cell management and ctrl+ for formatting. In other words, a generic
> shortcut guideline.

Look forward to seeing your cell management shortcuts, as presently are were
using only using Ctrl + Plus (insert cell) and Ctrl + Minus (delete cell).
Ideally we'd need shortcuts to insert rows and columns, delete rows and
columns, as well as hide and unhide rows and columns. From the ctrl+
entries, we are currently utilizing Ctrl + 1 (format cell), Ctrl + 2 (line
spacing 2) and Ctrl + 5 (line spacing 1.5).

Regarding ctrl+ for text formatting, we are already using alot of
these, but it would be good to add and improve of them (e.g. Strike Through,
Superscript, Subscript)

> BTW: Incredible work, Jay.

Thanks

(In reply to V Stuart Foote from comment #4)
> Adding support with key mappings from Excel, or QuatroPro, or Google Docs,
> or Numbers, or Gnumeric, etc. via the Tools -> Options -> LibreOffice Calc
> -> Compatibility panel.

I only plan to do Excel as Google Docs and Gnumeric are mimicking its key
mapping, while most of QuatroPro's key mapping is identical to LO and it isnt
very shortcut key driven.

> And also, if the assignments made now in docsh.cxx [1] can be refactored to
> work from XML expect that would simplify managing the alternate
> compatibility mode--almost like skins. And would allow
> implementation/maintenance of more than just a mapping set for Excel.

Would definitely make it easier for others to contribute other implementations
for other apps.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #4 from V Stuart Foote  ---
If it can be reliably implemented, agree this would be a reasonable enhancement
on both counts -- extending Kohei's 2010 framework and providing additional
keyboard mappings beyond our LO Default and legacy OOo.

Adding support with key mappings from Excel, or QuatroPro, or Google Docs, or
Numbers, or Gnumeric, etc. via the Tools -> Options -> LibreOffice Calc ->
Compatibility panel.

And also, if the assignments made now in docsh.cxx [1] can be refactored to
work from XML expect that would simplify managing the alternate compatibility
mode--almost like skins. And would allow implementation/maintenance of more
than just a mapping set for Excel.


=-ref-=
[1]
http://opengrok.libreoffice.org/xref/core/sc/source/ui/docshell/docsh.cxx#2953

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Cor Nouws  changed:

   What|Removed |Added

Version|5.2.0.0.alpha0+ Master  |Inherited From OOo

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

--- Comment #3 from Heiko Tietze  ---
I support the idea of having multiple configuration presets. We should consider
to redefine LibO shortcuts for harmonization purpose and to make them different
from Excel. I have something in mind like ctr+ for cell management and
ctrl+ for formatting. In other words, a generic shortcut guideline.
BTW: Incredible work, Jay.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 CC|libreoffice-ux-advise@lists |er...@redhat.com
   |.freedesktop.org|

--- Comment #2 from Yousuf (Jay) Philips  ---
So progress on getting the excel list can be found in the link below.

https://docs.google.com/spreadsheets/d/1AmDXLkQiFK5OcOrtuGn7iAcqp2Yhc_eNNnlADk-ji-U/edit?usp=sharing

@Eike: Do you had any thoughts on this enhancement?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 Depends on|96969   |

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 Blocks||98259

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Óvári  changed:

   What|Removed |Added

 Depends on||96969

--- Comment #1 from Óvári  ---
(In reply to Yousuf (Jay) Philips from comment #0)
> I'm currently gathering the list of Excel shortcuts and their associations
> with LO's UNO commands.

Please see Bug 96969 entire column selection keyboard shortcut to Ctrl+Space.

Thank you

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98255] Excel keyboard shortcut bindings for Calc

[bugzilla-daemon]

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

Yousuf (Jay) Philips  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||c...@nouenoff.nl,
   ||vstuart.fo...@utsa.edu
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs