https://bugs.documentfoundation.org/show_bug.cgi?id=160470
--- Comment #3 from Colin <[email protected]> --- (In reply to m_a_riosv from comment #2) > The issue is it doesn't ungroup with hidden rows. Click on the top-left of > the headers, unhidden rows, now is possible to group and ungroup. It does if the hidden rows don't contain an auto-filter with some dates excluded to minimise the chart clutter. Why would it only fail on Column actions NOT row actions? You may create a "noughts and crosses" framework of hidden columns and rows to your heart's content but NOT if the autofilter has been activated. Why should the autofilter exclusion cause a different action to a Group Hide - especially if the autofilter array is 20 columns to the left of the new columnar grouping? >but NOT if the filter has been activated. I guess your suggestion to unhide all hidden rows also unhides the autofilter exclusions so it may not be necessary - just "select all" in the filter. I will experiment and re-apprise. I only discovered this at 23:30 last night as I was building a new sheet by systematically copying the elements.The moment I removed the autofilter it returned to normality. I relised that I had introduced that feature during January this year - with the grouped columns already in place and not needing "re-focusing" until we entered the 2nd quarter -- You are receiving this mail because: You are the assignee for the bug.
