Hi There. I need to draw in runtime some controls on Calc sheet attached to cell. So I need to get x,y position of a cell. Can you help me with advise/example? Maybe there are another ways?
x = some_cell.Position.X
y = some_cell.Position.Y
it seems, youre still NOT able to use (GitHub - hanya/MRI: An object introspection tool for OpenOffice API) ? why ?
Yes, You are right. I installed MRI plugin, but I still can’t undestand how to use it in code in runtime or disign time on win. It would be great if you can provide with working example
in the basic-IDE ( ROFL ) you may click on the MRI-library, and later:
mri some_thing
in python I would suggest:
## initially:
createUnoService = XSCRIPTCONTEXT.getComponentContext().ServiceManager.createInstance
mri = createUnoService( "mytools.Mri")
## and later:
mri.inspect( some_thing )
but, in latter case your IDE will do most Completions|suggestions by itself without the need to invoke mri every time!!
Lifehack.
We can copy the MRILib.Module1.Mri macro to any module in the Standard library from My Macros - then we can call Mri without any additional steps.
1 Like