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.
[Solved] Inserting the current date in Calc.
[Solved] Inserting the current date in Calc.
Last edited by MrProgrammer on Fri Sep 04, 2020 7:52 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
OpenOffice 3.2 on Windows XP
Re: Inserting the current date in Calc.
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.
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
Re: Inserting the current date in Calc.
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
Re: Inserting the current date in Calc.
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
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
- MrProgrammer
- Moderator
- Posts: 4945
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Inserting the current date in Calc.
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.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
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).
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).
Re: Inserting the current date in Calc.
While I mostly use the first, the F9 one (second method) is a neat trick! Thanks.MrProgrammer wrote: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.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
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
- kingfisher
- Volunteer
- Posts: 2123
- Joined: Tue Nov 20, 2007 10:53 am
Re: Inserting the current date in Calc.
Just btw I only need to press Enter once.
Apache OpenOffice 4.1.9 on Linux
-
- Posts: 1
- Joined: Sun Apr 26, 2015 1:25 pm
Re: Inserting the current date in Calc.
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
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
LibreOffice 4.2.1.1