aspose file tools*
The moose likes Other Open Source Projects and the fly likes draw combination charts via Openoffice calc programatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "draw combination charts via Openoffice calc programatically" Watch "draw combination charts via Openoffice calc programatically" New topic
Author

draw combination charts via Openoffice calc programatically

Yahya Elyasse
Ranch Hand

Joined: Jul 07, 2005
Posts: 510

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: draw combination charts via Openoffice calc programatically