CALC: Fit a cell around an inserted picture

users
#1

Hi,

i'm new to LibreOffice and to Calc but i would like to do a list of players with their pics inside.
All pics should have the same size (54px * 54px) and i was wondering if it is possible to just insert an image in a cell and that automatically the cell (so the row) will adjust his height/width to the image ?

thx.

A.

#2

Hi :slight_smile:
This is probably best done by using a database with an external
back-end and with the photos kept in a folder outside of the file.

Another option would be to do it as html instead of even trying to do
this inside an office suite.

However if you don't already know how to set-up something like that
then i would probably use tables in Writer rather than Calc. It's not
clear how many players nor how many columns of data each player needs.

Regards from
Tom :slight_smile:

#3

i'm new to LibreOffice and to Calc but i would like to do a list of players with their pics inside. All pics should have the same size (54px * 54px) and i was wondering if it is possible to just insert an image in a cell and that automatically the cell (so the row) will adjust his height/width to the image ?

Do you mean (as I think you are saying) that all the images *will* have this size and you just need the spreadsheet row heights to adjust to that size? I don't see any obvious way to do this. But if all the images are the same height - so that you need all the row heights to be the same - it is a simple job to set these. Select the relevant rows (use click, Shift+click, and Ctrl+click in the row headers to select a complex range of rows), and go to Format | Row >

Height... (or right-click in a row header | Row Height...) to

select the required height.

But if all you really want is parallel columns of text and images, you should look into using a table in a text (Writer) document instead. You will find it easier to resize columns and rows or to have them resize automatically - even to have the images resized automatically.

I trust this helps.

Brian Barker