We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Reset style when removing hyperlink

When removing hyperlink with this line :

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 !


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.