Apache OpenOffice Community Forum

My macro does not trigger automatically even though there is Listener

In my file the number of duty days(in cell D15) should not be less than ZERO and hence when it becomes -ve the macro should be triggered and the causing cells ( thee in my case ) is to be made zero


I am using LiberOffice 4.0 under Windows/Ubuntu 10.4

I ran your macro that creates the Listener and then modified one of the input cell for D15 and the macro worked. I do not see any automatic running of the Listener creation when the document is opened, so I think you have to add that. In the menu Tools -> Customize, on the Events tab, you can tie your Main macro to the Open Document event.

Please tell me how,

Ahamed

Go to the menu Tools -> Customize and then select the Events tab. Click on Open Document in the list of events and then click on the Macro button. After a few seconds a Macro Selector dialog will open. Your document should appear in the list of Libraries on the left. Click on its + sign, choose the library and then select the macro that creates the listener from the list on the right. Click Ok to close all the dialogs. Save the document and close it. The next time you open the document the listener should load automatically.

Thank God,

I appreciate the time and effort you, dear friend, made in this regard. I had made a bug report under
https://bugs.freedesktop.org/show_bug.cgi?id=63984
I think this is solved

Ahamed