Free Support Forum - aspose.com

Button to filter columns

I create a report that has a bunch of columns. I would like to add a button into Cell A1 that allows me to select the column header(s) I want to see and hides the other columns. Is there any way to do that in Aspose.Cells?


Hi,

I think you might be talking about Auto-Filters feature, Aspose.Cells for .NET does support it, see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/data-filtering-and-validation.html


If you need to hide / show whole columns simply, see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/hidingunhiding-rows-and-columns.html


Also, for your information, we don’t support vbas/macros, so you cannot do event handling to perform specific features although you may simply add Command buttons if you want:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/working-with-controls.html

Thank you.