[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 Heiko Tietze changed: What|Removed |Added Status|NEW |ASSIGNED CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Blocks||86899 Keywords|needsUXEval | Assignee|libreoffice-b...@lists.free |qui...@gmail.com |desktop.org | --- Comment #16 from Heiko Tietze --- We discussed the topic in the design meeting. The function is very much welcome. Adding it to the sort dialog is quite confusing given that you first sort asc by column A, then randomly by B, and last desc for C. Makes no sense. So we recommend to add the command "Unsort Selection" under Data next to the sort options. (an alternative to unsort would be shuffle; randomize might be misleading) Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=86899 [Bug 86899] [META] Requests for the addition of UNO commands -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 Tomaz Vajngerl changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #15 from Tomaz Vajngerl --- I found the code and updated the https://gerrit.libreoffice.org/c/core/+/22963 -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #14 from cson...@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.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #13 from j22...@gmail.com --- (In reply to Tomaz Vajngerl from comment #10) > (In reply to Werner Tietz from comment #9) > > I don't agree with that, »shuffle« is the complete opposite of »sorting«. > > It's an almost identical action - shuffle is sort with an random order > instead of derived from the content. > > > If it is, then it should be another Option under →→Sheet→→Fill Cells→→Fill > > Random Numbers > > This has nothing to do with filling cells - it's shuffling existing cells, > so why it should be added there. The only thing in common with the random > number generator is that the actions do something randomly. Agree. 'Sort' in this context is an umbrella term for 're-arrange the elements'. The re-arrangement could be either in a given order (ascending, descending) or in a purposedly 'unordered' fashion (i.e. random). -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #12 from j22...@gmail.com --- (In reply to J22Gim from comment #11) > (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. Don't > > get the "values in range". > > Nice! Agree. 'Sort' in this context is an umbrella term for 're-arrange the elements'. The re-arrangement could be either in a given order (ascending, descending) or in a purposedly 'unordered' fashion (i.e. random). -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #11 from j22...@gmail.com --- (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. Don't > get the "values in range". Nice! -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #10 from Tomaz Vajngerl --- (In reply to Werner Tietz from comment #9) > I don't agree with that, »shuffle« is the complete opposite of »sorting«. It's an almost identical action - shuffle is sort with an random order instead of derived from the content. > If it is, then it should be another Option under →→Sheet→→Fill Cells→→Fill > Random Numbers This has nothing to do with filling cells - it's shuffling existing cells, so why it should be added there. The only thing in common with the random number generator is that the actions do something randomly. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #9 from Werner Tietz --- I don't agree with that, »shuffle« is the complete opposite of »sorting«. If it is, then it should be another Option under →→Sheet→→Fill Cells→→Fill Random Numbers -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #8 from Tomaz Vajngerl --- (In reply to Stéphane Guillou (stragu) from comment #7) > Thanks, Quikee! As I understand it, this covers the second part of what > Rafael mentioned (cell range shuffling), but does not integrate it into the > Sort dialog to offer the sort + randomise option, right? I think it just adds a new command that shuffles the cell range, but that's the more difficult core change. There is no change to sorting or the sort dialog AFAIR. I was working on https://gerrit.libreoffice.org/c/core/+/22963 a couple of months ago, so it can works with a recent build and fixed some issues reported, but I forgot to push it and don't have the access to the machine now :( -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #7 from Stéphane Guillou (stragu) --- (In reply to Heiko Tietze from comment #5) > (In reply to J22Gim from comment #0) > [...] And it's rather unexpected to > sort up/down and random. This could be useful for randomising sets, while keeping the sets ordered. For example, randomise the samples identified by their ID in column B, while keeping "Set 1", "Set 2", "Set 3" ordered in Column A. > Don't get the "values in range". I guess Rafael means something like sampling the values without redraw in a range of cells, which I think should be separate form the Sort dialog as it is not per se done in a row or column direction. We can already do something similar with Data > Statistics > Sampling. (In reply to Tomaz Vajngerl from comment #6) > There is mostly working but incomplete patch at > https://gerrit.libreoffice.org/c/core/+/22963 > If someone wants to complete it (see Eike's comments what's wrong). Thanks, Quikee! As I understand it, this covers the second part of what Rafael mentioned (cell range shuffling), but does not integrate it into the Sort dialog to offer the sort + randomise option, right? -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #6 from Tomaz Vajngerl --- There is mostly working but incomplete patch at https://gerrit.libreoffice.org/c/core/+/22963 If someone wants to complete it (see Eike's comments what's wrong). -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 --- Comment #5 from Heiko Tietze --- (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. Don't get the "values in range". -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #4 from Rafael Lima --- (In reply to Stéphane Guillou (stragu) from comment #3) > I agree that this would be a welcome feature, form the point of view of > using Calc in research. > > What do you think, UX/Design team? I agree with this proposal... I often have to shuffle rows of data (not only values in a selection). I even wrote a few macros to help with that. Maybe we could have a new Uno command capable of: - Shuffling values in a cell range - Shuffling rows in a cell range - Shuffling columns in a cell range -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 158196] Add 'shuffle' or 'random' option to 'Sort' dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=158196 Stéphane Guillou (stragu) changed: What|Removed |Added Summary|Add 'shuffle' option to |Add 'shuffle' or 'random' |'Sort' menu |option to 'Sort' dialog -- You are receiving this mail because: You are on the CC list for the bug.