[Solved] Date and Time Stamp when Other Cell is Modified
-
- Posts: 4
- Joined: Tue Jan 30, 2018 2:24 pm
[Solved] Date and Time Stamp when Other Cell is Modified
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!
Last edited by openoffice44 on Tue Jan 30, 2018 8:18 pm, edited 1 time in total.
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Re: Date and Time Stamp when Other Cell is Modified
(free of macros but with iterative calculation mode)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 4
- Joined: Tue Jan 30, 2018 2:24 pm
Re: Date and Time Stamp when Other Cell is Modified
Villeroy, that worked perfectly, thank you!
OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04
Re: [Solved] Date and Time Stamp when Other Cell is Modified
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.
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.
- Attachments
-
- TimeStampsAgain2.ods
- (17.97 KiB) Downloaded 401 times
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
---
Lupp from München
Re: [Solved] Date and Time Stamp when Other Cell is Modified
Clear the cell (backspace key) before you enter a new value.Lupp wrote:How should the last modification update the timestamp in a sheet using the formulae in the above attached demo?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice