[Libreoffice-bugs] [Bug 155316] Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
https://bugs.documentfoundation.org/show_bug.cgi?id=155316 ady changed: What|Removed |Added CC||andreas.heini...@yahoo.de Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #2 from ady --- 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"). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 155316] Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
https://bugs.documentfoundation.org/show_bug.cgi?id=155316 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO Whiteboard| QA:needsComment| --- Comment #1 from Stéphane Guillou (stragu) --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 155316] Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
https://bugs.documentfoundation.org/show_bug.cgi?id=155316 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 155316] Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
https://bugs.documentfoundation.org/show_bug.cgi?id=155316 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||105582 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=105582 [Bug 105582] [META] Function wizard dialog bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 155316] Function Wizard should remember the Category field selection from its prior use, at least per session (RFE)
https://bugs.documentfoundation.org/show_bug.cgi?id=155316 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||4487 -- You are receiving this mail because: You are the assignee for the bug.