Image size propertys

[lelehier]

Hi wonderful people!
In advance, I'm not super familiar with the spreadsheet vocabulary, so this could also just be an issue that can be resolved by finding the right term.
We would like to change the property of images created by umya to "Move and size with cells" from the default value "Move but don't size with cells."
I searched on docs.rs for anything related in the picture struct but sadly could not find anything that seems to fit my needs.
The intended purpose is that a user can delete a row in Excel and the complete row, including the picture, should be removed.

Am I looking in the wrong place for the solution, or does this need to be implemented first?
Thank you for any help!

[MathNya]

@lelehier
Thank you for contacting us.
As things stand, it seems quite difficult to implement this in Umya-spreadsheet.
Please change the parent structure of the picture structure from OneCellAnchor to TwoCellAnchor.

[schungx]

I have written something exactly like that, which is to detect which images are contained inside a row/column and remove them when said row/column is deleted.

However you have to consider this question: what would you count as an image being inside a row/column?

The top left corner? All four corners? What about an image larger than the row covering all of the row?

For example, you can have an image that is slightly larger than a cell, so it covers the entire cell 100% but all four corners reside outside that cell (very close). In most situations the you would consider the image to be within the cell, but none of its corners are inside that cell. You have to think of how you'd handle this. Such as, delete it if over 90% of the image is inside the row/column.

Another example, what if there is an image so big that it straddles multiple rows/columns? I suppose you'd not want to delete it when only one of the rows/columns is deleted. Would you adjust the width/height? Or would you push the lower right corner downwards, maintaining aspect ratio?

For me, this has been the tricky one. I can share my code to you if you want.