https://bugs.documentfoundation.org/show_bug.cgi?id=101183
Bug ID: 101183
Summary: Hierarchical sorting of groups
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: davidjudysm...@gmail.com
Created attachment 126456
--> https://bugs.documentfoundation.org/attachment.cgi?id=126456&action=edit
Spreadsheet with three groups in column A.
Bug report 101182 describes a problem in which the group association of cells
in a column is scrambled when the column is sorted.
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 individually into alphabetical order regardless of group,
but the rows in each group remain unchanged.
I would like to see group information used during the sort, such that subgroup
items are sorted within each group, while the groups are sorted (and remain
together) based on the sorting of the group heads.
Before sort: After sort now: Desired behavior:
Animals Animals Animals
Bird Bird Bird
|-Robin |-Cat |-Chickadee
| Chickadee | Chickadee | Nuthatch
| Nuthatch | Chihuahua | Robin
|-Woodpecker |-Dog |-Woodpecker
Dog Manx Cat
|-Spaniel |-Nuthatch |-Manx
| Poodle | Persian | Persian
| Retriever | Poodle |-Siamese
|-Chihuahua |-Retriever Dog
Cat Robin |-Chihuahua
|-Persian |-Siamese | Poodle
| Siamese | Spaniel | Retriever
|-Manx |-Woodpecker |-Spaniel
So the groups would appear in order (Bird, Cat, Dog) after the sort, and within
each group, the sub-items would also be in order (Chickadee, Nuthatch, Robin,
Woodpecker, and so on).
I just completed a task for a friend, the alphabetizing of a book index with
both main and sub-entries. Hierarchical sorting in a spreadsheet, as proposed
here, would have made that task much, much easier.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs