[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||5316 --- Comment #19 from ady --- (In reply to Andreas Heinisch from comment #18) > I would prefer a new enhancement report OK. That is now bug 155316. And thank you for these improvements. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #18 from Andreas Heinisch --- Imho it is clear now, but I would prefer a new enhancement report since this would break the connection between the function category and the function list below. So if there are any regression we would not revert this report but just the new one. Thank you! -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #17 from ady --- (In reply to Andreas Heinisch from comment #16) > So, what is your proposal? > > If there is an empty cell with no function, we should select the "Last Used" > category? I thought I presented my proposal in comment 10. Then I clarified it further in comment 13, and then in comment 15. Let's try again. Try to reproduce the steps I described, paying attention to the default Category each time you open the F.W. Start on an empty cell, choose one function in the F.W. and introduce a complete formula in that cell. Then move-on to another cell and use the F.W. with a different function from a _different_ category. Repeat for 3 or 4 cells, with different functions from different categories. Which Category do you see by default when you open the F.W. in each empty cell before introducing a formula? Is the "Last Used" Category _ever_ the default? If it isn't, then imagine what would happen if it was in this particular scenario? Do you think it would reduce the amount of clicks if you were to need those same 3 or 4 functions again (and again...)? What would happen if a formula in one cell is composed by several nested functions from different categories? Then imaging a user having to introduce functions from the _same_ Category. * The advantage of having Category "All" by default on empty cells (i.e. behavior before your patch) is discover-ability. * The advantage of having by default the same Category (whichever that might be, including "Last Used" and/or "All") as the last time the F.W. was used in the session (i.e. proposed behavior) is efficiency. Having the default _Category_ being remembered (which is not always the same as using the category of the last used function) from the last time the F.W. was used (in the same session) allows for all scenarios. Some use-cases would prefer "All", others would go for "Last used", and other use-cases would select one particular Category (e.g. "Mathematical") again and again – only the latter being your patch from comment 7. The same user sometimes would prefer one use-case, and sometimes another. In all these scenarios, typing-in within the Search field of the F.W. would immediately show the Category named "All", as it happens currently. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #16 from Andreas Heinisch --- So, what is your proposal? If there is an empty cell with no function, we should select the "Last Used" category? -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #15 from ady --- (In reply to Andreas Heinisch from comment #14) > Hm, for me it is not clear if this minimizes the clicks in the function > dialog. The current behavior is useful only when the usual functions that are being used are all from the same Category. For any other case, users have to either use the Search field (i.e. "All" Category), or click on the Category field in order to select the "Last Used" Category. This is relevant for empty cells, or for nested functions, while you are building a complex formula. When the recent functions that were/are being used are part of different Categories, having the "Last Used" Category ready allows to keep using them: a single click to select, versus at least two clicks or typing-in in the aforementioned situation (which is the current behavior). Moreover, the same proposed behavior also allows one click selection when the functions are from the same Category, because they are also part of the "Last Used" Category. The only case in which there is no relative advantage in the proposed behavior is when the user is using "much more than just a few" functions in the recent runs of the F.W. while all those functions come from the same Category. If the functions are not from the same Category, then there is no "cons" either. > You may also provide a patch for the function itself because it is > just setting a static variable > (https://gerrit.libreoffice.org/c/core/+/151565). I may review the change. Sure, except that I am not a developer so I have no idea how to do it :(. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #14 from Andreas Heinisch --- Hm, for me it is not clear if this minimizes the clicks in the function dialog. You may also provide a patch for the function itself because it is just setting a static variable (https://gerrit.libreoffice.org/c/core/+/151565). I may review the change. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #13 from ady --- (In reply to Andreas Heinisch from comment #11) > Again I open the > function wizard shows the structure tab. If I change back to the functions > tab, the mathematical category is selected. The whole point of the request is about the F.W. Category / behavior when the cell is empty, or at least with no function already introduced in the cell. When I said "next run of the F.W." I don't mean in the same cell as the prior run, where there is already a formula that was just introduced a second ago. I skipped this phrase in my comments because (for me, and probably for other spreadsheet users too) it was evident from the initial request. Apologies. > > > > > Suggestion: > > > > 1. First use of the Wizard in the session, the default Category should be > > "All". This is already happening now. > > > > 2. If the user selects a specific Category in one run of the Wizard, then > > the next time the Wizard is used, the Category should be the same as it was > > selected previously, at the end of the prior run of the Wizard. The default > > Category should _not_ vary depending on the function that was used in that > > run. > > The function list and the category are linked together and I don't know if > we should change that. I understand. Perhaps this relation should not be direct one-to-one. The function is part of a group (Category), and the request is about the default group that is displayed when the F.W. is opened (on an empty cell), not about the last-used function. This also explains why the "Last Used" Category is never the default, which makes the "Last Used" Category much less used in practice. > > > > 3. Point 2 above would also solve the case of the Category in the prior run > > being either "All" or "Last Used". For example, if I already selected the > > "Last Used" Category in the prior run of the wizard, then when the Wizard is > > used again the same "Last Used" Category is still selected. For instance, if > > the selected Category was "Last Used" (or "All") and the function was SUM(), > > then the next run of the wizard the Category will still be "Last Used" (or > > "All" if that was the selected Category in the prior run of the Wizard), not > > automatically changed to "Mathematical". > > Yep, see my answer to point 1. See my clarification about the basic premise. > > > > 4. If the user types-in strings in the Search field, the results should not > > be limited to one particular Category; i.e. the Category immediately jumps > > to "All". This is already happening now. If I used the Search field in the > > prior run, then Category "All" was last used (unless I change it during the > > selection of the function), and that should be the default Category the next > > run (or whatever specific Category I selected after using the Search field > > during the same run of the Wizard). > > This is the case atm. Yes. Point 2 is the important change, with point 3 being a sub-case (or an explicit important example), for clarity. Points 1 and 4 are currently the behavior already. I mentioned the 4 points in order to make it clear which behavior should be kept and which behavior should be improved. I was afraid that, by not mentioning the complete expected behavior, the request would be misunderstood and something that was already OK would be modified, unintentionally. Apparently the original reporter and additional comments all skipped the important part where we are talking about cells that are initially without formulas, where the request makes more impact. There might be possible improvements on non-empty cells, but not without improving the current situation on empty cells first. > > Maybe we can have some input from the design team. (In reply to Heiko Tietze from comment #12) > The category is remembered within the current session, which makes sense as > one scenario may include similar functions. And at the next app start it is > reset to All, as this scenario might involve different functions. IMO it's > good as it is. You are not mentioning the "Last Used" Category. Please read what I just answered to Andreas, and then perhaps you might want to re-read the whole RFE with that clarification and the "Last Used" Category in mind. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 --- Comment #12 from Heiko Tietze --- The category is remembered within the current session, which makes sense as one scenario may include similar functions. And at the next app start it is reset to All, as this scenario might involve different functions. IMO it's good as it is. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 104487] Function Wizard should remember Category selection per session
https://bugs.documentfoundation.org/show_bug.cgi?id=104487 Buovjaga changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org Keywords||needsUXEval -- You are receiving this mail because: You are on the CC list for the bug.
