https://bugs.documentfoundation.org/show_bug.cgi?id=101182
Bug ID: 101182
Summary: Sort destroys group information
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126455
--> https://bugs.documentfoundation.org/attachment.cgi?id=126455&action=edit
Spreadsheet with three groups in column A.
The attached spreadsheet, Grouped Animals.ods, contains a single column with
three groups: Bird (with group items Robin, Chickadee, Nuthatch, and
Woodpecker), Dog (with group items Spaniel, Poodle, Retriever, and Chihuahua),
and Cat (with group items Persian, Siamese, and Manx). When I sort the column,
the items are sorted into alphabetical order regardless of group, but the rows
in each group remain unchanged. That is, the first group is still defined as
rows 3-6, the second as rows 8-11, and the third as rows 13-15, even though
those no longer make sense.
Before sort: After sort:
Animals Animals
Bird Bird
|-Robin |-Cat
| Chickadee | Chickadee
| Nuthatch | Chihuahua
|-Woodpecker |-Dog
Dog Manx
|-Spaniel |-Nuthatch
| Poodle | Persian
| Retriever | Poodle
|-Chihuahua |-Retriever
Cat Robin
|-Persian |-Siamese
| Siamese | Spaniel
|-Manx |-Woodpecker
So before the sort, the group headings are Bird, Dog, and Cat; after the sort,
the headings are Bird, Manx, and Robin.
I will submit a separate enhancement request for this situation, but at the
very least, the Sort should refuse to act on a grouped column (or row) if doing
so will destroy the group associations.
(To duplicate the behavior, open the attached Grouped animals.ods spreadsheet,
select a cell in column A, and choose Data > Sort. The Sort Options should
have "Range contains column labels" checked, and the Sort Key should be
Animals.)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
