First time here? Check out the FAQ!
answered 2012-02-18 17:52:23 +0200Pedro
Using Calc you have only two options:
1) Select the chart, Copy and Paste to an image program (lousy quality)
2) Select the chart, Export as PDF, Selection, Lossless compression. Then from your PDF reader (I use PDF Xchange Viewer under Windows x86) export to PNG or whatever you prefer.
answered 2012-02-19 11:49:25 +0200Pedro
A correction to bToasters answer: you don't need to buy anything to get your charts in SVG (or even PNG, TIFF, etc). Just open your ODS file in Gnumeric, click on the Chart and Save as Image.
I hope one day LibreOffice will have this feature as well ;)
I get the best quality using these steps: Select your chart in Calc - copy it Open (switch) to a Draw file - paste Size the page appropriately - or - size the page for the graphic you want prior to pasting the chart and zoom the chart to fit:)
I also recommend the following extension - Export As Images -- Export all the Impress slides or Draw pages as images of JPG, PNG, GIF, BMP and TIFF format.
I would like to expand LiboV's answer a little:
Note: I haven't tried all the export formats, but in my tests this worked well with PNG (bitmap) and SVG (vector).
Drawing off of Pedro's answer: If you go the copy-and-paste route, do the following steps.
If you make it really big first, LO will copy as much of the data as it possibly can. This will result in a better looking image. Unfortunately, from what I can tell, LO doesn't have an "export graph" feature yet.
If you need a super high-quality SVG-type graph of your data, maybe look into Wolfram|Alpha Pro. I believe it costs $3/month (for students), but you can plug your data into it, and it'll let you download a very high-quality chart of your data. This would only be for professional needs, however; a copy-and-paste export like Pedro outlined above would suffice for most usage.
Just a little contribution:
While waiting for a fix, I found that the best way to do this for me (in order to use Calc charts in other documents) was to install a good screenshot app (Shutter is by far the best for Linux) that lets you select a part of the screen.
I then "Page Preview" my spreadsheet in Calc, select "Selection" in Shutter, and select the chart I want. It is directly added to the clipboard, which makes it easy to add in another document, or save in a folder.
Hope this helps!
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-18 17:25:00 +0200
Seen: 8,978 times
Last updated: Apr 09