Contact Us

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

22

API support for AutoFilter Completed

Mario - GemBox

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

6 years ago

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

5 years ago

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

2 years ago

Hi,

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

Regards,

Mario
GemBox d.o.o.

Created By: Mario - GemBox
Published: Mar 20, 2014
Unpublished date: Apr 27, 2018 closed