[Solved] Secondary axis using java

[jfuster]

Hello,

I´m trying to add a secondary axis in a plot with two numeric series. Im trying to do something like this but it does not work:

Code: Select all

 com.sun.star.chart.XTwoAxisYSupplier secondAxis = multiServiceFactory.createInstance(com.sun.star.chart.XTwoAxisYSupplier.class, "com.sun.star.chart.ChartTwoAxisYSupplier");
 XPropertySet secondAxisProps = secondAxis.getSecondaryYAxis();
    
 if (secondAxisProps!=null) {
    	try {
    		secondAxisProps.setPropertyValue("HasSecondaryYAxis", new Boolean(true));
    		secondAxisProps.setPropertyValue("HasSecondaryYAxisDescription", new Boolean(true));
    	} catch (Exception e) {
    		e.printStackTrace();
        }  
}

I'm getting a nullPointer. What is the right way to do it? Could you please help?

Thanks in advance.

[Zizi64]

Are you using an object inspection tool (XrayTool, MRI) for the programming?

[jfuster]

Thank you Zizi64. I´m calling LO from an external java program: it first load a Calc sheet with data, reads data from two rows, inserts a Chart and saves the Chart in png format. I´m trying to add a secondary Axis to this Chart.
I do not know if XrayTool can work outside a Macro, can it? I found another object inspector "Development Tool" developed by Tomaž Vajngerl but I cannot enable the option menu to run it.

[Zizi64]

I do not know if XrayTool can work outside a Macro or not, but you can list and examine the properties and methods of the programming objects with the Xray inside a LO macro. And them (maybe) you can use the informations outside the macros.

I assume that the functions of the LO API are largely the same when called inside or outside macros.

API: Application Programming Interface.

[Villeroy]

You can instanciate service ""mytools.Mri" and then call method inspect(obj)
In Basic:

Code: Select all

  oMRI = CreateUnoService( "mytools.Mri" )
  oMRI.inspect( MriTargetObject )

This should work with any language with MRI extension installed.

[jfuster]

Thank you Villeroy and Zizi64. MRI has been very helpful to figure out the right interface and property to be set:

Code: Select all

com.sun.star.chart.XTwoAxisYSupplier secondAxis =  UnoRuntime.queryInterface(com.sun.star.chart.XTwoAxisYSupplier.class, xDiagram);
XPropertySet secondAxisProps = secondAxis.getSecondaryYAxis();
secondAxisProps.setPropertyValue("Visible", new Boolean(true));