The functions listed here have different names if you tick "Use English function names" under Options. Function > with Option on ------------------------------ EFFECT() > EFFECTIVE() COLOUR() > COLOR() STANDARDISE() > STANDARDIZE() All other function names are translated correctly. It should be standardized.
(In reply to Jürgen Kirsten from comment #0) > It should be standardized. could you clarified what you expect ? (from German translation ?) p.s. see the full list of functions from https://ask.libreoffice.org/t/calc-list-of-changed-functions-with-the-language/54286/3
Confirmed ``` DURATION PDURATION DURATION_ADD DURATION EFFECT EFFECTIVE
ps. with Version: 25.2.5.2 (AARCH64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Flatpak Calc: threaded steps to reproduce: open latest document from #93992 switch off []English function names switch on [x]English function names compare Column B and Column D see also attached file with the fixed output from D
Created attachment 202164 [details] document with compared expectet and real functionnames
still unclear what you expect. now you mention PDURATION and DURATION as a fix ? of what ?
(In reply to fpy from comment #1) > (In reply to Jürgen Kirsten from comment #0) > > It should be standardized. > > could you clarified what you expect ? (from German translation ?) > > p.s. > see the full list of functions from > https://ask.libreoffice.org/t/calc-list-of-changed-functions-with-the- > language/54286/3 Hi fpy, this actually has nothing to do with the German translation. Even if you work in the English working environment and also use the option 'Use English function names', the three functions are renamed. If you go to the English help, the functions are called: EFFECT(), COLOUR(), STANDARDISE(). That they are renamed to EFFECTIVE(), COLOR() (without U), STANDARDIZE() (with Z instead of S) when using the option 'Use English function names' is, in my opinion, a mistake. While researching, I also noticed that searching for COLOUR (Function) in the help does not return any hits. The search for COLOR (Function), on the other hand, works. It leads to a page with color.html in the URL but with the syntax of the COLOUR() function. I hope this has helped you to understand.
(In reply to Jürgen Kirsten from comment #6) > If you go to the English help ahhhhh! !!! so, you mean here : https://help.libreoffice.org/latest/en-US/text/scalc/01/04060103.html https://wiki.documentfoundation.org/Documentation/Calc_Functions/EFFECT ok for EFFECT, seems it should be EFFECTIVE. Can you spot *precisely* where you see the others ? e.g COLOR is correct : https://help.libreoffice.org/latest/en-US/text/scalc/01/func_color.html?DbPAR=CALC#bm_id1102201617201921
(In reply to fpy from comment #7) > (In reply to Jürgen Kirsten from comment #6) > > > If you go to the English help > > ahhhhh! !!! > so, you mean here : > https://help.libreoffice.org/latest/en-US/text/scalc/01/04060103.html > https://wiki.documentfoundation.org/Documentation/Calc_Functions/EFFECT > > ok for EFFECT, seems it should be EFFECTIVE. > > Can you spot *precisely* where you see the others ? > e.g COLOR is correct : > https://help.libreoffice.org/latest/en-US/text/scalc/01/func_color. > html?DbPAR=CALC#bm_id1102201617201921 OK my mistake was that I installed the en-GB and not the en-US working environment. I have fixed that now. The described error only occurs with EFFECT(). The differences in the other two functions are due to different names in English (GB vs. US). In my opinion, this could also be harmonised, but it is a translation error and not a bug.
According to the ODF 1.4 standard, the name of the function is EFFECT. https://docs.oasis-open.org/office/OpenDocument/v1.4/OpenDocument-v1.4-part4-formula.html#__RefHeading__1018268_715980110 -> WONTFIX.
The secondary English function name is indeed still EFFECTIVE and should be changed to EFFECT to match the en-US and ODF name.
(In reply to Jürgen Kirsten from comment #8) > The differences in the other two functions are due to different > names in English (GB vs. US). In my opinion, this could also be harmonised, > but it is a translation error and not a bug. That is not an error, that is a spelling difference between en-US and en-GB.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/2f03e115d156ed122d9e92d6c7f722a8599edf01 Resolves: tdf#167794 Rename secondary English function EFFECTIVE -> EFFECT It will be available in 26.2.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/+/189128 for 25-8
(In reply to Eike Rathke from comment #11) > That is not an error, that is a spelling difference between en-US and en-GB. any suggestion for https://wiki.documentfoundation.org/Documentation/Calc_Functions/EFFECT ? and this one should be fixed : https://help.libreoffice.org/latest/en-GB/text/scalc/01/04060103.html
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/6600793f1e5a82a95c967951958ef6b78b16c24f Resolves: tdf#167794 Rename secondary English function EFFECTIVE -> EFFECT It will be available in 25.8.1. 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.
(In reply to fpy from comment #14) > any suggestion for > https://wiki.documentfoundation.org/Documentation/Calc_Functions/EFFECT ? What about? > and this one should be fixed : > https://help.libreoffice.org/latest/en-GB/text/scalc/01/04060103.html What should be fixed?
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/0e69bf63d4e355c7d4876511180d0eec1cb2b9f7 Resolves: tdf#167794 Rename secondary English function EFFECTIVE -> EFFECT It will be available in 25.2.6. 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.
(In reply to Eike Rathke from comment #16) > (In reply to fpy from comment #14) > > any suggestion for > > https://wiki.documentfoundation.org/Documentation/Calc_Functions/EFFECT ? > What about? I guess "... spelling difference between en-US and en-GB" and more generally the formal reference to translated function names. this one is the only I heard of : https://ask.libreoffice.org/t/calc-list-of-changed-functions-with-the-language/54286/3
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-25-8-0": https://git.libreoffice.org/core/commit/b402158ed1c2b565e92546108cee74ebaa7aad03 Resolves: tdf#167794 Rename secondary English function EFFECTIVE -> EFFECT It will be available in 25.8.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.