Description: In Libre Office CALC version 5.4 and also 6.03.2 with the DUTCH language pack installed, the DATUMVERSCHIL (English: DATEDIFF) does not work. It seems that the proper function syntax is; DATUMALS. I think that the translation from DATEDIFF is misspelled as DATE IFF, which means in dutch; DATUM ALS. In the several help files and all the other info on the WWW, the function is noted as DATUMVERSCHIL or in English DATEDIFF and not DATUMALS. Is this as I suggested a translation error or work as designed? Kind regards, Cor de Boer The Netherlands Steps to Reproduce: 1.Installed Dutch Language pack 2.use function: =datumverschil("01-03-2018";"01-05-2018";"d") 3.#NAAM? Actual Results: #NAAM? (In English: #NAME?) Expected Results: 61 Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: DATUMVERSCHIL Deze functie geeft het aantal gehele dagen, maanden of jaren terug tussen een Begindatum en een Einddatum. Syntaxis DATUMVERSCHIL(Begindatum; Einddatum; Interval) Begindatum is de datum van waar de berekening wordt uitgevoerd. Einddatum is de datum tot waar de berekening wordt uitgevoerd. De Einddatum moet later dan de Begindatum zijn. Interval is tekenreeks, toegelaten waarden zijn "d", "m", "j", "jm", "md" or "jd". Waarde voor "Interval" Teruggeven waarde "d" Aantal gehele dagen tussen de Begindtum en Einddatum. "m" Aantal gehele maanden tussen Begindatum en Einddatum. "j" Aantal gehele jaren tussen Begindatum en Einddatum. "jm" Aantal gehele maanden wanneer de jaren afgetrokken worden van het verschil tussen Begindatum en Einddatum. "md" Aantal gehele dagen wanneer de jaren en maanden afgetrokken worden van het verschil tussen Begindatum en Einddatum. "jd" Aantal gehele dagen wanneer de jaren afgetrokken worden van het verschil tussen Begindatum en Einddatum. Voorbeeld Verjaardag berekening. Een man werd geboren op 17-04-1974. Vandaag is het 13-06-2012. =DATEDIF("1974-04-17";"2012-06-13";"y") geeft 38. =DATEDIF("1974-04-17";"2012-06-13";"ym") geeft 1. =DATEDIF("1974-04-17";"2012-06-13";"md") geeft 27. Hij is dus 38 jaar, 1 maand en 27 dagen oud. =DATUMVERSCHIL("17-04-1974";"13-06-2012";"m") geeft 457, hij leeft dus reeds 457 maanden. =DATUMVERSCHIL("17-04-1974";"13-06-2012";"d") geeft 13937, hij leeft dus reeds 13937 dagen. =DATUMVERSCHIL("17-04-1974";"13-06-2012";"jd") geeft 57, zijn verjaardag was 57 dagen geleden. User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Hi Cor, Confirm this change (DATUMVERSCHIL > DATUMALS) since LO 5.4.0.0.alpha1 Build ID: 0b9f9bef65bb21ebb6a64aafad448f7f62dc824a CPU-threads: 2; Besturingssysteem:Windows 6.1; UI-render: standaard; Locale: nl-NL (fr_FR); Calc: CL
And also effects the Linux_x86-64_deb version, which I use.
I made the change here: https://translations.documentfoundation.org/nl/libo_ui/translate/formula/messages.po#unit=138427022
HI Olivier, Can you have a look here and precise the needs for change this part of Dutch local Help. Thank you.
The DATEDIF function must keep the strings "d", "m", "y", "ym", "md" or "yd" as is, in English. These strings must not be localized. The help page must be corrected for the Dutch locale. I can't make any opinion on the localized name for the DATEDIF function. https://help.libreoffice.org/6.1/nl/text/scalc/01/func_datedif.html
@Cor: Can you send a message on the Dutch lists to report them the problem?
Telesto, Can you examine this bug report and tell if you can inform the persons concerned by translation in your local Help? Thank you.
Dear Cor, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from 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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Current Version: 6.2.3.2 Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac I think the DATUMVERSCHIL issue was already fixed is in the earlier 6.x versions. It certainly works correct in Versions: 6.2.0 and 6.2.3 I hope this will help you. Kind regards, Cor de Boer
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.