Is there a reason to have/keep an accent mark in Calc function names in the Spanish locale or could it be removed?
E.g.: DÍA, DÍASEM, MÁX, MAYÚSC, MÍN, etc.
Because the biggest competitor (Excel) doesn't use it - see (in Spanish) https://support.office.com/es-es/article/Funciones-de-Excel-por-orden-alfab%C3%A9tico-b3944572-255d-4efb-bb96-c6d90033e188
And Apache OO apparently removed it in version 4.0.1, too - see (in Spanish) http://blog.open-office.es/calc/cambios-importantes-en-las-funciones-de-openoffice-4-0-1-calc
So that it might be good to standardize.
This needs feedback from Spanish locale users, though. I'm just suggesting it.
Another point for removal would be that the accent mark doesn't seem to be used consequently (according to the online help). E.g., following functions don't use it:
DIA.LAB, DIAS.LAB, RAIZ2PI (but RAÍZ), MULTIPLO.SUPERIOR.ISO/EXACTO (but MÚLTIPLO.SUPERIOR), etc.
Sounds like a question for the l10n team. The question is in fact how native speakers deal with accents or diacritic characters. I guess its a WONTFIX.
(Wonder if firstname.lastname@example.org would make sense as CC)
Thanks for feedback! But please note that this refers to the accent mark only (not "ñ", which is also used in function names, but equally to, e.g., Excel). Also, it refers only to the Spanish locale (I'm personally not familiar with the other languages using the question mark).
This is intended as alignment to other spreadsheet implementations, in the spirit of the changes already made in LO from time to time. E.g.,
Other implementations aligned to Excel with respect to not using the accent mark in spreadsheet function names in the Spanish locale are Apple Numbers (https://www.apple.com/es/mac/numbers/compatibility/) and Google Spreadsheet (https://support.google.com/docs/table/25273?hl=es).
Yeah, some people in the Spanish localization mailing list also suggested that we do it, so I’m doing that now.
(In reply to Adolfo Jayme from comment #4)
> Yeah, some people in the Spanish localization mailing list also suggested
> that we do it, so I’m doing that now.
Thank you very much for that!
I'm adding "target:5.3.0" for future reference. Please feel free to append/correct as needed.
P.S.: We might have a new record on the quickest resolved enhancement request here. :)
Hi, so I'm gonna ask on the l10n list because it seems that several languages are using accents in function name. I would suggest to remove them unless it really changes the meaning of the word in the context (that's what I've done for French, we don't use accents in function names). Sophie
I assume that the current "master" translation branch will also be part of the future LO 5.2.3, so added "target:5.2.3" as well.
(It looks like it won't be in LO 5.2.2 because that has already been branched off - see https://github.com/LibreOffice/translations/branches )
I've added a note about this change to the release notes of LO 5.2 and also 5.3 - see https://wiki.documentfoundation.org/ReleaseNotes/5.2#Localization and https://wiki.documentfoundation.org/ReleaseNotes/5.3#Localization
(I added it to *both* versions, because the change will first appear in between of them - in the minor version 5.2.3 -, due to translation branch handling processes.)
Thank you very much, Johnny! :-)