The shortcut for the Show Formula option in LibreOffice Calc is not available.
Although the menu option View > Show Formula refers to this shortcut, it appears to be not implemented (there is no reference to it in the Keyboard tab from the Customize dialog).
Steps to Reproduce:
1.Create a new spreadsheet in LibreOffice Calc.
2.Insert a a formula in the input line (for example =sum(2,2)).
3.Press Ctrl+` (grave accent).
The cell should show the formula (=sum(2,2)) instead of the result (4).
User Profile Reset: Yes
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
It's not defined also with:
Version: 18.104.22.168.alpha0+ (x64)
Build ID: 8700bace8c0714d853f5df6918ab9c8bb3d81f77
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
But Ctrl+` (grave accent), Doesn't look good to me because it would be only available on keyboard layouts when the grave accent it is not a dead key or a shift key.
A long issue with Ctr+; with layouts where ; it's a shift key.
I have access to both Ubuntu 20.04 and Windows 10. I am using the latest pre-release versions of LibreOffice 7.0 on them. (Window's version dated 13 Aug 2020 and Ubuntu dated 14 Aug 2020.)
In the window's version, I created a Calc file with 22.214.171.124 entering the numbers 1-10 in column A1-A10. In column B1, I entered the formula, =ATAN(A1). Then I dragged this down to B10. The B column now contained the values of the arc tangent calculated from the respective cells of the A column.
Then I pressed Ctrl+`. Now the B column contains the formulas used in the individual cells.
In Ubuntu, I opened a previously created Calc sheet created in 2009. When I pressed, Ctrl+`, I saw the formulas used in the individual cells.
If necessary, I can create before and after snapshots of this.
This sounds to me locale related, and maybe also the keyboard layout, just like the issue with Ctrl+; and Ctrl+Shift+; shortcuts discussed in bug 88027 (which Miguel also mentioned) and its many duplicates/see-alsos.
So it would be useful if people affected by this can try an en-US locale (if their keyboard has an ordinary ` key), and see if it makes any difference.
FWIW, Ctrl+` works for me on Windows:
Version: 126.96.36.199 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: zh-CN (zh_CN); UI-Language: en-US
(In reply to Felipe Viggiano from comment #0)
> (there is no reference to it in the Keyboard tab from the Customize dialog).
This is probably a separate issue, and has already been discussed in bug 115282.
(In reply to Ming Hua from comment #3)
> So it would be useful if people affected by this can try an en-US locale (if
> their keyboard has an ordinary ` key), and see if it makes any difference.
Just did as suggested (changed the locale to en-US) and could confirm the issue still present.
My keyboard does have an ordinary ` key.