| View previous topic :: View next topic |
| Author |
Message |
slone
Blue Pill
Joined: Mar 19, 2008
Posts: 3
|
 Posted: Wed Mar 19, 2008 5:31 am Post subject: Missing tools in speadsheet: date, time and paste value |
|
I am missing two shortcuts from excel:
^; for inserting the current date
and
^: for inserting the current time
in Neooffice I could not find any thing similar, not even in the insert menu!
Also in the toolbar I can't find any the the paste value function, I found a a way to bypass this problem, the side menu of the paste icon, but it is not perfect.
The ideal thing would be a shortcut for pasting value.
Otherwise I love Neooffice and do not use Microsoft any more |
|
| Back to top |
|
 |
rays
The Anomaly
(earlier version)
Joined: Sep 23, 2004
Posts: 475
Location: Geneva, Switzerland
|
| Posted: Wed Mar 19, 2008 11:24 am Post subject: |
|
Insert>Function... and Category Date & Time suggests that =Today() will give you current date.
I see that =NOW() will give you current date and time.
As for time on its own... ?
_________________
Ray Saunders
World Scout Bureau |
|
| Back to top |
|
|
Lorinda
Captain Mifune
Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA
|
| Posted: Wed Mar 19, 2008 1:21 pm Post subject: |
|
You can always record a macro inputting these functions and assign shortcuts to them in Tools>Customize...>Keyboard.
Lorinda |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Wed Mar 19, 2008 1:36 pm Post subject: |
|
To get the hour and minutes, enter in the formula bar
| Code: | | =CONCATENATE(HOUR(NOW());":";MINUTE(NOW())) |
Hope that helps
Jacqueline
Edit: you can get the seconds by adding
| Code: | | =CONCATENATE(HOUR(NOW());":";MINUTE(NOW());":";SECOND(NOW))) |
|
|
| Back to top |
|
|
Dragonfly14
Sentinel
Joined: Jun 23, 2006
Posts: 20
Location: Tasmania
|
| Posted: Fri Mar 21, 2008 12:36 am Post subject: |
|
Many thanks @jgd.
I also found that formula useful, 'cept the seconds part was too accurate for my needs!
However, and I don't mean to be picky, shouldn't that be
SECOND(NOW()))
(Extra close bracket at end?)
Hooroo... |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Fri Mar 21, 2008 1:24 am Post subject: |
|
Jacqueline's full code example at the bottom has the right number of )'s - the SECOND(NOW()) example is of the standalone use of the SECOND() function, I believe...
- padmavyuha (streuth - 4 figures!) |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Fri Mar 21, 2008 2:12 am Post subject: |
|
Sorry, in the last line, I forgot an opening bracket. That should be
| Code: | | =CONCATENATE(HOUR(NOW());":";MINUTE(NOW());":";SECOND(NOW())) |
CONCATENATE() two brackets
HOUR(), MINUTE(), and SECOND() two brackets
NOW() two brackets
Sometimes, I'm a bit careless 
Jacqueline |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Fri Mar 21, 2008 3:37 am Post subject: |
|
Well spotted, I missed that one - this reminds me of my days programming in LISP  - we had a great LISP editor that put a pointer over the matching parenthesis when your cursor was on one, so you could see why there should be 7 instead of 6, or whatever...
- padmavyuha |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Fri Mar 21, 2008 6:18 am Post subject: |
|
New feature to be added 
Jacqueline |
|
| Back to top |
|
|
|
