Hi,
We have found this sorting issue; whenever we save a workbook containing a sorting setting i.e. “A to Z” the filtering is lost in the generated file.
Note: The sort setting is empty but the arrow is there.
I have attached a small project to demonstrate the issue. I have also attached an input file “input sorted file.xlsx” to use when running the project.
The mini application will generate two files called “generatedFile.xlsx/pdf”. Please have a look at the generated xlsx file and check the sort settings as shown in the screenshot “sort arrow there but there is not sort in the sort window.PNG”