Apache OpenOffice (AOO) Bugzilla – Issue 1704
add keyboard shortcuts to add the current date and current hour
Last modified: 2013-08-08 10:01:08 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?
Hi Falko, got a new feature wish for you. Rgds., Peter
Makes sense to me.
Re-assigned
Summary: Use CTRL + ; for current date and CTRL + SHIFT + ; for current time. (Aligning to accessibility shortcuts!).
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.
Are there any way to implement this functionality in 2.0.1?
*** Issue 55116 has been marked as a duplicate of this issue. ***
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.
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
Duplicate issues ? -> Issue 1704, issue 14392 and issue 77716
The keyboard shortcuts in the new Excel: - "ctrl+:" for the date - "ctrl+;" for the hour
*** Issue 14392 has been marked as a duplicate of this issue. ***
*** Issue 77716 has been marked as a duplicate of this issue. ***
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.
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.
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.
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.
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.
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!
*** Issue 98902 has been marked as a duplicate of this issue. ***
Its very much needed to replace the Exel
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.
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
*** Issue 114457 has been marked as a duplicate of this issue. ***
Kohei Yoshida has written a patch for that http://kohei.us/2010/02/16/inserting-current-date-in-one-step/
Kohei Yoshida implemented this in Go-OO and it is now part of LibreOffice Calc (the shortcuts don't do anything in Writer).