How to set advance filter in code?

Aspose.Cells Product Family
1

I want to set advance filter in worksheet, like Advanced Filter in Excel (In Easy Steps)


How can I do this in java code?

2

Hi,


Thanks for your query.

I am afraid, the feature (“Advanced Filter (MS Excel) feature to display records based a complex criteria”) is not supported at the moment. We have limited data filtering options available to filter data based on simple criteria but the API might not accomplish your task completely. A ticket is logged with an id “CELLSJAVA-42322” for your requested feature. We will look into it to try to support it soon.

Once we have an update on it, we will let you know here.

Thank you.
3

The issues you have found earlier (filed as CELLSJAVA-42322) have been fixed in Aspose.Cells for Java 17.7.

4

We recommend you to kindly try our latest version/fix Aspose.Cells for Java 17.8.

5

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan