Free Support Forum - aspose.com

Reset style when removing hyperlink


#1

Hello,
When removing hyperlink with this line :
workbook.Worksheets(worksheetIndex).Hyperlinks().RemoveAt(index)

the cell format is reset.

I saw that an issue has been opened : CELLSNET-42179
but I don’t see any update or anyting related to that point.

I would like to just delete the link from the cells and keep the format.
Thanks !


#2

@julien.mevel.isilog,

Thanks for your query.

Actually it was not a bug. We have looked into the issue already and found that MS-Excel also removes or resets the formattings when you delete the Hyperlink using MS-Excel. So Aspose.Cells behaves same as MS-Excel. A workaround can be, use GetStyle() on the affected cell(s) to retrieve the cell’s formatting, then apply SetStyle() after deleting the hyperlink.

Hope, this helps a bit.