davecyli

Yeah, the VI I'm building is sort of a one-off solution. So it's a little messy but it does the job.

For future viewers of this thread. This is a good resource:

https://fivedots.coe.psu.ac.th/~ad/jlop/#calc

And the author has a chapter on the chart2 api here:

https://fivedots.coe.psu.ac.th/~ad/jlop/chaps/28. Chart2 API Overview.pdf

Thanks again for the prompt responses Gribo, I wouldn't have expected it for a thread from 2015 haha

If i ever clean up my library I'll add some examples to this thread.

Cheers!

David

Hi Gribo,

Thanks for the guidance!

On that website, I followed this example: https://api.libreoffice.org/examples/DevelopersGuide/Charts/CalcHelper.java under the Charts Example section.

They casted a specific XSpreadsheet to a XTableChartsSupplier.class. Then used the getCharts() method to return a collection of charts and then used the addNewByName method to add  a new chart to that collection with the arguments (sChartName, aRect, aAddresses, true, false)

I was able to create the charts and embedded it into the specific spreadsheet but they defaulted to bar charts.

After the charts are created I was planning on formatting them to a different chart type, and also adding titles, axis names etc.. What do you think about this method? Any downsides?

Also let me know if my understanding or terminology is flawed. I haven't programmed in Java in years, and I do not fully understand the API yet.

Thanks!

David

Any tips on what I should research/learn to understand how I can add a chart through LabVIEW?

I was able to get all VIs working in both LV 2015 32bit and LV 2018 64bit using version 6.0 Libreoffice.

I'm at the point of developing the library more but not sure where to start.

Thanks!

David