<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WONTFIX - TRANSLATION: DATEDIF (Date difference) calc function translated as SIFECHA, can leads to mistake, FECHADIF looks more accurated" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128126#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WONTFIX - TRANSLATION: DATEDIF (Date difference) calc function translated as SIFECHA, can leads to mistake, FECHADIF looks more accurated" href="https://bugs.documentfoundation.org/show_bug.cgi?id=128126">bug 128126</a> from <a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> m.a.riosv</a> <pre>(In reply to Adolfo Jayme from <a href="show_bug.cgi?id=128126#c7">comment #7</a>) > 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.” > > <a href="https://books.google.com/books?id=9mqg1CZRLdsC&pg=PA86">https://books.google.com/books?id=9mqg1CZRLdsC&pg=PA86</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>