Add new event handler to spreadsheet events (java)

Java, C++, C#, Delphi... - Using the UNO bridges
Post Reply
kde
Posts: 4
Joined: Thu Jun 19, 2008 12:38 pm
Location: Germany

Add new event handler to spreadsheet events (java)

Post by kde »

Hello,

I wish to register event handler for oo spreadsheet. If a customer change a value of any cell / in the input line etc. , the triggered event should invoke my event handler. How can I implement this in Java 1.6/O0 2.4/Ubuntu 8.04?

best regards

Konstantin
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Add new event handler to spreadsheet events (java)

Post by Villeroy »

As far as I know this is impossible or impracticable at least. Are you really shure you want to use a spreadsheet?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
kde
Posts: 4
Joined: Thu Jun 19, 2008 12:38 pm
Location: Germany

Re: Add new event handler to spreadsheet events (java)

Post by kde »

I want to open an ods (OO-Calc) file by my app and execute scripts(event handler) if the user change any cell values in the sheet. How can I do this in java (uno ....)?
OOo 2.4.X on Ubuntu 8.x
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Add new event handler to spreadsheet events (java)

Post by Villeroy »

This is the interface to add/remove a listener: http://api.openoffice.org/docs/common/r ... aster.html
This is the listener-interface to implement: http://api.openoffice.org/docs/common/r ... tener.html
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
kde
Posts: 4
Joined: Thu Jun 19, 2008 12:38 pm
Location: Germany

Re: Add new event handler to spreadsheet events (java)

Post by kde »

How can I get an instance of ModifyBroadcaster?

XModifyBroadcaster broadcaster = (XModifyBroadcaster)UnoRuntime.q....(XModifyBroadcaster.class, ????????)
OOo 2.4.X on Ubuntu 8.x
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Add new event handler to spreadsheet events (java)

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
NelsonRodrigo
Posts: 1
Joined: Tue Feb 10, 2009 12:30 pm

Re: Add new event handler to spreadsheet events (java)

Post by NelsonRodrigo »

Dear Friends
I'm Work with Windows XP and OpenOffice 3.0
when i work with Macro i want to use worksheet change event
so i thing in thins handler i can archive my gole

please describe me how can i add this to widows environment.

if you have any idea regarding my problem well come for any suggestions


Thanks in Advance
OOo 3.0.X on Ms Windows XP
Post Reply