The keyboard shortcut “CTRL”+";" should insert a date into the cell, but instead it writes the letter “e” with an underscore.
I tried replacing the keyboard shortcut to be something else, like “CTRL”+".", but it functions the same thing, meaning it writes the letter “e” with an underscore.
I will emphasize that the keyboard shortcut for inserting time (i.e. “CTRL”+“SHIFT”+";") works well.
Using Liberoffice Calc v7.3.5.2.
What should I do to solve it?
Thank you.
On macOS, where I have a vanilla install of LibreOffice, the shortcut is ⌘; Control; inserts a ; which is perhaps a little odd.
You can adjust the shortcuts at any time.
Tools → Customize → Keyboard
I changed it like this:
Version: 7.3.5.2 (x86) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win
Locale: en-GB (de_DE); UI: en-US
Calc: threaded
You didn’t say, but I’d bet this is on some Ubuntu. In their endless wisdom they assigned the emoji picker input switch to Ctrl+; which usually is on Ctrl+. (and hence reassigning to that also may not work for you). We can do nothing but congratulate them. Apart from that, you can try to assign the emoji annotation to a different shortcut using the ibus-setup command, tab Emoji, for example <Control>period .