https://bugs.documentfoundation.org/show_bug.cgi?id=158196
--- Comment #14 from [email protected] --- (In reply to Heiko Tietze from comment #5) > (In reply to J22Gim from comment #0) > > I propose to add a 'Shuffle' option available in the 'Sort' menu. > Drawback is that the option bloats the UI. And it's rather unexpected to > sort up/down and random. But the extra UNO command, as suggested by Rafael, > to shuffle data sounds straightforward to me, at least for row/column. Sometimes I also need the randomization and adding an extra column with random values just in order to do that is not always simple. I would welcome such a change. I find the extra radio button "Random" under Ascending and Descending is pretty straightforward. If it was really needed, a new menu item "Shuffle" could come in the Data menu under the Sort Descending but I don't think it is needed so often. Therefore, I would be happy if it was just an extra radio button in the Sort dialog, as the second attachment shows. I would like to have this feature. Regarding the various Shuffle options: >> - Shuffling values in a cell range >> - Shuffling rows in a cell range >> - Shuffling columns in a cell range > Don't get the "values in range". I interpret this as shuffling rows and columns moves the selected cells of a row/column together while shuffling values moves the individual cells independently from each other. For example, if cells [1], [2], [4] and [5] are selected in this table: 0 1 2 3 4 5 6 7 8 then the outcome of the individual shuffles could be this: - Shuffling values in a cell range 0 2 4 3 5 1 6 7 8 (only the selected values move, they move independently, unselected cells don't move) - Shuffling rows in a cell range 0 4 5 3 1 2 6 7 8 (selected cells of a row (4-5 and 1-2) move together, unselected cells don't move) >> - Shuffling columns in a cell range 0 2 1 3 5 4 6 7 8 (selected cells of a column (1-4 and 2-5) move together, unselected cells don't move) If my understanding is correct then I don't find these last two ones as useful as the first one, or as moving the complete rows/columns together, even the unselected cells. -- You are receiving this mail because: You are the assignee for the bug.
