Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

On 07/28/2013 05:26 PM, Jim Byrnes wrote:
Hi Fernand,

Your reply went straight to my email inbox so I a reposting it here to keep the thread alive.

Is there a concise list or table that shows what listeners are available
to use in a calc sheet? Or maybe a way to generate one?

Thanks,  Jim

 Jim ,

i hope you know how to use xray , who can tell you what listeners are available for a sheet, and once you createted the listener, what methods are available.

I installed xray and it is working but I am not seeing the output I expected. Either I am not using it correctly or my expectations are wrong. I have tried running it manually and from a macro. The code below is an example of a listener I found on the web.

Sub Main
rem added by me
xray thisComponent

End Sub

global Calc1 as Object
global oListner as Object
Sub AddListners
   Calc1 = thisComponent.sheets(0).GetCellRangeByName("A2:Z20")
oListner = CreateUnoListener( "Sheet1_", "" )
End Sub

Sub Sheet1_Modified(oEvent)
dim ocell,osheet
on error resume next
oCell = thisComponent.currentSelection
 IF oCell.string="ok" then
    msgbox oCell.string
  end if
End Sub

Sub Sheet1_Disposing()
End Sub

Here is some output from xray:

   _ Events watched by this Listener _


_ Methods using this Listener as a parameter _ ( nothing to display )

Shouldn't something be displayed?

Regards,  Jim

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.