[Libreoffice-bugs] [Bug 128126] TRANSLATION: DATEDIF (Date difference) calc function translated as SIFECHA, can leads to mistake, FECHADIF looks more accurated

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128126

--- Comment #9 from m.a.riosv <miguelangelrv at libreoffice.org> ---
(In reply to Adolfo Jayme from comment #7)
> To expand a little further—
> 
> Citation from Sánchez, C. (2008), Excel 2007: Guía de funciones. Argentina:
> USERS/Gradi, S.A., p. 86 (translation from Spanish mine):
> 
> “[The SIFECHA] function is so little-known that even its name is the product
> of a misunderstanding. The English name is DATEDIF, difference between
> dates. But whomever translated Excel into Spanish just looked at the ‘IF’ at
> the end (‘si’ in Spanish), and thus termed the function like so.”
> 
> https://books.google.com/books?id=9mqg1CZRLdsC&pg=PA86

Here we are with another msoffice bug mantained on LibreOffice for
compatibility purposes.

As there are several SI (IF) functions, only can leads to mistakes or not being
found/used while it can be. Looks like a function to verify the value is a
date.

I think a little explanation would be nice in the help, to make it easier to
find the function in Spanish.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200511/099cf4d9/attachment.htm>