Issue is similar to bug 88027, bug 126085 & bug 126888, but for Estonian locale/layout. Like German, Finnish and many other layouts, Estonian keyboards don't have a ";" key - that physical key is instead allocated for the letter "ö" and the semicolon character is being produced by Shift+comma instead, and colon by Shift+period instead. Thus, in Calc, there is clash between default shortcuts Ctrl+; for inserting current date and Ctrl+Shift+; for current time: only current time can be inserted by keyboard shortcut, as Shift has to be pressed anyway to get ";". Tested with LibO 6.3.1: - in Linux (Arch/KDE5) pressing Ctrl+Shift+, (== Ctrl+;) inserts current time, - in Windows (10) the same shortcut does nothing. (Should it then be two separate bug reports?) For comparison, in Excel (2010) with Estonian locale: Ctrl+Shift+, (== Ctrl+;) inserts current date Ctrl+Shift+. (== Ctrl+:) inserts current time
Did you try with Estonian UI? It works for me with Finnish UI, Ctrl+, is date, Ctrl+; is time. Mentioned in bug 88027 comment 29
On my system (up-to-date Arch Linux with KDE5, and LibO 7.0 daily), the UI language makes no difference - the keyboard layout does. Is it working for you with a Finnish layout? An interesting thing to note is that when I choose Tools - Customize - Keyboard, and press Ctrl+, in the list, then it actually highlights the row with "Ctrl+," (which has no action assigned by default - but it can be done manually now, so that's an improvement). When I press Ctrl+Shift+, then it highlights the row with "Ctrl+;" (which has "Insert Current Time" assigned). This happens with all the VCL plugins I tested with (kf5, gtk3, gen), so shouldn't be KDE-specific either.
Ah, I see now that Finnish has a special case added to the code, and I guess it works for you because your OS language is also Finnish (right?): https://cgit.freedesktop.org/libreoffice/core/commit/?id=61a91be4aaf6bdb40d6d1bde33b44eaf14014525 So basically the same thing should be done for Estonian - and presumably for a bunch of other (European?) languages, too. I'll prepare a patch (at least for Estonian) soonish.
Ah, indeed -> NEW
Created attachment 160665 [details] Define Ctrl+Comma and Ctrl+Shift+Comma with Estonian layout
Could someone commit the patch?
(In reply to Mihkel Tõnnov from comment #6) > Could someone commit the patch? I guess so, but as I see you already sent a license statement, you could also create a patch directly inside gerrit as the change is so simple: https://wiki.documentfoundation.org/Development/gerrit https://wiki.documentfoundation.org/Documentation/GerritEditing
With the proposed patch: Insert current date: Ctrl+Comma ( = Ctrl+, in the Customize - Keyboard dialog) Insert current time: Ctrl+Shift+Comma ( = Ctrl+Shift+; in the Customize - Keyboard dialog) Can't use the same shortcuts as in Excel (Ctrl+Shift+Comma & Ctrl+Shift+Point), because neither Ctrl+: nor Ctrl+Shift+. can currently be assigned as shortcuts in the Customize - Keyboard dialog. To enable that, colon key (= Shift+Point on Estonian layout, as on many others) should be defined in cui/source/customize/acccfg.cxx.
(In reply to Buovjaga from comment #7) > (In reply to Mihkel Tõnnov from comment #6) > > Could someone commit the patch? > > I guess so, but as I see you already sent a license statement, you could > also create a patch directly inside gerrit as the change is so simple: > https://wiki.documentfoundation.org/Development/gerrit > https://wiki.documentfoundation.org/Documentation/GerritEditing Oh, cool, I wasn't aware that I can do that :) Thanks!
(In reply to Mihkel Tõnnov from comment #8) > Can't use the same shortcuts as in Excel (Ctrl+Shift+Comma & > Ctrl+Shift+Point), because neither Ctrl+: nor Ctrl+Shift+. can currently be > assigned as shortcuts in the Customize - Keyboard dialog. To enable that, > colon key (= Shift+Point on Estonian layout, as on many others) should be > defined in cui/source/customize/acccfg.cxx. Found that this is true only with the KF5 VCL-plugin: VCL Tools - Customize - Keyboard detects keypress as... kf5 Ctrl+. Ctrl+, Ctrl+Shift+; (nothing) gtk3 Ctrl+. Ctrl+, Ctrl+Shift+; Ctrl+Shift+. gen Ctrl+. Ctrl+comma [sic!] Ctrl+Shift+; Ctrl+Shift+. win Ctrl+. Ctrl+, Ctrl+Shift+, Ctrl+Shift+. Note how Windows detects Ctrl+Shift+Comma while others detect Ctrl+Shift+Semicolon - yet all except KF5 detect Ctrl+Shift+Point. I assume this is caused by colon not being defined as a key in acccfg.cxx. In any case, seems I managed to submit the patch for review: https://gerrit.libreoffice.org/c/core/+/93983
*** This bug has been marked as a duplicate of bug 126085 ***