GridDesktop Autofilter being turned on when importing excel sheet

Aspose.Cells Product Family
1

Importing and then export a file with the GridDesktop control is always turning on autoFilter.

  1. Create a spreadsheet with no filtering
  2. 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)
  3. Notice the speadsheet now has filtering turned on
2

I am using 18.7 .Net

3

@philipstone,

Thanks for the sample code segment and details.

I did test your scenario/ case a bit using a simple Excel file (which does not have auto-filters) and your sample code, it works fine and the output file does not contain auto filters. Could you provide your template Excel file (input file) and the output file (by Aspose.Cells.GridDesktop), we will check it soon.