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 !
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.