Posted 8 September 2017, 1:02 pm EST
I'm using far point spread sheet . Currently to sort the rows in the spread sheet i have written the following sortrows function.
sheetView.SortRows(0, sheetView.Rows.Count, sortInfo)
If i use this the sorting takes place as follows in Current scenario:
When i try to sort a column in both ascending and descending order , all the special characters appears first followed by data with numbers, then with A...Z followed by empty values in ascending order and vice versa in descending except empty values. The empty values appear at the end.
But i need the sorting to take place as follows:
If i sort a column in ascending order,empty values should come on top(The result should be displyed the same way as we get from the database thro query using sort by).
Could you please suggest a solution for this?