Re: [libreoffice-users] <solved>how to add RegressionCurves to Chart using BASIC

ok: found it myself
the clue is to add a curve to a dataserie

    oDoc = 
StarDesktop.LoadComponentFromUrl("private:factory/scalc","_default",0,loadArgs())
    oSheet = oDoc.Sheets.getByIndex(0)


     oCharts = osheet.charts
     If IsMissing(ChartNum) Then ChartNum=0
         With oRect
             .X = 0
             .Y = YPos

               .Height=  12000
               .width = 12000/4 * ubound(LabelsArray())
         End With
' Remove the CName
'chart if it exists
     If oSheet.getCharts().hasByName(CName)  Then
        oSheet.getCharts().removeByName(CName)
     endif
    ' Make Chart
     oCharts.addNewByName(CName,oRect,Array(),TRUE, TRUE)
     oChart = oCharts.getByName(CName).embeddedObject
     oChart.diagram = 
oChart.createInstance("com.sun.star.chart.AreaDiagram")
     oDiagram = ochart.getFirstDiagram()
    oCoords = oDiagram.getCoordinateSystems()
    oCoord = oCoords(0)
    oChartTypes = oCoord.getChartTypes()
    oChartType = oChartTypes(0)
    oNewDataSeries = CreateUnoService("com.sun.star.chart2.DataSeries")
    oChartType.addDataSeries(oNewDataSeries)
    oDataSeriesList = oChartType.getDataSeries()
    oMyDataSerie= oDataSeriesList(0)'=' first series
'creating curve
    oMyCurve = 
CreateUnoService("com.sun.star.chart2.PolynomialRegressionCurve")
'add curve to DataSerie
    oMyDataSerie.addregressioncurve(oMycurve)

    oChart.lockControllers()
' Data
     oChart.Data.setData(ChartDataArray())








> I found how to add regression curves using Java, can it  been done 
> using Basic ?
> if found no methods to add first a RegressionCurveContainer
> and to add a RegressionCurve to this container ?
>
> Thanks for any hint
>
>
>
> XDataSeries[] dataSeriesArr = getDataSeries(chartDoc);
>
>     XRegressionCurveContainer rcCon = UnoRuntime.queryInterface( 
> XRegressionCurveContainer.class, dataSeriesArr[0]);
>
>     XRegressionCurve[] curves = rcCon.getRegressionCurves();
>
>     XRegressionCurve curve = 
> Lo.createInstanceMCF(XRegressionCurve.class, 
> "com.sun.star.chart2.LinearRegressionCurve");   // for a linear 
> regression curve
>     rcCon.addRegressionCurve(curve);


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted