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

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

-- 
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