Hello
I wanted to create a function or a macro that whenever I modify a certain cell with a certain content it marks the date of today without coming back to update unless I change the contents of the cell again.
Can someone help me?
Input today date if change
Input today date if change
OpenOffice 4.1.3 on Windows
Re: INPUT TODAY DATE IF CHANGE
You can use a form control element for the value modification. In this case you can assign your timeStamp macro to the "click on" event of the form control element. Or you can create a listener (changed event) for the cell. Search the word "Listener" in the macro forum.
Note:
A click on the form control element not will always mean : "The cell content is changed", as the manual input (typing some data into a cell) not always mean : "The cell content is changed", because you maybe typed in same value as the cell was contained. But the event will activated, when you edit a cell. My opinion you need store the previous content of the examined cell (into a global macro variable) for the exact detecting of the change.
Note:
A click on the form control element not will always mean : "The cell content is changed", as the manual input (typing some data into a cell) not always mean : "The cell content is changed", because you maybe typed in same value as the cell was contained. But the event will activated, when you edit a cell. My opinion you need store the previous content of the examined cell (into a global macro variable) for the exact detecting of the change.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: INPUT TODAY DATE IF CHANGE
Let me demonstrate what exactly I try to do.
Whenever in the "ESTATE" column I change the state of each cell, in the "DATE" column will appear the date when the change was made.
Whenever in the "ESTATE" column I change the state of each cell, in the "DATE" column will appear the date when the change was made.
- Attachments
-
- EXAMPLE.ods
- (9.47 KiB) Downloaded 224 times
OpenOffice 4.1.3 on Windows
Re: Input today date if change
menu:Tools>Options...OOoCalc>Calculate: Enable iteration with 1 step
Code: Select all
=IF(A1="";"";IF(B1="";NOW();B1))
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
Re: Input today date if change
Listener example:
viewtopic.php?f=20&t=30516
viewtopic.php?f=20&t=30516
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Input today date if change
A simple example with Combobox and macro:
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Input today date if change
Modified example. The scope of the macro is limited to the cells have custom cell style, named "InputCells".
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.