Importing and then export a file with the GridDesktop control is always turning on autoFilter.
- Create a spreadsheet with no filtering
- Run the following code with the griddesktop
grdSpreadsheet.ImportExcelFile(ofd.FileName)
grdSpreadsheet.GetActiveWorksheet.RemoveAutoFilter()
Dim strFileName As String = Path.GetTempPath + Path.DirectorySeparatorChar +
Path.GetFileNameWithoutExtension(Path.GetRandomFileName) + “.xlsx”
grdSpreadsheet.ExportExcelFile(strFileName)
Process.Start(strFileName) - Notice the speadsheet now has filtering turned on