Dear Aspose team,
We would like to sort data the same way Excel does when you select the rows to sort then do right-click > sort:
image.png (15.1 KB)
As you can see, we’ve sorted on column A and the table formatting (the border marked with the red arrow) stays at the bottom of row 7.
However, when sorting with DataSorter in Aspose, the bottom border stays attached to Bank of Ireland, as if the whole row was cut and pasted into the new position:
image.png (13.9 KB)
I’ve searched through the documentation, but there isn’t seem to be an option to specify how you want to move the data around:
https://reference.aspose.com/cells/net/aspose.cells/datasorter
https://docs.aspose.com/cells/net/data-sorting/
Can you please advise on how to achieve Excel’s sorting?
If a fix needs to be done, it might be worth it to allow users to specify if they want to sort only the text, text+text formatting, text+all formatting, etc with something similar to the enum PasteType.
I am attaching a zip folder with example code, input, expected output and Aspose output.
Sort affecting table formatting.zip (29.2 KB)
Thanks