Description: When searching in function wizard, Calc search only in function names. Search also in description, it should help find correct function. Searching in description can be optional. Steps to Reproduce: 1.open calc 2.function wizard 3.enter string to search field Actual Results: Search only names of functions Expected Results: Search description too Reproducible: Always User Profile Reset: No Additional Info: .
Created attachment 177562 [details] example - prinrscreens
Agree
Created attachment 181129 [details] Search always in the description
As shown in the attachment, should we always search in the description, or just if we don't find any match in the function name?
To better understand: if I search for SUM, the windows shows me DEVSQ, DSUM, etc. and from a user perspective I would expect SUM first.
Created attachment 181130 [details] Older LO versions don't have any order So I think searching in the descritpion to should be fine. Raal what did you mean with can be optional? Should we insert a flag or something?
(In reply to Andreas Heinisch from comment #6) > Created attachment 181130 [details] > Older LO versions don't have any order > > So I think searching in the descritpion to should be fine. Raal what did you > mean with can be optional? Should we insert a flag or something? I thought add new checkbox "search in description too", but maybe it's too complicated in UI. If you add function names which contains search string at top and then functions, where search string is in the description after, IMHO it's clear. Thank you for taking the bug.
(In reply to Andreas Heinisch from comment #5) > To better understand: if I search for SUM, the windows shows me DEVSQ, DSUM, > etc. and from a user perspective I would expect SUM first. I think we should search in the function names list and then add search results from description
The list of the functions is sorted, so either we disable the sorting for the searching proccess or we just include every function which contains the search string and keep the list sorted, for instance, search for "sum" leads to: DEVQSUM DSUM IMSUM ... SUM ... Not sure which solution is correct. We could even make the list unsorted for the search process, then create two sorted lists (one with the keyword in the titel one within the description) and then add both to the non sorted list. If the user changes something (changes a category, deletes the search input) the list could be sorted again. Imho, the easiest to understand change is to search in both title and description and show them in the sorted list.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bb4314aa21baec08268e0f02b816a8cf05096ceb tdf#146781 - Function wizard: search desired function also in the description It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Great feature! Verified with Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 5c68399e6bea3aa18477487400f8bb143d6ed84e CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Added to the release notes: https://wiki.documentfoundation.org/index.php?title=ReleaseNotes%2F7.5&type=revision&diff=594069&oldid=593791 Thanks Andreas!
Stéphane Guillou committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/826b1f36bd96328e198452e0f8d5c87b2f3fb203 tdf#146781 sc: update extended tip for function description search It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Stéphane Guillou committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/403909906c14483b310a6245a1b897f1e008d06b tdf#146781 sc: update extended tip for function description search It will be available in 7.5.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.