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

Free Support Forum - aspose.com

Cannot sort the data when any two sortkeys are for the same column

Hi Aspose Team,

While sorting the data in ms excel, if any two sort keys are given for the same column then an error "The sort reference is not valid. Make sure that its within the data you want to sort, and the first sort by box isn't the same or blank" is thrown. Please let us know if this is expected behaviour in Aspose.Cells as well. Please refer the attached document for the screen shot.




Aspose.Cells follows MS Excel standards, so you should expect the same behavior for data sorting in the Excel file generated by Aspose.Cells API. If you find different behavior, give us your sample code and template file(s), we will check it soon.

Thank you.