Skip to main content

API support for AutoFilter - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

Request for adding an API support for Autofilters.

 

GemBox.Spreadsheet supports Autofilters only through the preservation in XLSX files.
Which means that if applied some autofilters 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 autofilters from the original input file, but they are not directly supported by GemBox.Spreadsheet API.

 

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

https://www.gemboxsoftware.com/spreadsheet/help/html/Preservation.htm

Comments (3)

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.
Mario - GemBox
Hi,

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


Regards,

Mario
GemBox d.o.o.