Excel In-Line images (Place in Cell, not Over cells)

We have a Sales Quotations use case which requires product images to be inserted at the line level of a table. The picture of the product should appear below the corresponding product line, and above the next line.

When using the picture control, the images are overlayed over the following rows, as such:

How can we ensure these images are included "in-line", as they would be when an Excel sheet is manually created by adding images "in cell" instead of "over the cells":

Hello @soneparcanada,

Unfortunately, it seems to be impossible to place the picture in a cell at the moment.

We'll research the request further and probably add some improvements.

Best regards,
Petr
Plumsail team

Hello @soneparcanada,

For now, we recommend using Place over cells option and adjust the placeholder size:

It won't place it in the cell but keep the size within the placeholder in the result.

Best regards,
Petr
Plumsail team

Hello Petr!

Placing over cells in Excel would work for static image placement, but not for images to be included in tables displaying collections, where images are meant to be shown as an attribute of a given collection item (in this case, showing a picture of every part on a quote).

The solution I have found is to use DOCX templates instead, where placing a {{base64image}:picture} inside a DOCX table keeps the image within the bounds of the cell.

This is not ideal, because Excel includes other functionalities and features that Word does not, such as powerful conditional formatting. Basically, I would like the best of the DOCX and XLSX worlds. :slightly_smiling_face:

1 Like