LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices

Reply
 
LinkBack Search this Thread
Old 01-24-2007, 02:02 PM   #1
WhiskeyTangoFoxtrot
Member
 
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 ?


G'day,
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 ?
thanks.

Last edited by WhiskeyTangoFoxtrot; 01-24-2007 at 04:19 PM.
 
Old 01-25-2007, 08:58 AM   #2
b0uncer
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, 09:19 AM   #3
jlliagre
Moderator
 
Registered: Feb 2004
Location: Outside Paris
Distribution: Solaris10, Solaris 11, Mint, OL
Posts: 9,459

Rep: Reputation: 352Reputation: 352Reputation: 352Reputation: 352
Have a look there too for embedding OpenOffice.org in your application: http://api.openoffice.org/Developers...persGuide.html
 
Old 01-25-2007, 09:57 AM   #4
WhiskeyTangoFoxtrot
Member
 
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
ok........im 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, 05:25 AM   #5
jlinkels
Senior Member
 
Registered: Oct 2003
Location: Bonaire
Distribution: Debian Lenny/Squeeze/Wheezy/Sid
Posts: 3,977

Rep: Reputation: 476Reputation: 476Reputation: 476Reputation: 476Reputation: 476
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 oooforum.org:

http://www.oooforum.org/forum/viewto...linkels#202095

http://www.oooforum.org/forum/viewto...linkels#178093

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 ooforum.org, except that it seems to be broken in oocalc 2.0), use AWK for preprocessing, and use GNUPlot to create the graph.
 
  


Reply


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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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


All times are GMT -5. The time now is 01:28 AM.

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