Skip to main content linkedinfacebooktwittermenuarrow-up
Contact Us

New to GemBox Support Center? Register for an account

Need a password reminder?

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

New GemBox.Spreadsheet Feature Request
API support for Auto... Community
22

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:

https://www.gemboxsoftware.com/spreadsheet/docs/preservation.html

Official response

Mario - GemBox

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

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.
New GemBox.Spreadsheet Feature Request
API support for Auto... Community
Author
Mario - GemBox
Creation date
Mar 20, 2014
Last update
Apr 27, 2018
Publish date
Mar 20, 2014