Created attachment 172566 [details]
Example file from Calc with a formula
The shortcut key for the View – Show Formula command is Ctrl + ` which cannot be entered on Windows with a Hungarian keyboard layout, since the backtick is entered by pressing AltGr + 7 and that cannot be combined with Ctrl.
Steps to reproduce:
1. Open Calc
2. Enter a simple formula such as =PRODUCT(A1;A2)
3. Press Ctrl + `
Shortcut does not work, a ` (backtick) is entered in the current cell.
The cell should display the formula instead of its result. Selecting View – Show Formula works.
Hungarian Excel uses the Alt + . (dot) combination, this could work for us.
Version: 220.127.116.11.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Test with Bosnian keyboard (same as Slovenian, Croatian, Serbian Latin..) which have the same AltGr + 7 for `.
In Linux, View menu shows Ctrl+grave (it should show Ctrl + ) but in Customize View – Show Formula doesn't show anything.
In Windows, View menu shows Ctrl (just Ctrl, incorrect) and also nothing in Customize for View – Show Formula.
So, same problem.
My English Excel says:
Switch between displaying cell values or formulas in the worksheet: Ctrl+grave accent (`)
So I confirm the problem on some keyboards, but not the universal solution.
I'd rather focus on fixing View menu and Customize, and leave this for a user to customize.
(In reply to Timur from comment #1)
> Test with Bosnian keyboard (same as Slovenian, Croatian, Serbian Latin..)
> which have the same AltGr + 7 for `.
> In Linux, View menu shows Ctrl+grave (it should show Ctrl + ) but in
> Customize View – Show Formula doesn't show anything.
> In Windows, View menu shows Ctrl (just Ctrl, incorrect) and also nothing in
> Customize for View – Show Formula.
> So, same problem.
> My English Excel says:
> Switch between displaying cell values or formulas in the worksheet:
> Ctrl+grave accent (`)
> So I confirm the problem on some keyboards, but not the universal solution.
> I'd rather focus on fixing View menu and Customize, and leave this for a
> user to customize.
There is a meta bug with exactly these problems: bug 115280
...and of those I have submitted a gerrit for bug 115282 (missing combination from Customize - Keyboard list):
Proposed patch for this bug is limited to Hungarian since I found a mention that Ctrl-grave comes from English Excel.
This could serve as template for other languages:
Gabor Kelemen committed a patch related to this issue.
It has been pushed to "master":
tdf#142612 Replace Show Formula command shortcut for Hungarian
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Version: 18.104.22.168.alpha0+ (x64) / LibreOffice Community
Build ID: 3964e0854507b2696ae0fbe48a4fb005c779947e
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU