I am comparing two Excel files (*.xlsx). I have noticed that the rows are not sorted properly by key column. I have upgraded to the most recent version 3.3.5, but that did not help with the issue.
I have tried to go around the sort issue by cutting and pasting the lines, so that same key ends up on the same line in both files, but there is a problem with cut and paste. Cutting and pasting a line, results in data being shifted to different columns when there are some columns which are blank.
Please fix both issues.
I have tried to go around the sort issue by cutting and pasting the lines, so that same key ends up on the same line in both files, but there is a problem with cut and paste. Cutting and pasting a line, results in data being shifted to different columns when there are some columns which are blank.
Please fix both issues.
Comment