Ask Your Question
5

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

asked 2012-02-18 17:25:00 +0200

Alaukik gravatar image

updated 2012-02-19 10:24:53 +0200

cloph gravatar image

I want to print some charts from LibreOffice Calc, is there a way to do this?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-15 07:28:06.790114

Comments

Here is the issue on Bugzilla: https://bugs.freedesktop.org/show_bug.cgi?id=3 You can say that you are affected by this to try and push it to be fixed in the next release.

And here is a similar question in Ask LibreOffice: http://ask.libreoffice.org/question/2142/save-a-chartgraph-as-image-in-calc/

chtfn gravatar imagechtfn ( 2012-08-09 07:08:17 +0200 )edit

The bug id=3 shows something completely different.

horst gravatar imagehorst ( 2012-08-27 00:10:07 +0200 )edit

Sorry, the right link is: https://bugs.freedesktop.org/show_bug.cgi?id=30944 The fix is said to be targeted for LO 3.7, which should be out in February 2013. Thanks for pointing this out! :)

chtfn gravatar imagechtfn ( 2012-10-31 06:27:04 +0200 )edit

LO3.7 was renamed to LO 4.0. There you can right-click on chart and export graphic to many formats.

horst gravatar imagehorst ( 2013-02-18 00:55:44 +0200 )edit

8 Answers

Sort by » oldest newest most voted
1

answered 2012-02-18 17:52:23 +0200

Pedro gravatar image

Using Calc you have only two options:

1) Select the chart, Copy and Paste to an image program (lousy quality)

or

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.

edit flag offensive delete link more
5

answered 2013-11-29 12:13:17 +0200

PhoneixS gravatar image

With LibreOffice 4.0 and up (4.1) introduced a new option to save only the chart. You need to simply right click it and choose "Export as graphic".

Note that 4.0 version have a bug that prevent you from save it as svg image, this was fixed in LibreOffice 4.1.

edit flag offensive delete link more

Comments

This is the best answer, but I'd add that the chart must not be selected for the 'export as...' option to come up when you right-click.

Tony Locke gravatar imageTony Locke ( 2014-09-01 22:22:51 +0200 )edit

I found the quality of the chart line poor with this approach and needed to use the PDF export to get full quality.

Hojju gravatar imageHojju ( 2014-10-13 13:47:52 +0200 )edit
2

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

Pedro gravatar image

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

edit flag offensive delete link more

Comments

copy, paste to draw, right-click → save as image (maybe paste special and explicitly select GDI Metafile) However as the question was about printing: Those images have display resolution (dpi), so not really suitable for printing. If you want to print, just export as PDF and print the PDF.

cloph gravatar imagecloph ( 2012-02-19 11:52:42 +0200 )edit

Now in LibreOffice you can save a chart as svg, png, jpg, etc. You can update your answer ;)

PhoneixS gravatar imagePhoneixS ( 2013-11-29 11:37:53 +0200 )edit
1

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

LiboV gravatar image

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.

edit flag offensive delete link more
1

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

Marce gravatar image

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

edit flag offensive delete link more
0

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

chtfn gravatar image

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!

edit flag offensive delete link more
0

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

bToasters gravatar image

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.

edit flag offensive delete link more
0

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

kayn gravatar image

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

edit flag offensive delete link more

Question Tools

2 followers

Stats

Asked: 2012-02-18 17:25:00 +0200

Seen: 60,718 times

Last updated: Nov 29 '13