https://bugs.documentfoundation.org/show_bug.cgi?id=160470
Bug ID: 160470
Summary: CALC: EDITING: Cannot remove or create COLUMNAR data
groups when "unrelated" columns contain AUTOFILTERS.
Rows work fine
Product: LibreOffice
Version: 7.5.9.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a sheet contains an autofilter array which was created after various
columns were grouped then the ability to either delete or create new columnar
groups is prohibited. Attempting to remove the column groups results in No
Operation or warnings whereas the attempt to create a new group asks the
irrelevant question "rows or columns" and then rejects the operation with the
error message "This function cannot be used with multiple selections".
If a user selects columns by their header then it's unlikely the user is
referring to ROWS ie the entire spreadsheet.
Selecting just ONE column is never a multiple selection unless the system is
confusing all 1048576 rows in that column as multiple selections
I have not investigated whether the response changes if the Autofiltered array
was created before any attempt was made to create columnar groups
Steps to Reproduce:
Using the attached sample file you will observe grouped rows and columns.
Verify that you may add further ROW groups by selecting some contiguous rows
and F12
Observe that you may delete those additional groups with [Ctrl]+F12
Now attempt to remove a columnar group by selecting the column headers beneath
that group and [Ctrl]+F12.
Observe No Operation
Now select some adjacent columns and attempt to create columnar groups with
F12.
Observe and respond "Columns" to the irrelevant question.
Observe the error message.
Left click the histogram and move it to expose the Autofiltered array on row
14.
Select A14:G14 and deactivate the filter - If you have the same ribbon as me
this will be highlighted or [Ctrl][Shift]+L will toggle the status.
Removing the Autofilter will permit removal and creation of columnar groups
Actual Results:
Unable to remove or create Columnar Groups
Expected Results:
Ability to remove or create Columnar Groups
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
