Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Convert ods to image

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> Help!
View previous topic :: View next topic  
Author Message
heiowge
LXF regular


Joined: Wed Feb 27, 2008 8:21 pm
Posts: 1901
Location: Cheshire, UK

PostPosted: Sat Sep 28, 2013 5:01 pm    Post subject: Convert ods to image Reply with quote

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.
Back to top
View user's profile Send private message
Fat_Tuesday



Joined: Mon Oct 09, 2006 1:14 pm
Posts: 89

PostPosted: Sat Sep 28, 2013 7:13 pm    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
guy
LXF regular


Joined: Thu Apr 07, 2005 1:07 pm
Posts: 1070
Location: Worcestershire

PostPosted: Sat Sep 28, 2013 8:32 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
johnhudson
LXF regular


Joined: Wed Aug 03, 2005 2:37 pm
Posts: 870

PostPosted: Sat Sep 28, 2013 10:13 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
heiowge
LXF regular


Joined: Wed Feb 27, 2008 8:21 pm
Posts: 1901
Location: Cheshire, UK

PostPosted: Sat Sep 28, 2013 10:46 pm    Post subject: Reply with quote

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. Sad
_________________
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.
Back to top
View user's profile Send private message
guy
LXF regular


Joined: Thu Apr 07, 2005 1:07 pm
Posts: 1070
Location: Worcestershire

PostPosted: Sun Sep 29, 2013 10:29 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Fat_Tuesday



Joined: Mon Oct 09, 2006 1:14 pm
Posts: 89

PostPosted: Sun Sep 29, 2013 10:51 am    Post subject: Reply with quote

Alternatively is it not possible to redo the spreadsheet in a graphics package?
Back to top
View user's profile Send private message
guy
LXF regular


Joined: Thu Apr 07, 2005 1:07 pm
Posts: 1070
Location: Worcestershire

PostPosted: Sun Sep 29, 2013 11:17 am    Post subject: Reply with quote

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


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
Back to top
View user's profile Send private message
heiowge
LXF regular


Joined: Wed Feb 27, 2008 8:21 pm
Posts: 1901
Location: Cheshire, UK

PostPosted: Sun Sep 29, 2013 5:17 pm    Post subject: Reply with quote

A mate of mine did it with Gimp. My little netbook wasn't powerful enough. Embarassed 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.
Back to top
View user's profile Send private message
heiowge
LXF regular


Joined: Wed Feb 27, 2008 8:21 pm
Posts: 1901
Location: Cheshire, UK

PostPosted: Sun Sep 29, 2013 5:19 pm    Post subject: Reply with quote


_________________
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.
Back to top
View user's profile Send private message
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> Help! All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast