[Solved] Date and Time Stamp when Other Cell is Modified

[openoffice44]

I am trying unsuccessfully to convert my Microsoft Excel Macro to work with the Open Office Spreadsheet, I have looked up similar questions but have not found help yet. What I currently have is a spreadsheet that has 12 columns of 400 rows that data will be entered into. In the columns further to the right I have, for each column of data, a column with a date stamp and a column with a time stamp. As soon as one of the data columns is modified, the date and time columns automatically record the date (MM/DD/YYYY) and time (HH/MM/SS). I need this to function in the same way in Open Office but I am not sure what the code should be. I am attaching screenshots of the code and the output in Excel. For the code, the part shown is repeated for each column of data. Thank you for any help or suggestions you have!

[Villeroy]

timestamps.ods

(13.2 KiB) Downloaded 642 times

(free of macros but with iterative calculation mode)

[openoffice44]

Villeroy, that worked perfectly, thank you!

[Lupp]

Hmmm.
How should the last modification update the timestamp in a sheet using the formulae in the above attached demo?

I modified an old example slightly to also get timestamps for modifications. See attachment.

As already said more than once I judge methods using conditionally suspended circular references for such a task very fragile and wouldn't recommend them.

Basically spreadsheets aren't history aware. If someone urgently needs to implement timestamps I would advise to resort to user code activated by the sheet event 'Content Changed'. There's to regard a lot again, however, If a reliable solution is needed.

[Villeroy]

How should the last modification update the timestamp in a sheet using the formulae in the above attached demo?

Clear the cell (backspace key) before you enter a new value.