Sorting does not handle comments

[Pistoolirapu]

Hello,

It seems that sorting Excel data with sorting feature in XlsIo does not take comments with the sorted cells. Comments leave into the original location even the main cell data is moved correctly. Very strange.

Anyone else noticed the same?

Comments added like this:

 var comment = cell.AddComment();

comment.Text = downloadCountResult.Comment;

Sorting done like this:

IDataSort sorter = workbook.CreateDataSorter();

sorter.SortRange = sheet.UsedRange;

ISortField sortField = sorter.SortFields.Add(1, SortOn.Values, OrderBy.Descending);

sorter.Sort();

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Juha, 

Greetings from Syncfusion. 

We are able to reproduce the reported issue at our end and validating it currently. We will share the validation details on December 15^th,2021. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Juha, 

We appreciate your patience. 

As of now we do not have support for sorting the comments along with cells and logged feature report. But we do not have any immediate plans to implement this feature in near future. You can track the status of feature report through following feedback link. 

https://www.syncfusion.com/feedback/31183/support-for-sorting-cell-data-with-comments  

Regards, 

Keerthi. 

[Pistoolirapu]

Hello,

Thank you for the answer. For me, the sorting feature is therefore limb when using comments. Hope this crucial feature is made sooner or later. 

Workaround is naturally sort the data already in C# code and wrote it in place already sorted and after that add needed comments. Or alternatively made sorting via Excel desktop software.

Thanks.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Juha, 

 

We will consider the feature in future. We suggest Workaround is naturally sort the data already in C# code and wrote it in place already sorted and after that add needed comments. Workaround.  

 

Regards, 

Keerthi.