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 <[email protected]> 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: [email protected] > 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: [email protected] 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
