Issue 1704 - add keyboard shortcuts to add the current date and current hour
Summary: add keyboard shortcuts to add the current date and current hour
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 638
Hardware: PC Windows 2000
: P4 Trivial with 27 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
: 14392 55116 77716 98902 114457 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2001-09-21 15:43 UTC by Unknown
Modified: 2013-08-08 10:01 UTC (History)
13 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2001-09-21 15:43:39 UTC
In Excel the Ctrl ; keystroke adds the current date, and the ctrl shift ;
keystroke adds the current time.  I know many users use these functions and will
expect it in any replacement program.  I have found that these keystrokes appear
to be open in the spreadsheet.  Would it be possible to add these functions?
Comment 1 peter.junge 2001-09-24 12:58:56 UTC
Hi Falko,
got a new feature wish for you.
Rgds., Peter
Comment 2 falko.tesch 2001-10-11 08:07:48 UTC
Makes sense to me.
Comment 3 falko.tesch 2003-09-11 16:13:03 UTC
Comment 4 bettina.haberer 2003-12-04 18:42:16 UTC
Summary: Use CTRL + ; for current date and CTRL + SHIFT + ; for
current time. (Aligning to accessibility shortcuts!).
Comment 5 joeyday 2003-12-16 18:44:18 UTC
I work in customer support and I am required to log my calls using an Excel
spreadsheet. I can't really consider switching to OpenOffice at work until date
and time hotkeys are functional.
Comment 6 kami911 2005-10-04 12:30:32 UTC
Are there any way to implement this functionality in 2.0.1?
Comment 7 frank 2005-10-13 11:21:45 UTC
*** Issue 55116 has been marked as a duplicate of this issue. ***
Comment 8 onyma 2007-01-25 19:27:44 UTC
The lack of this feature will also prevent migration of one of my clients to OO
which is disappointing since it's such a small one.  They enter dates and times
constantly and while they could learn new methods, I know this issue would be a
BIG sticking point with the users.
Comment 9 jgfuller 2007-01-25 19:40:21 UTC
Please do keep in mind that there are TWO keyboard shortcuts here, used 
frequently by those who must enter either date or time into a spreadsheet cell:
   Ctrl+Shift+;  enters the current TIME into the active cell
   Ctrl+;        enters the current DATE into the active cell
Comment 10 2007-07-22 08:26:35 UTC
Duplicate issues ?
-> Issue 1704, issue 14392 and issue 77716
Comment 11 pagalmes.lists 2007-07-22 12:32:39 UTC
The keyboard shortcuts in the new Excel:
- "ctrl+:" for the date
- "ctrl+;" for the hour
Comment 12 pagalmes.lists 2007-07-22 12:34:05 UTC
*** Issue 14392 has been marked as a duplicate of this issue. ***
Comment 13 pagalmes.lists 2007-07-22 12:35:17 UTC
*** Issue 77716 has been marked as a duplicate of this issue. ***
Comment 14 onyma 2007-07-24 15:23:28 UTC
Just to ensure everyone is on the same page:

CTRL-Semi-Colon is for the Date
CTRL-Colon is for the Time.

I just noticed a previous post had them backwards.
Comment 15 jgfuller 2007-07-24 18:15:35 UTC
In MS Excel 2003, the keyboard shortcuts are as follows:

To enter the date in a cell, press Ctlr and hold it, then press ;  

To enter the time in a cell, press Ctrl and hold it, and press Shift and hold 
it, then press ;

These are different than the keys suggested below by "pagalmes" and "onyma".  
Have the shortcuts changed in Excel 2007?  That would seem unlikely. 
Comment 16 dgibbens 2008-05-27 14:09:11 UTC
Kind of a deal-breaker if this is what you need. I use control-semicolon in both
spreadsheets and Word, and control-colon in spreadsheets. 
Comment 17 jgfuller 2008-05-27 18:40:39 UTC
I would say that the exact keyboard shortcuts aren't as important as simply
having some kind of shortcut.  The ones listed in my comment of July 24 2007 are
those currently used by Excel.  But if OO needs to use other keys for the
shortcuts, that would be OK.  Having those shortcuts is very handy in Excel, and
would be a benefit also to OO users.
Comment 18 onyma 2008-05-28 20:58:40 UTC
Couple of notes:

jgfuller: We are suggesting the same keystrokes.   CTRL+SHIFT+Semi-colon =
CTRL+Colon on the keyboard since you have to hit SHIFT+Semi-colon to get a Colon :)

Secondly, I agree that just getting this feature in is most important however it
would be nice to see the keystrokes remain the same as MS Office if possible. 
The transition from MSO to OO should be as seamless as possible for the end
users who spend all day working with these tools.  The more OO can ease that
transition by making the interface similar the better.   

Are different keystrokes a deal breaker?  No.  But I also don't think the effort
to keep things as similar as possible is something to be quickly disregarded
either.  If MSO is using these keystrokes for time/date then whatever else OO is
using them for is either a new feature entirely from MSO or those commands are
also similarly displaced from their well known MSO keystrokes.

Just my 2c.  Either/or for my client this is still an annoyance in OO adoption.
Comment 19 jgfuller 2008-05-29 05:56:12 UTC
Dear onyma -- obviously I didn't have enough coffee in me when I made my
comment, about the specific key-strokes!  O my!

But I'm glad to hear that this KB shortcut is on the to-do list - it's very useful!
Comment 20 Regina Henschel 2009-02-05 14:02:47 UTC
*** Issue 98902 has been marked as a duplicate of this issue. ***
Comment 21 krishang 2009-03-06 14:04:10 UTC
Its very much needed to replace the Exel
Comment 22 castolon 2009-05-05 17:06:42 UTC
When I used Quattro Pro simply pressing the space bar 3 times entered the
current date. Surely, a similarly easy method could have been included by now.
Comment 23 bettina.haberer 2010-05-21 14:47:45 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 24 frank 2010-09-12 21:57:36 UTC
*** Issue 114457 has been marked as a duplicate of this issue. ***
Comment 25 camillem 2010-09-13 12:49:34 UTC
Kohei Yoshida has written a patch for that
Comment 26 Christophe Strobbe 2013-08-08 10:01:08 UTC
Kohei Yoshida implemented this in Go-OO and it is now part of LibreOffice Calc (the shortcuts don't do anything in Writer).