Date insertion in Open Office

  anniesboy 12:49 05 Oct 08
Locked

In the past I used Exel I could insert the date by using ctrl + ;

Does anyone know if there is a similar shortcut in Open Office?

  Technotiger 13:03 05 Oct 08

Click on Insert>Fields>Date, I don't think there is a actual short-cut.

  anniesboy 13:37 05 Oct 08

I cant see Fields in Insert, I'm running OO 3.0.0RC3
however it was a shortcut I was hoping/looking for.
Thanks for your reply

  Belatucadrus 14:25 05 Oct 08

To assign a script/function to a key combination
1.Choose Tools - Customize - Keyboard.
2.A list of the functions will appear in the Functions list box. In this case Category "Insert" Function "Time"
3.Select a key combination from the Shortcut keys list box and click "Modify."

Hopefully version 3 works the same.

  Belatucadrus 14:27 05 Oct 08

Or even "insert" function date "Date".

  Technotiger 14:44 05 Oct 08

My suggestion above was assuming you meant the Writer part of Open Office. If you mean the Spreadsheet (Org-Calc) part, then the short-cut to bring up the date/settings is Ctrl/F2

  anniesboy 15:32 05 Oct 08

Thanks I will look at this later ,I'm just off out now

  anniesboy 08:11 06 Oct 08

Belatucadrus,
Well I have tried your suggestion but not succeeded,as in my version there is no "Date" or "Time" in function list.

  Belatucadrus 12:44 06 Oct 08

My bad
I hadn't noticed that the insert list on Calc and Writer were so different, an elementary and stupid mistake on my part, sorry but I have yet to find a way of assigning a date to a key stroke in Calc. I'll get back if I do

  anniesboy 12:48 06 Oct 08

Cheers! I will get back likewise

  Belatucadrus 12:57 06 Oct 08

Can be done with a Macro, but it's a pain in the behind.

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now