Version: 5.0.4.2 (x64) Build-ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Gebietsschema: de-DE (de_DE) use some non-English interface. Tools --> Options --> Calc --> Formula --> Check Use English Formula names Restart LibO Try to use =GCD_ADD(5;15;25) from the help https://help.libreoffice.org/Calc/Mathematical_Functions#GCD_ADD In German environment you have to use =GGT_ADD(99;102;105) Nasty bug.
Repro. Win 7 64-bit Versio: 5.1.0.3 (x64) Käännöksen ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Maa-asetus: fi-FI (fi_FI)
@Winfried somehow in IRC chat with Eike we realized that this report seem to be a duplicate of Bug 50118. But you resolved the other bug? I will check later which functions do not work. BTW: I do use Windows 10Pro x64
(In reply to Dennis Roczek from comment #2) > @Winfried somehow in IRC chat with Eike we realized that this report seem to > be a duplicate of Bug 50118. But you resolved the other bug? I remember one or two remaining problems, and saw that these are in comments 11 and up in bug 50118. As you use Windows, and I could only reproduce the problem with Windows, not with Linux, it seems that you also came across this problem. I do not have a clue what the cause may be, but I think it will be better to treat this as a separate bug, as bug 50118 was about the fact that Add-In functions were never set to English.
OK, I have checked the functions names a bit more. The ones marked with a star might be also called in Engl. UI so. ABS AUFGELZINS AUFGELZINSF AUSZAHLUNG BRTEILJAHRE EDATUM* EFFEKTIV_ADD GAUSSFEHLER GAUSSFKOMPL GCD GGANZZAHL GGT_EXCEL2013 IMAGINÄRTEIL IMARGUMENT IMKONJUNGIERT IMPRODUKT IMREALTEIL IMWURZEL IPMT* ISPMT* IStGERADE_ADD ISTSCHALTJAHR ISTUNGERADE_ADD JAHRE KALENDERWOCHE_EXCEL2003 KGV_EXCEL2003 KOMPLEXE KUMKAPITAL_ADD KUMZINSZ_ADD KURS KURSDISAGIO KURSFÄLLIG KURT LAUFZEIT_ADD MDETERM* MIRR* MONATE MONATSENDE NETTOARBEITSTAGE_EXCEL2003 NOTIERUNGBRU NOTIERUNGDEZ NPV PERMUT PERMUTATIONA PMT POTENZREIHE PPMT RENDITE RENDITEDIS RENDITEFÄLL TAGEIMJAHR TAGEIMMONAT TBILLÄQUIV TBILLKURS TBILLRENDITE UMRECHNEN_ADD UNREGERKURS UNREGERREND UNREGLEKURS UNREGLEREND VRUNDEN WOCHEN WOCHENIMJAHR WURZELPI XINTZINSFUSS XKAPITALWERT ZINSSATZ ZINSTERMNZ ZINSTERMTAGE ZINSTERMTAGNG ZINSTERMTAGVA ZINSTERMVZ ZINSTERMMZAHL ZUFALLSBEREICH ZW2 ZWEIFAKULTÄT (missing some!) As you can see, many are from the Date&Time and Finance, some from Mathematic (the _Excel2003 ones) and all from the Add_ins category I will do some more analysis. @beluga can you check which ones (ideal with English names) do not work on your machine / language?
Now I realized =GCD_ADD(5;15;25) does not work even in an English (US) interface. Same result with =LCM_ADD(5;15;25) =WEEKNUM_ADD(24.12.2001;1) =EFFECT_ADD(0.0525;4) =DURATION_ADD("2001-01-01";"2006-01-01";0.08;0.09;2;3) =YEARS(12.12.2004;12.12.2014;1) =WEEKSINYEAR(12.12.2004) =WEEKS(12.12.2004;12.12.2014;1) =ROT13(text) =MONTHS(12.12.2004;12.12.2014;1) =ISLEAPYEAR(12.12.2004) =DAYSINYEAR(12.12.2004) =DAYSINMONTH(12.12.2004) Win 7 Pro 64-bit, Version: 5.1.0.3 (x64) Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Locale: fi-FI (fi_FI)
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.5 or 5.3.0 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170306
meh, still REPRO with Version: 5.3.0.3 (x64) Build-ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1 CPU-Threads: 4; BS-Version: Windows 6.19; UI-Render: Standard; Layout-Engine: neu; Gebietsschema: de-DE (de_DE); Calc: group
I Agree it. In my LO 5.4.7 Still version (updated from LO 5.4.6, and that version was not tested) some function names are German - even in localised (Hungarian) or "English function names" state of the settings. For example there are such function names: VRUNDEN( ) WURZELPI( ) ZUFALLSBEREICH( ) The User profile is located in a folder named .../4/..., because it is inherited from the version 4.4.7. (The LO 5.4.6 version was not installed by a clean istall.) I just renamed the user profile folder to "user_old". The software just created a new one at the next launching, and the issue is gone... (and my customized settings, and macros are gone too, of course... but I can fix them.)
Arghhh... Yes, the issue is gone... in the Localized state. But it appeared again when I switched to English function names.
I am trying to find out what goes wrong. The Add-In code is complex, mostly made to achieve interoperability with weird (obsolete) Excel behaviour, so it may take a while before I even know if I might be able to fix it. The fact that I cannot reproduce it on Linux platforms (yet) further complicates the matter.
I managed to set up a -temporary- Windows development environment (Windows10pro) and completed an build of current master. Neither with locale nl_NL, nor with locale de_DE have I been able to reproduce the problem. This is what I do: * in Tools - Options - Language Settings I set both User interface and Locale setting to Dutch or German; * in Tools - Options - Libreofficedev Calc - Formula I disable Use English function names; * I restart LibreOffice; * all function names (including Add-In) are locale function names; * in Tools - Options - Libreofficedev Calc - Formula I enable Use English function names; * I restart LibreOffice; * all function names (including Add-In) are English function names. (The same is the case with LibreOffice 6.0.5.1 and Windows10Pro.) What steps are needed to reproduce the problem?
> What steps are needed to reproduce the problem? @Dennis Roczek, could you please provide the info requested by Winfried?
I have permanently installed the LO 5.4.7. (It is not a portable version.) It was installed by the Hungarian language installer file. I often use the English user interface (for the English OpenOffice/LibreOffice forum), but in these cases the locale settings still Hungarian im my office suite... The attached picture shows: When I switch the office suite to English user interface, and the Calc function names to English, then some German function names appeared. https://drive.google.com/file/d/1JD8AUJ5tSonHN6VxcGuwsDs2Hlcws7Rn/view?usp=sharing
(In reply to Tibor Kovács from comment #13) > I have permanently installed the LO 5.4.7. (It is not a portable version.) > It was installed by the Hungarian language installer file. > I often use the English user interface (for the English > OpenOffice/LibreOffice forum), but in these cases the locale settings still > Hungarian im my office suite... > The attached picture shows: When I switch the office suite to English user > interface, and the Calc function names to English, then some German function > names appeared. > > https://drive.google.com/file/d/1JD8AUJ5tSonHN6VxcGuwsDs2Hlcws7Rn/ > view?usp=sharing I do not doubt the problem exists, I need to know how to reproduce the problem. Can you tell me what your settings are in the Languages tab and give me a step by step account of how you set the formula names to Hungarian and to English, with the results of each step? That way I can try to reproduce the problem and start debugging.
"Can you tell me what your settings are in the Languages tab and give me a step by step account of how you set the formula names to Hungarian and to English, with the results of each step?" I just repeated the test. Here is a short desctription with some illustrations in an .odt file: https://drive.google.com/file/d/1LSsAfShM0Bq2uCKaVKmLR7jAKO2EPQ0k/view?usp=sharing -
(In reply to Tibor Kovács from comment #15) > I just repeated the test. Here is a short desctription with some > illustrations in an .odt file: > https://drive.google.com/file/d/1LSsAfShM0Bq2uCKaVKmLR7jAKO2EPQ0k/ > view?usp=sharing Thank you for your extensive description. The first I learned from it was that to reproduce the problem you not only set 'Use English function names' but also change the user interface language. I added Hungarian to my LO 6.0.5 installation, removed my user profile and set up my user interface to Hungarian, as in your step 2. With me, there is no „Alapértelmezett” in front of "Magyar" as I did not set my Windows user interface to Hungarian. I followed your steps, except that after step 7 I accepted the message from LO to restart the application with the new user interface. You did not mention this in your description, but I assume you did the same as I did. But your step 8 does not reflect my situation; I still have 100% English function names. Although you may think your efforts were wasted (still no reproduction of the problem), you have introduced an aspect that I hadn't studied before, i.e. the changing of the user interface, with a different locale than the user interface (step 7 has English UI, and Hungarian locale). I will try to reproduce the problem with different settings for user interface and locale. (I added you to the CC-list of this bug report to make communication easier.)
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20190111
The problem is not raised in my 32 bit LibreOffice 6.1.4 on Windows7 prof. x64 op. sys. It was a clear installation: I deleted the User profile, and the rest parts of LO installation from the Program Files (x86) after uninstalling of the previous version.
Great, let's close.