Ask Your Question

rolf's profile - activity

2019-10-30 07:50:05 +0100 received badge  Famous Question (source)
2019-04-04 18:13:13 +0100 edited answer Auto change cell format "on update" event

Thank you very much. The "Sheet Events" with its "Content changed" trigger was what I was looking for (and what I was no

2019-04-03 13:35:22 +0100 commented answer Auto change cell format "on update" event

Thanks Lupp. Got back to it now after having implemented & tested your suggestion with a few minor tweaks. Works gre

2019-04-02 13:09:32 +0100 received badge  Notable Question (source)
2019-03-25 20:36:57 +0100 received badge  Popular Question (source)
2019-03-25 15:14:24 +0100 commented answer Auto change cell format "on update" event

In my case, it's exactly what I want. Background: I'm translating strings from a bunch of them where not every string ac

2019-03-25 12:59:52 +0100 marked best answer Auto change cell format "on update" event

I'm looking for a possibility to have Calc automatically trigger an event or function, like f.e. change a cells format, once the cell content has been updated / edited.

The reason I'm not sticking with the "track changes" function is that I have to later work with the cell contents of those cells that have been edited, and the formatting marks of this function are very limited.

It does not even have to be a change of cell format, it could be sth. like insert a timestamp of the Edit/Update event into a cell after the edited cell in the same row.

I'd be fine with conditional formatting, or macros, only I can't seem to find something like a "onEdit" or "onUpdate" event, which is what I'm basically looking for.

Thanks in advance for any suggestion!

2019-03-25 12:59:52 +0100 received badge  Scholar (source)
2019-03-25 12:59:40 +0100 answered a question Auto change cell format "on update" event

Thank you very much. The "Sheet Events" with its "Content changed" trigger was what I was looking for (and that I was no

2019-03-25 11:45:21 +0100 asked a question Auto change cell format "on update" event

Auto change cell format "on update" event I'm looking for a possibility to have Calc automatically trigger an event or f