How to insert date in openoffice spreadsheet shortcut

Post by princess » Sun Jul 11, 2010 5:57 am

In Calc, How do I insert the current date in the active cell. In Excel this can be done by clicking the ; + Ctrl key. Can this be done in a similar way in Calc?

I'm still working on this. I may just type in the days date.

Last edited by MrProgrammer on Fri Sep 04, 2020 7:52 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]

OpenOffice 3.2 on Windows XP acknak Moderator Posts: 22756 Joined: Mon Oct 08, 2007 1:25 am Location: USA:NJ:E3

Re: Inserting the current date in Calc.

Post by acknak » Sun Jul 11, 2010 6:25 am

The easiest way to insert the current date is by typing it.

If typing it is a problem, there are macros floating around that can--with some effort--give you a shortcut key for entering the current date.

AOO4/LO5 • Linux • Fedora 23 RoryOF Moderator Posts: 34721 Joined: Sat Jan 31, 2009 9:30 pm Location: Ireland

Re: Inserting the current date in Calc.

Post by RoryOF » Sun Jul 11, 2010 6:41 am

Or checking Insert / Function List displays the list of functions on screen and you can restrict this to various categories of function by the top dropdown selector. Double clicking an item on the list will insert that item into the current cell.

Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS acknak Moderator Posts: 22756 Joined: Mon Oct 08, 2007 1:25 am Location: USA:NJ:E3

Re: Inserting the current date in Calc.

Post by acknak » Sun Jul 11, 2010 4:35 pm

This has come up many times before, and there are many ways to accomplish this--only you can decide which is best for you.

AOO4/LO5 • Linux • Fedora 23 MrProgrammer Moderator Posts: 5036 Joined: Fri Jun 04, 2010 7:57 pm Location: Wisconsin, USA

Re: Inserting the current date in Calc.

Post by MrProgrammer » Mon Jul 12, 2010 12:10 am

On 22 Nov 2009 Villeroy wrote: Easiest: Remember today's day number (22) and type it with "/" appended: Type 22/
Easy: Type =today() F9 Enter Enter

I'd recommend using one of those. On my system, the day number (today is 11) is always visible on the screen, so the first idea works great for me.

Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.7, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).

vasa1 Volunteer Posts: 261 Joined: Sat Dec 26, 2009 1:20 pm Location: Bombay

Re: Inserting the current date in Calc.

Post by vasa1 » Mon Jul 12, 2010 4:48 am

MrProgrammer wrote:

On 22 Nov 2009 Villeroy wrote: Easiest: Remember today's day number (22) and type it with "/" appended: Type 22/
Easy: Type =today() F9 Enter Enter

I'd recommend using one of those. On my system, the day number (today is 11) is always visible on the screen, so the first idea works great for me.