Description: The behavior is only noticeable when you switch on yourself. When the document is simply opened, everything looks perfectly normal and correct. After switching to the English function names you will have the English function names for some functions and the German function names for others. Saving does not change anything at all. Only after closing LibreOffice completely and reopening the document (or creating a new one), all function names are translated. Steps to Reproduce: 1. Create a Calc document under German working environment and use the function UMRECHNEN()in (English CONVERT()). 2. Use in the menu under Tools - Options - LibreOffice Calc - Formulas - English function names 3. Note that the function is not translated ad hoc. 4. Save your document, close Libre Office completely and then open your document again 5. The function has now been translated from UMRECHNEN() to CONVERT() Actual Results: Some functions are not translated ad hoc but only after the restart. Others are translated immediately. Expected Results: Either all functions should be translated immediately, or there should be a prompt to restart. Reproducible: Always User Profile Reset: Yes Additional Info: A whole range of functions are affected. I've identified 86. For example: =MROUND( ), =WEEKSINYEAR( ), =ACCRINT( ) to name a few. I have already discovered a related bug here. But this one does not describe exactly the same bug. https://bugs.documentfoundation.org/show_bug.cgi?id=93371
Confirming the behavior for Version 6.4.6.2 (x64), Win10 (2004) and Version 6.4.4.2 (Ubuntu 20.04). In addition to the mentioned Steps to reproduce, after step 3, before step 4: Create a new calc-document. You have to use mixed-names even in the new document, for example =ISTSCHALTJAHR(TODAY())
Confirming with Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 70860345da26c5c0303e01f9d6fb93276b38aea1 CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (en_US.UTF-8); UI: de-DE Calc: threaded SQRT <-> WURZEL works nicely but UMRECHNEN <-> CONVERT does not
As most problems around this topic (switching to English function names) there are all functions affected that are implemented as AddIn.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/28c4c72a4e81821d9e567757725937f74a6d114f Related: tdf#135993 Destroy temporary OpCodeMap when reading config 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0a78f11fdd13d914d5f063007b2df9796e6dce9d Related: tdf#135993 Use ScCompiler to create English OpCodeMap with AddIns 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.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d778c6fd5c2ba8e27df46ec9e183a61ad29e30d5 Resolves: tdf#135993 Create ScFunctionList and ScFuncDesc with English names 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.
I have tested in the following version. After switching to English function names, all names are translated ad hoc. Very good. Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: a56705efdbe9ceb0f5bb92d1d8bb2cefbc03f3ac CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/33c8c9d0dc8e76bc7dacb92175047a89f7d39a3c Use CharClass::uppercase() for AddIns' English UI names, tdf#135993 follow-up 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.
Pending review https://gerrit.libreoffice.org/c/core/+/139229 for 7-4
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/32019fae7730fc8d94f14d47ebaccbdc6775340a Resolves: tdf#135993 Create ScFunctionList and ScFuncDesc with English names It will be available in 7.4.2. 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.