Apache OpenOffice (AOO) Bugzilla – Issue 55116
Keyboard shortcut for entering Time or Date
Last modified: 2005-10-16 02:07:00 UTC
This is my first issue entry, so please forgive any errors in procedure or content! I wasn't able to find an entry elsewhere for this particular item. MS Excel has a keyboard shorcut for entering the current time in the active cell: Ctrl+Shift+; [semi-colon]. The shortcut for entering the current date is Ctrl+;. This is a handy feature for those [like me!] who use the spreadsheet for making current time and date entries. I use it in a time sheet for my work.
How do you enter date/time field now ? I cannot see the menu option to enter these values automatically ? In writer there is an option like Insert->fields ->date
When using Excel, data is typoed directly into the cell, if one doesn't use the keyboard shortcut.
In Excel, there is no menu option to insert time or date, like there is in Writer or MS Word.
This is a double to Issue 1704 *** This issue has been marked as a duplicate of 1704 ***
closed double
Thank you 'fst'; I'll watch 1704 for progress.