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