It happens that one of the most useful shortcuts for me, in excel, was the shortcut for the current date, which is CTRL+; (and of course SHIFT+CTRL+; for current time). In Libre Office I can't find this option. Does it exist?
I'm now a Mac user (yay!) and will feel far more comfortable once I've mastered this great software suite on this great machine.
If you're a mac-user, then most shortcuts that would use the control key on other platforms, use the command key on Mac OS X.
So <command>+; should work in calc, at least in English UI.
Note that in some keyboard layouts the semicolon is entered using <shift>+, - that means that the keys you would have to press are <command>+<shift>+,
Also note that in that case you will not be able to enter the current date, as you have to press shift, and that then switches the shortcut to insert it as time. (<ctrl>+<shift>)+; is indistinguishable from <ctrl>+(<shift>+,)
If you want it to display the date instead, you have to format the cell to display the date instead. Or assign a different shortcut to the insert date function.
Here is how to set it correctly if your keyboard has ";" over "," on the same key (like german one). There is no <ctrl>+, combination; however there is <ctrl>+comma combination which in fact the same. Set <ctrl>+comma to insert current date and <ctrl>+<shift>+; to set current time and it will work as expected (at least on Linux it works). Probably it should be <command>+comma on MAC.
Libre Office for mac will not accept ';' and ',' for keyboard shortcut
Asked: 2012-09-12 10:13:22 +0100
Seen: 33,355 times
Last updated: Oct 17 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Thank you both.
I've tried to assign a shortcut key for <ctrl>+; but there are no <ctrl> shortcuts in the list and, as yet, I don't know how to add them. The obvious thing would be to use <cmd>+; but that one doesn't appear either! I may just edit an existing valid combination. Or read the Help... :)