Run libreoffice calc macro when a value is added to a column

[jonee]

I have a (scriptforge python) macro that runs when I click a button. But is it possible to make it run when a value is added or appended to a column?

Say A3 to A11 are numbers. When I put a value in A12 I hope to run the macro.

Thanks!

[fpy]

Apache OpenOffice Community Forum - Run a python macro when cell contents change - (View topic)

[jonee]

I have seen that but not quite the same. My events is for adding new data to column. The linked topic is for cell updates. Thanks anyway!

[karolus]

@jonee

I have seen that but not quite the same. My events is for adding new data to column. The linked topic is for cell updates.

Technically its the very same if you update some value or update a (previous empty) cell!

[jonee]

I would need it for the whole column not just an individual cell.

[Wanderer]

Then use a range instead of a cell…
.

How to pass arguments to an event listener in LibreOffice Basic?

[jonee]

Sheet content change actually worked. Then in the event parameter just check the cell address that it is in the same row (0). But unfortunately it freezes and makes libreoffice calc a lot slower so I will just remove it. Thanks!