Background info: When using the Search field of the function Wizard, the Category immediately changes to "All". On non-empty cells that already contain a formula, the default Category of the Function Wizard depends on the category of the first function used in the formula in that cell. As of LO 7.4 (and 7.5), the behavior of the F.W on a cell that has no formula yet, regarding its Category field, is to always start with the Category "All" selected by default when starting the F.W. After the RFE in bug 104487, the behavior was slightly modified. On a cell that has no function (i.e. empty, direct values, or with simple operators), the default Category when opening the F.W. would be the same as the category of the _main_ function that was last _seen_ in the F.W. My request/suggestion is that when opening the F.W. on cells that don't have yet at least one function (of the list of functions in the F.W.), then the default Category would be the same that was left set in that Category field the last time the F.W. was used (at least for that session). This should also be the behavior (on cells with that conditions) when that prior Category was "All", or when that Category was "Last Used". Currently, after the resolution of bug 104487, this is not the case. The behavior when opening the F.W. on a cell that already has at least one function should not change. The behavior of the Category field when typing on the Search field should also be maintained. This proposal would effectively improve the efficiency of the "Last Used" Category (and of "All"), without disrupting other use-cases. Additional details were discussed in bug 104487.
So correct me if I'm wrong, Ady, but steps would be: 1. Open Calc 2. In cell A1, use Function Wizard, search for "PI", double-click this function, press OK 3. Move to cell A2, open Function Wizard, search for "CHAR", double-click this function, enter "100", press OK 4. Click back on A1, use Function Wizard: the category is Mathematical. Click Cancel. 5. Click on (empty) A3, use Function Wizard Result: category is Mathematical, same as PI() Expected result: category is Text, same as CHAR() Is that correct? Version: 7.6.0.1 (X86_64) / LibreOffice Community Build ID: 776eaf34564cbf3f034a0ba1fd1d5c32ff9ccf1c CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Experienced/advanced spreadsheet users will probably understand the request easier than generic users. This is why bug 104487 has so many specific detailed explanations, and this request is based on that. The following STR are based on LO 7.6. Older versions will behave differently (because of the implementation of tdf#104487). 1. Start with LO completely closed (i.e. new LO session). Start a new Calc spreadsheet. 2. A1: 1 A2: 2 A3: 3 3. In cell A4, click on the Function Wizard icon. Note that the Category field is "All"; the cursor blinks within the Search field. 4. Search for "average". The Function list is filtered. 5. In the Function list, select AVERAGE and follow the FW -> A4: =AVERAGE(A$1:A$3) 6. Go to cell A5; click on the Function Wizard icon. Note that the Category field is "Statistical"; the cursor blinks within the Search field. 7. Search for "concat" (a function that is not in the same Category as the prior function). The Function list is filtered. 8. In the Function list, select CONCAT and follow the FW -> A5: =CONCAT(A$1:A$3) 9. Go to cell A6; click on the Function Wizard icon. Note that the Category field is "Text"; the cursor blinks within the Search field. 10. Click on the Category field and select "Last Used" (i.e. shows the "recently used" functions). At least AVERAGE and CONCAT will be shown in the Function list in the FW. 11. In the Function list of the FW, select any function you would like and continue with the FW up to finishing it, inserting a new formula in cell A6. For example, A6: =SUM(A$1:A$3) 12. Go to cell A7; click on the Function Wizard icon. In order to show the complete set of possibilities (or algorithm, or logic), I would have to add many more steps. Please read tdf#104487 and comment 0 in this bug 155316. Current behavior (LO 7.6, _not_ in older versions, see comment 0): On a cell that has no function (i.e. empty, direct values, or with simple operators), the default Category when opening the F.W. would be the same as the category of the _main_ function that was last _seen_ in the F.W. (This is never the "Last Used" category.) Expected behavior: See comment 0. Let's CC Andreas Heinisch (quote from bug 104487 comment 18, "it is clear now").