Support Center

Welcome back, guest

Register or login below.

Knowledgebase

Feedback

22
Voting closed
Completed

API support for AutoFilter

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.

The following link is a demonstration sample of preserving Autofilters when reading from XLSX file and writing to XLSX file:

http://www.gemboxsoftware.com/SampleExplorer/Spreadsheet/XLSXPreservation/ConditionalFormatting_Autofilter

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

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

2 Comments

  • 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.
  • 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.