From Documentation

Jump to: navigation, search






Sorting a range of cell data is a commonly-used feature. To sort cells with Range is quite easy like:

//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:

Zss-essentials-sortBefore.png

A range of cells after sorting in ascending order:

Zss-essentials-sortAfter.png



All source code listed in this book is at Github.



Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.