Summary: | Function Wizard should remember the Category field selection from its prior use, at least per session (RFE) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | ady <adylo811517> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | enhancement | CC: | andreas.heinisch, stephane.guillou |
Priority: | medium | ||
Version: | 7.6.0.0 alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=104487 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 105582 |
Description
ady
2023-05-15 11:10:37 UTC
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"). |