Free Support Forum -

Cannot sort the data with first sortkey as blank

Hi Aspose Team,

While sorting the data in ms excel if the first sort key is given as blank then an error message "First sort by box cannot be blank" is thrown. Please confirm if this is the expected behaviour for Aspose as well. Attached document consisting of the screen shot.




I have checked it on Ms-Excel 2010 and found it is expected behavior. Please see the screenshot.

Aspose.Cells behavior should also be the same because it mimics Ms-Excel. If you find some error, then please share your code. We will check it soon.



Please try the new fix: Aspose.Cells for Java (Latest Version)

From this fix we provide new APIs for data sorting:

1). Sorter com.aspose.cells.Cells.getDataSorter(int startRow, int startColumn, int endRow, int endColumn)

Gets data sorter to sort data in given range.

startRow Start row index.
startColumn Start column index.
endRow End row index.
endColumn End column index.
Sorter object for sorting data.
2). com.aspose.cells.Sorter

Sorter for cells data sorting.

3). SortValueCriteria com.aspose.cells.Sorter.addLevel(int fieldIndex, byte sortOrder)

Adds new level to sort data by values.

See Also:
fieldIndex the 0-based field index in the sorted range. Top-left row/column's field index is 0.
sortOrder sort order of the new value sort condition.
sort criteria for the new level.
4). void com.aspose.cells.Sorter.sort()

Sorts the data in range of this sorter.

Code example:
Sorter sorter = cells.getDataSorter(ca.getStartRow(), ca.getStartColumn(), ca.getEndRow(), ca.getEndColumn());
sorter.addLevel(0, SortOrderType.ASCENDING);
sorter.addLevel(1, SortOrderType.DESCENDING);
sorter.addLevel(2, SortOrderType.ASCENDING);