Description: 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). Actual Results: Nothing happens. Expected Results: The cell should show the formula (=sum(2,2)) instead of the result (4). Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.0.0.3 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 Calc: threaded
It's not defined also with: Version: 7.1.0.0.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 7.0.1.1 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: 6.4.6.2 (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 Calc: threaded (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.