Indian Language Sort allows users to sort Indian Language ISFOC data in ascending or descending order, based on the contents of one or more columns. The utility only rearranges cells contents. Attributes (bold, italic, font colour etc.) applied to the cell contents do not get rearranged.
Indian Language Sort uses the principle of ISCII Sort, Dictionary Sort or Unicode sort to sort data.
How to use
To use this utility Openoffice Calc document that contains data to be sorted. Select the columns you want to sort. You can select a maximum of 300 rows for sorting. In the ISM menu (Help on loading menu) select Sort menu item. ISM SORT dialog box is displayed as shown below.
Specify the Sort options in the Sort dialog box.
- Specify the order of columns you want to sort by, using the Sort by and Then by fields.
- Specify the sorting order, viz Ascending or Descending.
- Specify the Sorting Standard you want to use, viz ISCII Sort or Dictionary Sort.
An example of sorted data is shown below for reference.
NOTE ▬
- Sorting of data in multiple font types is not supported.
- Empty cells are allocated the highest sort position. That is, the sorting algorithm arranges empty cells at the end when sorting in ascending order, while it arranges these cells at the beginning when sorting in descending order.