Draw combination charts via OO calc programatically

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
othmanelmoulat
Posts: 142
Joined: Sun Aug 03, 2008 4:39 am

Draw combination charts via OO calc programatically

Post by othmanelmoulat »

hi all,

we need to develop a project that is an extension in OO so that it could display a mutitype chart we have drawn in Excel.
Essentially, we have a combination chart consists of a candle stick chart and a line chart appearing together. OO could not display it!
(see http://qa.openoffice.org/issues/show_bug.cgi?id=27363).

We have research the problem for a while and figure that the easiest way is to develop an extension in Java using the Netbean Integration tool. Probably, adding a new chart type so that it is matched to the excel version. In chart2, it appears that they have changed the structure to a MVC model and under the diagram service, a coordinate system could have a list of charttype. So it appears that it is possible to draw a chart with different charttype on it even without the extension. However, we have not tried the chart2 API as we can't find a working example and SUN is not very helpful either and they discourage us to use chart2.
(see http://graphics.openoffice.org/chart/ch ... cture.html)

can you give us advise how to approach this problem ?
documentation resources , code snippets to call chart2 api from java code and any other helpful suggestion will be very welcomed.

thanks.
OOo 3.4 and LibreOffice 3.4 on openSuse 11.4 + windows 7
othmanelmoulat
Posts: 142
Joined: Sun Aug 03, 2008 4:39 am

Re: Draw combination charts via OO calc programatically

Post by othmanelmoulat »

ok let me put it simply:
com:sun:star:chart2 is not written in java, it is all written in C++ with those horrible IDL files which I don’t want to know about.
However, i do think UNO make it possible to be used in a java environment.
i searched the OOo website and also the web for an example snippet of a java program that calls com:sun:star:chart2 ; but i didn't found anything.

it would be great if java gurus in this forum show me an example of how to use the OOo chart2 API in a java program.

thanks.
OOo 3.4 and LibreOffice 3.4 on openSuse 11.4 + windows 7
Post Reply