Re: [libreoffice-users] hekp - auto-insert date

Den sön 4 jan. 2026 kl 22:42 skrev Wade Smart <wadesmart@gmail.com>:

> I was about to say that is very handy --- but then I noticed that it does
> not
> work for me - and Im on Kubuntu 25.04 Version: 25.8.4.2 (X86_64) /
> LibreOffice.
> I did try CTRL and the large + button on the numeric pad of my keyboard
> but that
> only inserts cells.

On my computer it's Ctrl+↵ (Ctrl+Enter), but I might have defined that
shortcut myself at some point, I don't remember.
But you can assign what ever keyboard shortcut you want to basically
whatever you want in LibreOffice. Have a look at Tools → Customize … →
Keyboard:
First select the keyboard shortcut in ”Shortcut keys”.
Then select Insert in the Category list.
Finally select Insert Current Date in the Function list and click Assign.
You can also save your settings, so you can easily have the same settings
on all your computers.


Kind regards

Johnny Rosenberg



> On Sunday 04 January 2026 03:30:31 PM (-06:00), Michael H wrote:
>
> > There's a predefined shortcut (CTRL+; on linux... it's probably Command+;
> > on Mac)  that enters the date into the currently selected field.
> >
> > You can add a different keystroke if you want in
> >
> > On Sun, Jan 4, 2026 at 10:53 AM Johnny Rosenberg <gurus.knugum@gmail.com
> >
> > wrote:
> >
> > > Den fre 2 jan. 2026 kl 14:39 skrev william <william@techservsys.com>:
> > >
> > > > I have task that involves logging activities into a 2 column
> > > > table: date, activity.  Is there any way that I can automagically
> > > > put the current date into column 1 when I open the row by tabbing
> > > > the last row of the table?
> > > I assume you are using Calc and that you mean that you want the current
> > > date as a fixed date (not =DATE()). In that case, I actually do a
> similar
> > > thing pretty often.
> > > My method is to use a Sheet Event (right click a sheet tab, and there
> it
> > > is) to assign a macro to an event for that sheet only. The macro then
> > > detects which cell was changed and fills the cell on the same row in
> the
> > > Date column with the current date, so when using the sheet, you just
> enter
> > > values in your other column, and after you done that, the current date
> > > appears in the corresponding date cell.
> > > If you don't know how to write the actual macro, maybe I (or someone
> else)
> > > can help.
> > >
> > >
> > > Kind regards
> > >
> > > Johnny Rosenberg
> > >
> > >
> > >
> > >
> > > > Thanks for your time
> > > > --bill
> > > >
> > > >
> > > > --
> > > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > > Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > > Posting guidelines + more:
> > > https://wiki.documentfoundation.org/Netiquette
> > > > List archive: https://listarchives.libreoffice.org/global/users/
> > > > Privacy Policy: https://www.documentfoundation.org/privacy
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > Problems?
> > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> > > List archive: https://listarchives.libreoffice.org/global/users/
> > > Privacy Policy: https://www.documentfoundation.org/privacy
>
> --
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2004
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy