Visit Jeremy's Blog.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 01-24-2007, 03:02 PM   #1
Registered: Oct 2005
Location: Windsor, Ontario, Canada
Distribution: Fedora Core 5,4,3 & Ubuntu 6.06, 8.10
Posts: 403
Blog Entries: 1

Rep: Reputation: 30
Question Using OpenOffice source to render data for charts into images ?

i am working on a program that would allow me to take an XML file containing an OpenDocument spreadsheet and graph and output the graph directly into an image. i figured using the libraries included in openoffice would make most sense and be time saving as well. does any one have any ideas on OOo source and what i would need to put together such an app ?

Last edited by WhiskeyTangoFoxtrot; 01-24-2007 at 05:19 PM.
Old 01-25-2007, 09:58 AM   #2
LQ Guru
Registered: Aug 2003
Distribution: CentOS, OS X
Posts: 5,131

Rep: Reputation: Disabled
Well one way would be to use the "macros" OO provides (it has a somewhat similar macro system than MS Office has with it's VB code), to automatically open the file, take the chart and produce an image out of it if OO is capable of doing it in the first place. Though this would mean launching the OO app itself, so I'm not sure if you want that.
Old 01-25-2007, 10:19 AM   #3
Registered: Feb 2004
Location: Outside Paris
Distribution: Solaris 11.3, Oracle Linux, Mint
Posts: 9,724

Rep: Reputation: 433Reputation: 433Reputation: 433Reputation: 433Reputation: 433
Have a look there too for embedding in your application:
Old 01-25-2007, 10:57 AM   #4
Registered: Oct 2005
Location: Windsor, Ontario, Canada
Distribution: Fedora Core 5,4,3 & Ubuntu 6.06, 8.10
Posts: 403
Blog Entries: 1

Original Poster
Rep: Reputation: 30 getting a hold of the SDK. going over the developers guide as well, it all looks like greek to me :s

thanks anyways.
Old 01-26-2007, 06:25 AM   #5
Senior Member
Registered: Oct 2003
Location: Bonaire, Leeuwarden
Distribution: Debian /Jessie/Stretch/Sid, Linux Mint DE
Posts: 4,728

Rep: Reputation: 753Reputation: 753Reputation: 753Reputation: 753Reputation: 753Reputation: 753Reputation: 753
Steering someone away from a once chosen direction might not be the smartest thing to do, but anyways...

I have serious problems with openoffice, especially oocalc. Graphing in oocalc is troublesome, and sometimes impossible. (I am preparing another post on that, but I need to document it well)

Secondly I have been using oocalc in command line mode to extract and export data. With each new version (1.1 -> 1.1.3 -> 2.0) it seemed that bugs were introduced which limited the use of oocalc in batch mode. I posted something about this on the

If anything, I would go for GNUPlot. It is easier to learn that oo macro language, and it is 2 orders of magnitude faster.

If you decide to stick with oo, I only can advise to limit yourself to data export as CSV (there is ample documentation around about that on, except that it seems to be broken in oocalc 2.0), use AWK for preprocessing, and use GNUPlot to create the graph.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: The changing face of charts in LXer Syndicated Linux News 0 09-05-2006 08:54 PM
convert OpenOffice Calc charts into postscript fatra2 Linux - Software 2 04-28-2004 10:37 AM
OpenOffice keeps asking for user data jdtiede Linux - Software 2 03-20-2004 02:47 PM
Making charts in OpenOffice Calc leontini Linux - Newbie 2 11-25-2003 10:42 PM
OpenOffice Data Source Informix SteveT Linux - General 1 10-31-2003 04:04 AM > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 12:05 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration