1 of 1 people found this helpful
We came across the same issue today and your question helped us to figure out the issue. As you said clearFilterAsync() is not clearing the context filters properly. So use activeSheet.applyFilterAsync(filterName, , 'ALL') which is clearing the context filter properly and giving us the appropriate results.
I know the reply is way to early , but we came across this issue today.