diff --git a/ClosedXML/Excel/AutoFilters/IXLAutoFilter.cs b/ClosedXML/Excel/AutoFilters/IXLAutoFilter.cs index 32cc570..eff35f0 100644 --- a/ClosedXML/Excel/AutoFilters/IXLAutoFilter.cs +++ b/ClosedXML/Excel/AutoFilters/IXLAutoFilter.cs @@ -13,6 +13,7 @@ public interface IXLAutoFilter { Boolean Enabled { get; set; } + IEnumerable HiddenRows { get; } IXLRange Range { get; set; } Int32 SortColumn { get; set; } Boolean Sorted { get; set; } diff --git a/ClosedXML/Excel/AutoFilters/XLAutoFilter.cs b/ClosedXML/Excel/AutoFilters/XLAutoFilter.cs index 51bca0c..8b55418 100644 --- a/ClosedXML/Excel/AutoFilters/XLAutoFilter.cs +++ b/ClosedXML/Excel/AutoFilters/XLAutoFilter.cs @@ -20,6 +20,7 @@ #region IXLAutoFilter Members public Boolean Enabled { get; set; } + public IEnumerable HiddenRows { get => Range.Rows(r => r.WorksheetRow().IsHidden); } public IXLRange Range { get; set; } public Int32 SortColumn { get; set; } public Boolean Sorted { get; set; }