Skip to main content linkedinfacebooktwittermenuarrow-up

API support for AutoFilter Completed

Request for adding API support for Autofilters.


GemBox.Spreadsheet supports Autofilters only through the preservation in XLSX files.
This means that if applied some auto filters in our XLSX file we can load our file with a GemBox.Spreadhsheet, make any required modifications, and save it back to an XLSX format. The output file will contain auto filters from the original input file, but they are not directly supported by GemBox.Spreadsheet API.


More information about GemBox.Spreadsheet's preservation can be found on the following link:

Official response

Mario at GemBox


This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.


Comments (2)

Rob Sherratt
It would be great if we could create autofilters instead of having to import a template and preserve autofilters from it. The problem with using a preserved template is that often the number of columns we are writing is different to the number of autofiltered columns in the template. Simply adding or deleting columns from the template file gives strange and unpredictable results.
Jan Gunawan
I completely agree with this idea! This library is really good, except it doesn't provide autofilter. It would be nice to see this feature added on the next release.