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
Place images in a cell programmatically
Place images in a cell programmatically
Open Office 3.2
Ubuntu 10.10
Ubuntu 10.10
Re: Place images in a cell programmatically
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Place images in a cell programmatically
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.
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
Ubuntu 10.10
Re: Place images in a cell programmatically
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 http://user.services.openoffice.org/en/ ... hp?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.
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 http://user.services.openoffice.org/en/ ... hp?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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice