I’m investigating an issue with Excel losing custom sorting when saving the file with Aspose.Cells. No need to make any edits, just save, and the custom sorting is lost.
The case is related to older Excel format XLS files only. This does not happen with newer XLSX format. As well another detail is that you must have more than 3 custom sorting rules set. Attached picture will help to understand.
When you set the sorting and save the file in Excel it does warn about possible loss of data, but when opening the file the sorting rules are still there. After saving the file with Aspose.Cells it will lose these sorting rules.
/// Opens and saves the file without any modifications.
public static void OpenAndSave( string excelFile, string saveAsFile )
// Open the file.
Workbook excel = new Workbook( excelFile );
// Save as stamped file.
excel.Save( saveAsFile );
Attached couple images to illustrate what happens.