Hi - we have an excel file with multiple column and one of these column has multiple hyperlinks. When we use IDataSort to sort on a particular column, it sorts correctly but the hyperlinks remain at their old position, the Text shown on those links do move as expected but the underlining link do not. Same happens if we delete a column, for example if we delete column 2 and there was a link at sheet[3,4], it remains at sheet[3,4] but the text on sheet[3,4] moves to sheet[3,3].
Let us know if this a known bug or am i missing something here.
Thanks