Is there any way to set up cells so they will automatically insert the current time when you click on them, and you can’t change it?
Ctrl+Comma insert the current data
Ctrl+Shift+Comma inserts the current time.
Your setup may vary. Have a look at Tools>Customize… tab “Keyboard”
1 Like
Yes, but it won’t be possible without resorting to user code…
Yes, but this requires to set the cells of the sheet that shall allow editing to not protected and to protect the sheet.
It was a bit of fun to create a presentable solution though I don’t know a realistic use-case and the used time may be wasted.
(For unknown reasons the solution doesn’t work in AOO.)
See attachment:
disask113478_Deliver DateTime_OnClick.ods (26.9 KB)
(If the body of a post of mine is similar to what I deleted in advance, this should also be detected by the clever discourse software.)
See also tdf#163831