Apache OpenOffice Community Forum

In a calc document I have a merged area (multiple columns and rows) where a picture is to be placed. This picture will need scaling. Therefor I want to find out the size of the merged area.
The scaling (and repositioning, if needed) is to happen in a (basic) macro.
So far I was not able to find a strategy/ example.
Need help.

Select the cells, then:

The recent LibreOffice versions have a built-in feature for resizing the images: "Fit to cell size". It works for me with merged cells too.