Bug 154582 - Add-in function names appears as "Compatibility names" in "English function names" state of the Calc setting.
Summary: Add-in function names appears as "Compatibility names" in "English function n...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium minor
Assignee: Eike Rathke
URL:
Whiteboard: target:7.6.0 target:7.5.3
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-03 13:36 UTC by Tibor Kovács
Modified: 2023-04-07 16:47 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Add-in function names when the "English function names is checked. (73.83 KB, image/png)
2023-04-03 13:40 UTC, Tibor Kovács
Details
Add-in function names when the "English function names" is not checked. (75.07 KB, image/png)
2023-04-03 13:41 UTC, Tibor Kovács
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tibor Kovács 2023-04-03 13:36:04 UTC
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.
Comment 1 Tibor Kovács 2023-04-03 13:40:34 UTC
Created attachment 186439 [details]
Add-in function names when the "English function names is checked.
Comment 2 Tibor Kovács 2023-04-03 13:41:24 UTC
Created attachment 186440 [details]
Add-in function names when the "English function names" is not checked.
Comment 3 Eike Rathke 2023-04-03 15:12:25 UTC
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.
Comment 4 Commit Notification 2023-04-03 19:22:49 UTC
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.
Comment 5 Eike Rathke 2023-04-03 19:23:39 UTC
Pending review https://gerrit.libreoffice.org/c/core/+/149976 for 7-5
Comment 6 Commit Notification 2023-04-07 16:47:07 UTC
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.