Bug 146763

Summary:	LOCALHELP: Interval argument help in Spanish for DATEDIF (SIFECHA) function
Product:	LibreOffice	Reporter:	LeroyG <iavs.leroy>
Component:	Localization	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	79045_79045, serval2412, xiscofauli
Priority:	medium
Version:	7.1.8.1 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Spanish function wizard screenshot for DATEDIF

Description LeroyG 2022-01-14 14:51:03 UTC

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

Comment 1 LeroyG 2022-01-30 00:11:42 UTC

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

Comment 2 LeroyG 2022-01-30 00:13:17 UTC

See related question (in Portugues do Brasil category of ask.libreoffice.org): https://ask.libreoffice.org/t/funcao-datadif-erro/70667

Comment 3 Roman Kuznetsov 2022-05-02 13:21:09 UTC

Xisco, could you please confirm it if it is?

Comment 4 LeroyG 2022-05-03 11:16:07 UTC

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

Comment 5 LeroyG 2022-05-27 13:13:03 UTC

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

Comment 6 Julien Nabet 2023-06-28 08:33:32 UTC

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")

Comment 7 Julien Nabet 2023-06-28 08:38:30 UTC

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»."