Hi.
I have been trying to insert the current date and the current time into two adjacent cells.
The keys CTRL + ; inserts the current date. This works fine.
The keys SHIFT + CTRL + ; should insert the current time, but this does not work. It does not insert anything.
Looking under Tools > Customise > Keyboard seems to confirm that those keys should insert it, but they don’t. Is there something obvious that I’m missing ?
How old is your Version of LibreOffice?
Version: 5.4.7.2
Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 8; BS: Windows 6.2; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc: group
Version: 25.2.7.2 (x86) / LibreOffice Community
Build ID: 5cbfd1ab6520636bb5f7b99185aa69bd7456825d
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26200); UI render: Skia/Vulkan; VCL: win
Locale: en-CA (de_DE); UI: en-US
Calc: threaded
1 Like
Build ID: 580(Build:2)
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: x11
Locale: en-AU (wbp_AU.UTF-8); UI: en-US
SlackBuild for 25.8.3 by Eric Hameleers
Calc: threaded
Ctrl+; works as expected and inserts date; Ctrl+Shift+; has no effect. Both are defined in keyboard shortcuts.
Both shortcuts works on:
Version: 25.2.3.2 (AARCH64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Debian package version: 4:25.2.3-2+deb13u2
Calc: threaded
#and
Version: 25.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
# and
Version: 25.8.3.2 (AARCH64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
additional: none of them does work with ctrl; for date, in case the GUI is switched to en-US !!
@all: some weird sideeffects with GUI-locale != OS-locale ??
Thanks PKG.
Never realised it was actually on the menu !
Not quite as quick as using CTRL + SHIFT + ; but still easier than typing it in.
Still doesn’t explain why the shortcut does not work even though the shortcut is actually shown on the menu.
Edited to add:
LO Version 24.2.7.2 (X86_64) on Linux Mint 22.2 Cinnamon
On UK / US keyboards rhe semicolon is the base character of a key. Shift+; is then the colon (:).
With German layout Shift+, (shift comma) is the semicolon and a Shift+; (shift semicolon) simply doesn’t exist.
LibreOffice obviously doesn’t (cannot?) check the keyboard layout, but assumes it is the default layout used for the chosen UI-language. That’s an “eternal bug”, but I didn’t ever report it.
You may do.
This should also be the background for the accepted solution (referring to a German-style keyboard).
I prefer to look for the shortcut settings, and to change them where needed.
(My current version is 25.8.2; German keyboard, UI: En(UK) locale: En (Canada). )
Not exactly … only a simple workaround via Menu, respectivly alterantive shortcut Alt E e
however, LO should not »lie« about the real shortcut wich is of course ctrl , … and should also be able to »know« the actual keyboard-layout (which can be switched on the fly on OS-level) … should show expected behaviour on the key-codes send by underlying OS!