Description: The Function Wizard (Asistente de funciones, Ctrl+F2) and the tooltip (activated with Tools - AutoInput) for DATEDIF (SIFECHA) for the user interface Spanish (Spain) shows wrong info for the interval argument (intervalo; third argument). Steps to Reproduce: 1. Open Calc 2. Set user interface to Spanish (Spain) (interfaz de usuario: Español (España)) 3.a. Type "=SIFECHA(A1;A2;" 3.b.1. Open the Function Wizard 3.b.2. Search for SIFECHA 3.b.3. Put the cursor in Intervalo field. Actual Results: After 3.a. or 3.b.3. tooltip and help shows: … : Intervalo que calcular. Puede ser «d», «m», «a», «am», «md», «ad». Expected Results: … : Intervalo que calcular. Puede ser «d», «m», «y», «ym», «md», «yd». Reproducible: Always User Profile Reset: No Additional Info: It is correct at: https://help.libreoffice.org/latest/es/text/scalc/01/func_datedif.html See: https://ask.libreoffice.org/t/datad-se-sera-bug/72688 Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 1; OS: Linux 4.12; UI render: default; VCL: x11 Locale: es-MX (es_AR.UTF-8); UI: es-ES Calc: threaded
Reproducible in Version: 7.1.8.1 (x64) / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: es-MX (es_ES); UI: es-ES Calc: CL
See related question (in Portugues do Brasil category of ask.libreoffice.org): https://ask.libreoffice.org/t/funcao-datadif-erro/70667
Xisco, could you please confirm it if it is?
Created attachment 179900 [details] Spanish function wizard screenshot for DATEDIF Version: 7.3.2.2 (x86) / LibreOffice Community Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: es-ES Calc: threaded
Reproducible with: Version: 7.4.0.0.alpha1 (x86) / LibreOffice Community Build ID: b871abad383583f02eb49c7e49aeae01f6941072 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: es-MX (es_MX); UI: es-ES Calc: threaded
I gave a try on with one with French UI and it's indeed: «d», «m», «y», «ym», «md», «yd» Eike: since the functions can (depending if we use formula in English or UI language) be localized should this parameter be localized too? eg in French: «j», «m», «a», «am», «mj», «aj» ("d"/"day" => "j"/"jour" "y"/"year" => "a"/"année")
Code pointer: sc/messages.po 4746 #. BqQrQ 4747 #: sc/inc/scfuncs.hrc:362 4748 msgctxt "SC_OPCODE_GET_DATEDIF" 4749 msgid "Interval to be calculated. Can be \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\"." 4750 msgstr "Intervalo que calcular. Puede ser «d», «m», «a», «am», «md» o «ad»."