Bug 136129 - Shortcut for Show Formula (Ctrl+`) not available in LibreOffice Calc
Summary: Shortcut for Show Formula (Ctrl+`) not available in LibreOffice Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Shortcuts-Locale Shortcuts-Grave
  Show dependency treegraph
 
Reported: 2020-08-26 00:34 UTC by Felipe Viggiano
Modified: 2024-08-17 12:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Felipe Viggiano 2020-08-26 00:34:51 UTC
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
Comment 1 m_a_riosv 2020-08-26 09:25:32 UTC
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.
Comment 2 Dan Lewis 2020-08-26 23:43:22 UTC
   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.
Comment 3 Ming Hua 2020-08-27 00:35:30 UTC
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.
Comment 4 Felipe Viggiano 2020-08-27 01:49:16 UTC
(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.
Comment 5 QA Administrators 2023-06-02 03:16:57 UTC Comment hidden (obsolete)
Comment 6 Saburo 2024-08-17 12:05:00 UTC
Reproduced in Japanese Keyboard.

To type ` on a Japanese keyboard, use Shift + @

When I press Ctrl + Shift + @, nothing happens.

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded