https://bugs.documentfoundation.org/show_bug.cgi?id=104487
--- Comment #13 from ady <adylo811...@gmail.com> --- (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.
