I am writing an application that generates excel worksheets that might contain images in the first column. (Stackoverflow question trying to solve the same issue from that side is here)
Say I have a worksheet that looks like this (with filtering enabled):
Where column A includes crudely drawn images of the numerals "1" and "3".
You can also download example worksheets here: https://github.com/dan-kirberger/poi-excel-image-issue/tree/master/examples if you're up for trusting a stranger's files!
If I choose "Move and size with cells" then try to sort the sheet, the images don't get sorted (though the rest of the data does):
Notice the "1" in the image column no longer matches the "Text" column.
Then the images stick around after the rest of their row's data is hidden.
How would I set up these pictures so both filtering AND sorting get applied to the image column?