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

Free Support Forum - aspose.com

Unable to sort a range of cells alphabetically

I’m trying to sort a range of cells that is 88 rows by 7 columns. I’m sorting alphabetically by column# 7. This is the code that I’m using:

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; color: #4e9072} span.s1 {color: #7e504f} span.s2 {color: #0326cc} span.s3 {color: #000000} span.Apple-tab-span {white-space:pre}

DataSorter sorter = workbook.getDataSorter();




The result does not seem to have any pattern. It is not alphabetical and only a subset of samples have changed from before sorting. What am I missing?

Sorry for the accidental double post!


Thanks for your posting and using Aspose.Cells.

Please see this thread, it should help you deal with your sorting problem. It has sample code [in C# and Java], sample excel file and screenshot that explains how to make use of sort feature of Aspose.Cells. Let us know your feedback.