Place images in a cell programmatically

Issues with installing under all Linux Distributions

Place images in a cell programmatically

Postby hanifa » Tue Aug 02, 2011 8:04 am

Hi, I have a following txt file of this format.

[location of image, values , values ,values ]

i.e /home/user/somefolder/a.jpg 12.0 22 11
/home/user/somefolder/b.jpg 12.0 3411
/home/user/somefolder/c.jpg 12.0 55 44
... upto 100 images even.

I like to create a new excel sheet with this format,

[actual image shown, values, values, values ]

i.e actualImageA 12.0 22 11
actualImageB 12.0 22 11

and so forth.

Does anyone have a script (if I can run from ubuntu terminal,it would be best) or something similar to accomplish this task ?
:)
Thanks all
Open Office 3.2
Ubuntu 10.10
hanifa
 
Posts: 4
Joined: Tue Aug 02, 2011 8:01 am

Re: Place images in a cell programmatically

Postby RoryOF » Tue Aug 02, 2011 8:24 am

Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31209
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Place images in a cell programmatically

Postby hanifa » Tue Aug 02, 2011 9:00 am

hi RoryOF, thanks for the reply.
Two drawbacks for this extension :
Firstly, it doesnt align the pictures into the cell. Thus for multiple cells with url, when the images get downloaded, they are floating over other cells.. the cells dont resize to fit the images.
Secondly, it only works for URL. I put /home/user/a.jpg , but nothing get loaded.

More suggestions, thank again.
Open Office 3.2
Ubuntu 10.10
hanifa
 
Posts: 4
Joined: Tue Aug 02, 2011 8:01 am

Re: Place images in a cell programmatically

Postby Villeroy » Tue Aug 02, 2011 9:42 am

For image manipultaion by script your Linux distribution provides a powerful tool named "display".

OOo comes with a database component which is able to show scaled images in an input form.
Calc (calculator) has never been designed to be an image viewer. Images in spreadsheets are meant to be decoration and illustration.

Download download/file.php?id=8790
Exctract the directory.
Open the database document.
Open the form therein.

There you find a one-line script which updates the picture list which is a plain text file of flat file names.
A database table is linked to the plain text file.
The database table is linked to another database table with related information.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28419
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Linux

Who is online

Users browsing this forum: No registered users and 2 guests