How do I export a chart in an image format from LibreOffice Calc?

answered 2012-02-19 11:49:25 +0200

Pedro
3303 ● 4 ● 25 ● 55

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 ;)

answered 2012-02-19 06:41:05 +0200

LiboV
151 ● 5
http://lo-portal.us/libo

updated 2012-02-19 06:42:47 +0200

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.

answered 2012-12-30 00:48:46 +0200

Marce
11 ● 1 ● 2

updated 2012-12-30 01:01:03 +0200

I would like to expand LiboV's answer a little:

1. In Calc, left-click once on the chart to select it.
2. Right-click and select "Position and Size..."
3. Write down the values of Width and Height for the chart.
4. Open a new drawing in Draw (from Calc select File > New > Drawing).
5. In Draw, select Format > Page..., and set all margins to zero. Then, in the Paper Format section, select "user" as Format, and set the page Width and Height to the values of the chart.
6. Go to the Calc window, select the chart and copy it.
7. Go back to the Draw window and paste the chart. It should occupy the whole page.
8. Now you can export the drawing (File > Export...) to several different formats. You can even choose a vector format if that is the best option for later use.

Note: I haven't tried all the export formats, but in my tests this worked well with PNG (bitmap) and SVG (vector).

answered 2012-02-19 04:29:45 +0200

bToasters
16 ● 2

updated 2012-02-19 04:30:20 +0200

Drawing off of Pedro's answer: If you go the copy-and-paste route, do the following steps.

1. Generate your chart
2. Make it as big as you can fit it on your screen.
3. Right Click -> Copy
4. Open up Paint/GIMP/etc and paste it in.
5. Resize it as you need, and save it as a PNG file in there.

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.

answered 2013-04-09 15:00:14 +0200

kayn
1

Easy way is to use Print Screen ;-) and e.g. http://pixlr.com/editor/ as a editor

answered 2012-10-31 06:32:04 +0200

UbuntuBrisbane
123 ● 2 ● 3 ● 13
http://ubuntubrisbane.wor...

updated 2012-10-31 06:36:44 +0200

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!