Insert date shortcut key in Calc


First of all - is there a way to insert only the date without the time by using a shortcut key such as Ctrl+; - which inserts both the date and time.

And secondly - in ODT files the inserted date (Ctrl+;) does not show up immediately in the cell but only after some other action is taken.

OS is Win 7, 64bits. LibO is from

We have the same question.