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

Hi :)
WOW!!  Superb! :))  Congrats on figuring that out!

Also many thanks for posting the answer back to the mailing list so that;
1.  other people don't spend time trying to figure it out
2.  if someone has the same problem in the future then they might be able
to find it in the archives, or one of us might remember.

So congrats, many thanks and regards from
Tom :)




On 15 December 2014 at 20:32, Fernand Vanrie <sos@pmgroup.be> wrote:
> 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

-- 
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