Posted 14 March 2018, 5:32 pm EST
I have a fpspread where one column in empty [I am inserting a empty string " " ] .
I am seeing a weird behaviour when I try to sort this empty column.
fpSpread1.ActiveSheet.SortRows(e.Column, true, true);
The first and last row stay as is and the rows in the middle are getting sorted with respect to the first column of the spread . This is not happening if the number of rows are less .
For now we are giving a secondary column to the sortinfo class to avoid this , but wanted a clarification on what exactly happens when you try to sort a empty row ?