[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=158196

--- Comment #14 from csongor at halmai.hu ---
(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 on the CC list for the bug.