Steps how to reproduce with Server Installation of Version: 24.8.0.0.alpha0+ (X86_64) Build ID: 173bf8bf8b8e485691f8f0b4b33da0a139babc34 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: Locale: de-DE (de_DE); UI: de-DE; Theme: Colibre Calc: CL threaded – newly created User Profile: 1. Open new Calc spreadsheet 2. Menu ˋExtras → Anpassen → Tastaturˊ 3. find List item → <Strg+,> → Aktuelle Zeit einfügen 4. Click a cell and try <Strg+,> » current date appears. 5. Menu ˋFormat → Zelle → Zahlen → Modify formatting from “TT.MM.JJ” to “JJJJ-MM-TT HH:MM:SS” » Result form me now at 2024-03-12 13:29 UTC+1: “2024-03-12 00:00:00” So current date, not current time has become inserted 😥 5. Click another empty cell and try <Strg+Shift+,> (= <Strg+;>) » Current Time (for me “13:30:25” just now) appears 👍 So list Item text needs to be adapted Additional ℹ️️ -------------- a) There is an additional Item "<Strg+;> → Aktuelles Datum einfügen" in step (3) So due to results in steps (4),(5) the explication texts are interchanged b) There is a possibly related Help issue! STR: 11. Visit Online Help “Tastenkombinationen für Tabellendokumente“ <https://help.libreoffice.org/24.8/de/text/scalc/04/01020000.html?DbPAR=CALC> 12. Search page for “Datum” or “strg+;” or “strg+,” or “Zeit” » no hits, functions not listed on that page 😥 I did not find other mentions in Online Help
Created attachment 193333 [details] Screenshot from UI Today with Server Installation of Version: 24.8.0.0.alpha0+ (X86_64) Build ID: 2146e66d8df2b7b6a2dd868e886cae76aaf7f48b CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE; Theme: Colibre Calc: threaded – Newly Created Test Profile This looks a little different. No interchange, but same text for both shortcuts: c) "STRG+; – Aktuelles Datum einfügen" d) "STRG+, – Aktuelles Datum einfügen" (c) is wrong! <Strg+;>, which on a German Keyboard Layout is <Str+Shift+,>, inserts current Time (for date 1899-12-30) d) With UI: en-US there is only 1description for "STRG+; – Insert current date" "STRG+, has no description. d1) Both shortcuts did nothing in CALC with active UI en-US in Calc with my German Keyboard and unchanged WIN Keyboard settings
(TL;DR: until the "real" shortcuts would work consistently in Calc, the way these are presented is not really helpful for users, since they won't be able to use it anyway.) FWIW... The problems with the shortcuts for "Insert current time" and "Insert current date" are not (just) about how they are described in the Customize > Keyboard tab, whether in English or in any other language. There are many reports about them not working, sometimes depending on keyboard layout, sometimes depending on UI language, or depending on OS... Considering that each keyboard layout might locate the comma and the semicolon characters in different locations (than the English US keyboard layout), the "real" shortcuts should be: [CTRL]+[however you get to type the semicolon character] > "Insert current Date" [CTRL]+[however you get to type the comma character] > "Insert current Time (on the date set to the 'zero' date serial number" This should be across every keyboard layout and languages (and OS?). Some examples... * For a Spanish(-Spain or -la) keyboard layout: the semicolon character is introduced by: [SHIFT]+[,] results in the semicolon character, so: [CTRL]+[SHIFT]+[,] > "Insert current Date with a Spanish-Spain keyboard layout" [CTRL]+[,] > "Insert current Time (on the date set to the 'zero' date serial number with a Spanish-Spain keyboard layout" * For a German keyboard layout, this would be the same as the Spanish keyboard layout, whichever the UI language would be. * For the US keyboard layout, there would be no need to add the [shift] key in either case. * For a French keyboard layout, the location of the comma and the semicolon characters might be different than for the US keyboard layout, but still the [shift] key is not needed. * If some keyboard layout requires some other auxiliary key (e.g. AltGr) in order to introduce the comma or the semicolon character, then that special key would be part of the shortcut for that keyboard layout. In all cases, the "shortcut" should still be "[CTRL]+[however you get to type the semicolon character]" and "[CTRL]+[however you get to type the comma character]". So, the real issue is about keyboard _scancodes_, instead of interpreting the shortcut as a literal way of how to insert the time/date values. Once the shortcuts would actually work (in a consistent manner), the way it is presented in the customize dialogue would be more relevant. ATM, these shortcuts *fail* in most keyboard layouts.
Thank you both. Issues with German keyboard layout shortcuts, including this specific issue, have been collected in bug 82117. But see also related bug 126888 and bug 154136. *** This bug has been marked as a duplicate of bug 82117 ***
@stragu, as you can read in comment 2, the "real" problem is not just with German keyboard layout or with German UI or in the way it is presented in the Customize dialogue. Reports keep showing up in different forms (e.g. the shortcuts fail in many non-US keyboard layouts). Is comment 2 worth repeating/copying in any other report(s)?
(In reply to ady from comment #4) > @stragu, as you can read in comment 2, the "real" problem is not just with > German keyboard layout or with German UI or in the way it is presented in > the Customize dialogue. Reports keep showing up in different forms (e.g. the > shortcuts fail in many non-US keyboard layouts). > > Is comment 2 worth repeating/copying in any other report(s)? You're right, but in this case we have to pick one of several potential duplicate targets. I think your analysis is valuable, maybe you can add it to meta bug 107243?