Description: There is a bug(?) related to the Add-in functions in LO 7.x.y versions... In a localized (Hungarian in this case) LO installation appears the CompatibilityName instead of the displayed names (if if they are localized or not) in the formula wizzard (in the list of the functions) - when I set the “language” of the Formulas back to “English”. When that option is not set, then the names are right, even if the Addin has NOT contain localised versions of the Displayed names for the functions.) It worked fine in the LO 6.x.y versions: always appeared the Displayed names. Checked in LO 7.4.5, LO 7.5.1. and LO 6.4.7 with Mike Kagansky's test extension named PyFloatToHex.oxt https://ask.libreoffice.org/t/convert-decimal-to-ieee745/89709/15 (Same issue with the test of Add-in named DoobieDoo): https://wiki.openoffice.org/wiki/Calc/Add-In/Python_How-To Steps to Reproduce: 1. Install the Add-in extension, and restart the LO. 2. try to insert one of the new Cell functions into a cell by usage of the Function Wizzard. 3. The Function Wizzard of the LO 7.x.y version shows different names in the unchecked/checked state of the "English" option: Displayed name/Compatibility name of the new functions. Actual Results: In the LO 7.x.y version is appeared the CompatibilityName instead of the Displayed name, when the "English function names" option is checked. The LO 6.4.7 works fine for me. Expected Results: Always must be appeared the Displayed Name. Reproducible: Always User Profile Reset: No Additional Info: Easy Workaround: if you know and remember the Compatibility Name and the Displayed Name, then you can type-in that actually works - depended on the state of the Formula language option.
Created attachment 186439 [details] Add-in function names when the "English function names is checked.
Created attachment 186440 [details] Add-in function names when the "English function names" is not checked.
Meh.. current implementation works fine with the compatibility names provided by our internal Add-Ins. But we should try to obtain English localized DisplayName first and only fall back to English CompatibilityName.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/632fdbb7fb9fd296aaa4c473070aecc3c0dd019c Resolves: tdf#154582 Obtain English DisplayName before CompatibilityName 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.
Pending review https://gerrit.libreoffice.org/c/core/+/149976 for 7-5
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/c3ab1cb764a368a8b2642e73c744dee9282cfd4b Resolves: tdf#154582 Obtain English DisplayName before CompatibilityName It will be available in 7.5.3. 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.