Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Tue Jul 03, 2018 5:43 am

As the subject, Filter button disappear in Spire.sheet (v2.6.0)

xudong
 
Posts: 5
Joined: Tue Jul 03, 2018 3:19 am

Tue Jul 03, 2018 6:32 am

Hello,

Thank you for your post.
The "Filter button" is in fact a customized design button rather than a fixed one. You could add it according to the filter demo in Spire.Spreadsheet Pack Version:2.3.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Wed Jul 04, 2018 2:10 am

Thanks for the reply, What I actually mean is that I use Spire.Spreadsheet to load a existed Excel file(xlsx) which created by MS Excel 2010 with Filter buttons in it, but all the Filter buttons are missed when the file is loaded.

Anyway, I use Spire.xls to build Filter button by line "sheet.AutoFilters.Range = sheet.Range["B3:AA23"];", it works in Spire.Spreadsheet.

xudong
 
Posts: 5
Joined: Tue Jul 03, 2018 3:19 am

Wed Jul 04, 2018 6:01 am

Hello,

Sorry for my misunderstanding.
Just feel free to contact us if you need any assistance.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.Spreadsheet