Fire event after any change in sheet

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
arrowman
Posts: 8
Joined: Mon Nov 21, 2011 12:01 pm

Fire event after any change in sheet

Post by arrowman »

Hello,
I am looking for method how to fire event after change any cell value in sheet. I must avoid to add event listener to every needed cell like in this topic:
viewtopic.php?f=45&t=30071

And it should be work in every sheet.

Is this possible? From lack of info about this I mean that no, but maybe there is any magican o the forum:-)

Thanks,
A.
OpenOffice 3.2.1, Windows XP/Vista
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Fire event after any change in sheet

Post by Zizi64 »

There is a built-in Event. You can find it in the menu: Tools - Customize - Events.
You can assign your macro to the
'Modified' status was changed
event.

You must know how you will use, how you will handle this event.
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.
Post Reply