Bug 148814 - When editing a footer/header in Libreoffice Calc, you cannot use keyboard shortcuts (such as CTRL+C/CTRL+V/CTRL+A) in your native language. Keyboard shortcuts work only in English.
Summary: When editing a footer/header in Libreoffice Calc, you cannot use keyboard sho...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste Calc-Header-Footer
  Show dependency treegraph
 
Reported: 2022-04-27 07:47 UTC by Leonid
Modified: 2023-08-12 03:06 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Result of CTRL+C/CTRL+V on English keyboard layout (214.86 KB, image/png)
2022-05-26 09:55 UTC, Leonid
Details
Result of CTRL+C/CTRL+V on Russian keyboard layout (when you edit footer/header) (214.86 KB, image/png)
2022-05-26 09:57 UTC, Leonid
Details
Result of CTRL+C/CTRL+V on English keyboard layout (when editing header/footer) (216.45 KB, image/png)
2022-05-26 10:00 UTC, Leonid
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Leonid 2022-04-27 07:47:55 UTC
Description:
Hello! 

I work on Lubuntu 21.04,
LibreOffice Version: 7.2.5.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 6; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU
Ubuntu package version: 1:7.2.5~rc2-0ubuntu0.21.04.1~lo1
Calc: threaded

I try to create footer/header in Libreoffice Calc. When I try copy/paste text it's not work. Then I realized what copy/paste work but only when I switch language to English. 
When editing a footer/header , you cannot use keyboard shortcuts (such as CTRL+C/CTRL+V/CTRL+A) in your native language. Keyboard shortcuts work only in English.

Then I try this case on Windows XP x86 on old version of LibreOffice Calc(about 4). This case repeat. On old version of LibreOffice Calc on Windows XP this problem also exists.

Thank you!
I love your soft! You are best!

Steps to Reproduce:
1.Open LibreOffice Calc
2.Enter in Insert in top menu
3.Choose Footer/Header
4.Pick CentralAria or another Arias
5.Try copy, choose all or paste text with keyboard shortcut on English
6.It work on English system language
7.Then switch system language (not in LibreOffice), on my PC it can do with SHIFT+ALT
8.Try copy, choose all or paste text with keyboard shortcut
9.It don't work on other language (I use Russian language)


Actual Results:
Copy, choose all or paste text with keyboard shortcut don't work on other system language when creating footer or header

Expected Results:
Copy, choose all or paste text with keyboard shortcut work on other system language when creating footer or header


Reproducible: Always


User Profile Reset: No



Additional Info:
)
Comment 1 Leonid 2022-05-26 09:55:40 UTC
Created attachment 180403 [details]
Result of CTRL+C/CTRL+V on English keyboard layout
Comment 2 Leonid 2022-05-26 09:57:37 UTC
Created attachment 180404 [details]
Result of CTRL+C/CTRL+V on Russian keyboard layout (when you edit footer/header)
Comment 3 Leonid 2022-05-26 09:59:26 UTC
Comment on attachment 180403 [details]
Result of CTRL+C/CTRL+V on English keyboard layout

THIS attachment is fail
Comment 4 Leonid 2022-05-26 10:00:28 UTC
Created attachment 180407 [details]
Result of CTRL+C/CTRL+V on English keyboard layout (when editing header/footer)
Comment 5 Roman Kuznetsov 2023-01-11 14:17:42 UTC
Pasting in footer dialog doesn't work for me with ru and with en keyboard layout in

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 376152fbd110cdc0a2cde1fa9758f36c016d9352
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 6 Stéphane Guillou (stragu) 2023-01-12 09:26:58 UTC
Tested on Windows 10, with a German keyboard hardware, and en-GB locale:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ec2f1d73936c9d8cee83c0887170e9ecb8f044ba
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

Also tested on Ubuntu 20.04, with German keyboard hardware, and en-US locale:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 92deea6301a02f5530f17263f58402344f82013c
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

In the Header tab, I had different results depending on if the cut/copied text was the "Sheet1" (which is a field whose number increments on other sheets, it can be seen when opening the same dialog on a second sheet) or if it was text that I added. I could not find issues in the Footer tab.

Changing the keyboard layout in the OS settings did not change the results. I tested with English (United Kingdom) and German (Germany) on Windows, and with English (Australian) and German (dead tilde) on Linux.

Ctrl + A always worked.

--- Header tab ---

1) For the original "Sheet1" text:
I _could_ copy and cut it from the Centre area, but I could _not_ paste it in the three fields of the dialog.
However, I _could_ paste that "Sheet1" in a different app, like Notepad.
After closing the dialog, I could still paste it in a different app but still couldn't in a Calc cell.

2) For text that I added myself:
Cutting, copying and pasting worked as expected in the dialog, in a Calc cell after closing the dialog, and in Notepad.

If I copy or cut text that includes both "Sheet1" and some extra text, it only pastes the custom text (and loses "Sheet1").

--- Footer tab ---

The footer tab was different in that I could copy, cut and paste anything to and from anywhere, including the original content "Page 1". Pasting the original "Page 1" in a Calc cell results in "Page ?", the "?" being a field. Pasting it in Notepad results in "Page 1".

I _could_ copy text before opening the dialog, and then paste text inside the dialog, in both Header and Footer.

On Linux, it is clearly visible that the whole of "Sheet1" is a field whereas only the "1" of "Page 1" is a field (thanks to the shading).

--- To summarise ---

According to my tests, my summary of the issue:

"Sheet1" in "Insert > Headers and Footers... > Header" can be cut and copied but not pasted anywhere in Calc (dialog or cells). Changing the keyboard layout has no effect.

Leonid, can you please check again and tell us if you see something different? And please test a newer version of LibreOffice (7.4 or above) because 7.2 and 7.3 have already reached end of life.
Comment 7 Buovjaga 2023-01-12 10:33:43 UTC
(In reply to Roman Kuznetsov from comment #5)
> Pasting in footer dialog doesn't work for me with ru and with en keyboard
> layout in

We discussed this in the chat yesterday and Roman's result was with the special field element. Pure text worked fine. Leonid's screenshots show pure text, so it appears none of us can reproduce that specific problem.
Comment 8 QA Administrators 2023-07-12 03:14:35 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2023-08-12 03:06:13 UTC
Dear Leonid,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp