Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.