We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Clearing AutoFilter not Working

I’m re-evaluating Aspose Cells 21.7 and running into an issue clearing filtered data. I beleive this used to work in previous versions.

I have a worksheet with a range of filtered data. I want to remove that filter/clear the filter and show all the data, then create a PDF from that.

My original code was this:

if ( wSheet.HasAutofilter )
{
	TestContext.WriteLine("Autofilter detected");
	wSheet.AutoFilter.ShowAll();
}

I then updated to try this:

if ( wSheet.HasAutofilter )
{
	TestContext.WriteLine("Autofilter detected");
	int[] rows = wSheet.AutoFilter.Refresh(false);
	wSheet.AutoFilter.ShowAll();
	int[] rows2 = wSheet.AutoFilter.Refresh(false);                               
}

wSheet.RemoveAutoFilter();

In both cases, not all of my filtered data is shown in my PDF, and nor in a save as XLS.

I have attached my test XLS file. The file has a filtered range and then shows what data I should be seeing if the filter was removed.

FilteredAndCommentedCells.zip (8.8 KB)

Thanks.

@sheri_steeves,
We have observed this issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-48512 - Clearing AutoFilter not working properly

@sheri_steeves,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@sheri_steeves
Please try the latest fix 21.7.7
Aspose.Cells21.7.7 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.7.7 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.7.7 For .NetStandard20.Zip (5.6 MB)

The issues you have found earlier (filed as CELLSNET-48512) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao