[Solved] Inserting the current date in Calc.

Discuss the spreadsheet application
Locked
princess
Posts: 4
Joined: Sun Jul 11, 2010 5:39 am

[Solved] Inserting the current date in Calc.

Post by princess »

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
User avatar
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 »

Unfortunately, no.

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
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Inserting the current date in Calc.

Post by RoryOF »

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
User avatar
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 »

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

You can start with a search (click for the results): http://user.services.openoffice.org/en/ ... ++%2Bmacro

Or, check these specific threads for some ideas:
http://user.services.openoffice.org/en/ ... =7&t=21237
http://user.services.openoffice.org/en/ ... =9&t=24923
AOO4/LO5 • Linux • Fedora 23
User avatar
MrProgrammer
Moderator
Posts: 4894
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Inserting the current date in Calc.

Post by MrProgrammer »

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.3, 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 »

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.
While I mostly use the first, the F9 one (second method) is a neat trick! Thanks.
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: Inserting the current date in Calc.

Post by kingfisher »

Just btw I only need to press Enter once.
Apache OpenOffice 4.1.9 on Linux
juanguirao
Posts: 1
Joined: Sun Apr 26, 2015 1:25 pm

Re: Inserting the current date in Calc.

Post by juanguirao »

Hi.
In LibreOffice you can set a custom keyboard shortcut for date insertion: Go to Tools>Customize>Keyboard, and on the bottom search for Insert>Current Date
Juan Guirao
LibreOffice 4.2.1.1
Locked