Deletion of rows behavior with pictures

[pedgaard]

Hi,

I have a request that SpireXLS should also delete images when deleting the rows wherein the images are located.

Currently, when spire deletes rows, it does not delete the images found in the row range - which Excel would do if selected.

eg. if i use the following example where images are in row 120-130, they are not deleted.
lWorkSheet.DeleteRow(100,200);

[Simon.yang]

Hello povl,

Thanks for you inquire.
I am afraid that WorSheet.DeleteRow(int index,int count) does not delete the images from the worksheet. This functionality of deleting rows is same as MS Excel, if you delete the rows in MS Excel with Images, it will not delete the images either. But you can use WorkSheet.Pictures[int index].Remove() to delete the image you want.

Thanks,
Simon
E-iceblue support team

[Simon.yang]

Hi Povl,

How is it going? Did my advice work? Please give us some feedback at your convenience.
Any queries, please don't hesitate to contact us.

Thanks,
Simon
E-iceblue support team

[pedgaard]

Hi Simon,

Very busy at the moment, so sorry for late feedback. Excel has a behavior that does in deed delete pictures within a range of rows, if the pictures has been set to in their properties - the setting relating to "not move with cells". Can you confirm this?

[Simon.yang]

Hello Povel,

I have confirmed that the Spire.Xls could delete images when deleting the rows by using WorSheet.DeleteRow(int index,int count) method if the pictures properties has been set as "move with cells" .
If there are questions, please contact us.

Thanks,
Simon
E-iceblue support team