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
