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.
Dear Felipe Viggiano, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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