First time here? Check out the FAQ!
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 |