Summary: | CALC: EDITING: Cannot remove or create COLUMNAR data groups when "unrelated" columns contain AUTOFILTERS. Rows work fine | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | miguelangelrv |
Priority: | medium | ||
Version: | 7.5.9.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Sample CALC demonstrating the bug |
Description
Colin
2024-04-01 20:38:13 UTC
Created attachment 193426 [details]
Sample CALC demonstrating the bug
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. (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 (In reply to Colin from comment #3) > (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. > > > 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. > Confirmed. Simply clearing the filter permits columnar grouping regardless of the status of row groups. Now the big question is - Should the hidden rows in an autofilter impact the creation or removal of columnar groupings to unrelated columns? - simplified version - Bug or Feature? |