Issue 55116

Summary:	Keyboard shortcut for entering Time or Date
Product:	Calc	Reporter:	jgfuller <jgfuller>
Component:	editing	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	einstienindia, frank, issues
Version:	OOO 2.0 Beta2
Target Milestone:	---
Hardware:	All
OS:	Windows XP
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

Description jgfuller 2005-09-27 04:04:26 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.

Comment 1 einstienindia 2005-09-27 06:55:27 UTC

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

Comment 2 jgfuller 2005-09-29 16:33:21 UTC

When using Excel, data is typoed directly into the cell, if one doesn't use the 
keyboard shortcut.

Comment 3 jgfuller 2005-09-29 16:35:07 UTC

In Excel, there is no menu option to insert time or date, like there is in 
Writer or MS Word.

Comment 4 frank 2005-10-13 11:21:49 UTC

This is a double to Issue 1704

*** This issue has been marked as a duplicate of 1704 ***

Comment 5 frank 2005-10-13 11:22:52 UTC

closed double

Comment 6 jgfuller 2005-10-16 02:07:00 UTC

Thank you 'fst'; I'll watch 1704 for progress.