Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Missing tools in speadsheet: date, time and paste value
Missing tools in speadsheet: date, time and paste value
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
slone
Blue Pill


Joined: Mar 19, 2008
Posts: 3

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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:
SECOND(NOW())



Code:
=CONCATENATE(HOUR(NOW());":";MINUTE(NOW());":";SECOND(NOW)))
Back to top
Dragonfly14
Sentinel


Joined: Jun 23, 2006
Posts: 20
Location: Tasmania

PostPosted: 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

PostPosted: 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

PostPosted: 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 Sad
Jacqueline
Back to top
yoxi
Cipher


Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon

PostPosted: Fri Mar 21, 2008 3:37 am    Post subject:

Well spotted, I missed that one - this reminds me of my days programming in LISP Confused - 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

PostPosted: Fri Mar 21, 2008 6:18 am    Post subject:

New feature to be added Wink

Jacqueline
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.