1

If I load an xlsx file that already has a filter, and then save the file using GemBox, it seems to throw my filtering cell away. Does GemBox support filtering at all? I know I can load the file in preserved mode but my intention is to create the filter in my C# app.

Mario Z
  • 4,328
  • 2
  • 24
  • 38
Corpsekicker
  • 3,276
  • 6
  • 25
  • 34
  • Corpsekicker I just wanted to let you know that in the current version of GemBox.Spreadsheet (version 3.9) we have introduced an API support for filters, see here: http://www.gemboxsoftware.com/news/new-gembox-spreadsheet-3-9-release-with-autofilter-and-in-line-text-formatting-support – GemBox Dev Team Jun 01 '15 at 08:18

1 Answers1

1

EDIT 2015-06-15:
The newer version of GemBox.Spreadsheet (version 3.9) does have an API support for filters, see the version history page. Also, you can find here an Excel AutoFilter example.

ORIGINAL ANSWER:
Unfortunately, in the current version (3.5) GemBox.Spreadsheet supports filtering only through preservation.

GemBox Dev Team
  • 669
  • 5
  • 18