Convert ods to image

The place to post if you need help or advice

Moderators: ChrisThornett, LXF moderators

Convert ods to image

Postby heiowge » Sat Sep 28, 2013 4:01 pm

I've created a document (Spreadsheet, to be precise). It was never intended to be a spreadsheet though. I want to convert it to an image that I can edit.

It will export to pdf, but spreads it over 6 pages! I can print screen, but I have to make it so small that I lose 90% of what I want to keep.

Any ideas?
i5 4440 3.1Ghz, Asus H87M-E motherboard, 8GB DDR3, 2GB DDR5 nVidia card, 2x500GB Seagate hd, Coolermaster 750W PSU running Mint 16 MATE and Win7

eeepc 1015PX, 1.66 Ghz Intel atom processor, 2 GB DDR3, 320 GB hd, Mint 14 MATE. Fan needs fixing.
User avatar
heiowge
LXF regular
 
Posts: 1905
Joined: Wed Feb 27, 2008 8:21 pm
Location: Cheshire, UK

Postby Fat_Tuesday » Sat Sep 28, 2013 6:13 pm

Can you paste it into a really big powerpoint slide or similar? You can then use the inbuilt tools to customise. Or certainly with ppt you can save the slide as an image (never tried with libre office et al).
Fat_Tuesday
 
Posts: 97
Joined: Mon Oct 09, 2006 12:14 pm

Postby guy » Sat Sep 28, 2013 7:32 pm

If you import the pdfs one by one into an Inkscape drawing, you can then edit them and rebuild your desired output.
Cheers,
Guy
The eternal help vampire
User avatar
guy
LXF regular
 
Posts: 1078
Joined: Thu Apr 07, 2005 12:07 pm
Location: Worcestershire

Postby johnhudson » Sat Sep 28, 2013 9:13 pm

It depends on what you mean by edit but, if you save the spreadsheet as CSV and then import it into LyX, you can adjust the columns and rows and manipulate the contents in a variety of ways, export the result as a PDF and use ImageMagick to create whatever image format you want.
johnhudson
LXF regular
 
Posts: 876
Joined: Wed Aug 03, 2005 1:37 pm

Postby heiowge » Sat Sep 28, 2013 9:46 pm

Thanks guys. Here are the results so far...

I've tried to copy to LO Impress, and LO Drawing. Impress crashed. Drawing froze for an eternity before copying over. I managed to save as a png, but lost so much quality it was unworkable.

I have converted to pdf, but it's on 3 pages. I've not lost quality, but am struggling to do much with it.

I am doing all this on the low powered netbook mentioned in my signature. My main PC with all the power and screen space is out of action atm. I need to try inkscape but haven't played with it in years.

Any help with any of it would be appreciated. :(
i5 4440 3.1Ghz, Asus H87M-E motherboard, 8GB DDR3, 2GB DDR5 nVidia card, 2x500GB Seagate hd, Coolermaster 750W PSU running Mint 16 MATE and Win7

eeepc 1015PX, 1.66 Ghz Intel atom processor, 2 GB DDR3, 320 GB hd, Mint 14 MATE. Fan needs fixing.
User avatar
heiowge
LXF regular
 
Posts: 1905
Joined: Wed Feb 27, 2008 8:21 pm
Location: Cheshire, UK

Postby guy » Sun Sep 29, 2013 9:29 am

Another way to get your spreadsheet into a graphic editor is to use copy-paste, at least it works in "a well-known office suite" (ISTR I had to take an intermediate paste-recopy step via the presentation app well known in large organizations for its use as a murder weapon). If you have lots of graphic-y bits, each is attached to a cell. Copy the cell and you copy the associated graphics.

But be warned this can give pretty haphazard results. For example the clipboard may not hold much more than a pdf page's worth of stuff so you may gain little, where a line crosses many cells you can find different segments attached to different cells and it all needs realigning, or if you have carefully set different cell sizes the may get mangled, shifting bits of graphic around.
Cheers,
Guy
The eternal help vampire
User avatar
guy
LXF regular
 
Posts: 1078
Joined: Thu Apr 07, 2005 12:07 pm
Location: Worcestershire

Postby Fat_Tuesday » Sun Sep 29, 2013 9:51 am

Alternatively is it not possible to redo the spreadsheet in a graphics package?
Fat_Tuesday
 
Posts: 97
Joined: Mon Oct 09, 2006 12:14 pm

Postby guy » Sun Sep 29, 2013 10:17 am

heiowge wrote:Thanks guys. Here are the results so far...

I've tried to copy to LO Impress, and LO Drawing. Impress crashed. Drawing froze for an eternity before copying over. I managed to save as a png, but lost so much quality it was unworkable.

I have converted to pdf, but it's on 3 pages. I've not lost quality, but am struggling to do much with it.

I am doing all this on the low powered netbook mentioned in my signature. My main PC with all the power and screen space is out of action atm. I need to try inkscape but haven't played with it in years.

Any help with any of it would be appreciated. :(


Yes, do try Inkscape. You can import each pdf in turn into the same drawing and position them all, then "ungroup" each pdf (select it then CTRL-U) to edit the individual objects.

Resize the drawing page using the File > Document Properties dialog. If you select all objects (CTRL-A) before opening the dialog, then in the dialog you can just click "Fit to selection".

Drop me a line if you need more help with Inkscape.
Cheers,
Guy
The eternal help vampire
User avatar
guy
LXF regular
 
Posts: 1078
Joined: Thu Apr 07, 2005 12:07 pm
Location: Worcestershire

Postby heiowge » Sun Sep 29, 2013 4:17 pm

A mate of mine did it with Gimp. My little netbook wasn't powerful enough. :oops: I'll up a copy in a mo,....
i5 4440 3.1Ghz, Asus H87M-E motherboard, 8GB DDR3, 2GB DDR5 nVidia card, 2x500GB Seagate hd, Coolermaster 750W PSU running Mint 16 MATE and Win7

eeepc 1015PX, 1.66 Ghz Intel atom processor, 2 GB DDR3, 320 GB hd, Mint 14 MATE. Fan needs fixing.
User avatar
heiowge
LXF regular
 
Posts: 1905
Joined: Wed Feb 27, 2008 8:21 pm
Location: Cheshire, UK

Postby heiowge » Sun Sep 29, 2013 4:19 pm

Image
i5 4440 3.1Ghz, Asus H87M-E motherboard, 8GB DDR3, 2GB DDR5 nVidia card, 2x500GB Seagate hd, Coolermaster 750W PSU running Mint 16 MATE and Win7

eeepc 1015PX, 1.66 Ghz Intel atom processor, 2 GB DDR3, 320 GB hd, Mint 14 MATE. Fan needs fixing.
User avatar
heiowge
LXF regular
 
Posts: 1905
Joined: Wed Feb 27, 2008 8:21 pm
Location: Cheshire, UK


Return to Help!

Who is online

Users browsing this forum: No registered users and 2 guests