https://bugs.documentfoundation.org/show_bug.cgi?id=158196
Bug ID: 158196
Summary: Add 'shuffle' option to 'Sort' menu
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Sometimes the user wants to re-order the rows in no specific sequence.
Actually, many times it is useful to shuffle them, i.e., to re-arrange the rows
in a random order. Currently, there is no simple way to do this. This is a
pitty because a) it is a relatively simple task, and b) it is quite normal in
data analysis, statistics, and simulations.
I propose to add a 'Shuffle' option available in the 'Sort' menu.
Steps to Reproduce:
1. you have a column in a specific order
2. you want to re-arrange the data in a random order
3. there is no option to do this
Actual Results:
you have to use a workaround
Expected Results:
there should be an option to shuffle the data within the Sort menu(s)
I propose to add this option in 2 different places:
1) in Data -> Sort, add a third option so the sorting can be "Ascending",
"Descending", and "Random" (other potential names: "no order", "shuffle",
"un-order")
2) in Autofilter, add the "Shuffle" or "Random" option to the first 3 options,
so the dialog would show "Sort Ascending", "Sort Descending", "Shuffle data"
(other names: "Random order", "No order (random)", etc.)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The procedure would be quite simple. In pseudocode, it would look like this.
To shuffle Column 1 (which has n rows):
- create a Column 2 with n rows
- populate Column 2 with the formula randbetween(0, n)
- sort Column 1 using Column 2 (eg can be Descending or Ascending).
--
You are receiving this mail because:
You are the assignee for the bug.
