We are trying to determine if non-visible rows in a worksheet have been hidden directly by the user or because of filtering. We do different things based on why the rows are hidden.
In Excel, we’d check the “FilterMode” property of the Worksheet object to see if filtering is currently filtering anything - if nothing is hidden due to filtering, it returns false. However, I don’t see an equivalent in Aspose. Is there one?
On the Worksheet object in Aspose.Cells, there is the “HasAutofilter” property, which tells me if an auto-filter exists at all on the worksheet, but it doesn’t tell me if any items have been filtered, just that the auto-filter exists. There is also an “AutoFilter” property, where I can get the range affected by the filter, but I don’t see any way to indicate if anything has been filtered.
Is there a way to do what I’m trying to do with Aspose.Cells?