Sorting a range of cell data is a commonly-used feature. To sort cells
Range is quite easy like:
1 2 3 4 5 //true for descending order, false for ascending range.sort(true); //use CellOperationUtil, it checks sheet protection before sorting CellOperationUtil.sort(range, true);
When sorting a range of texts and numbers In ascending order, numbers will be arranged before text.
A range of cells before sorting:
A range of cells after sorting in ascending order: