https://bugs.freedesktop.org/show_bug.cgi?id=69569
Lionel Elie Mamane <lio...@mamane.lu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kyosh...@slickedit.com,
| |libreoff...@kohei.us,
| |markus.mohrhard@googlemail.
| |com
--- Comment #4 from Lionel Elie Mamane <lio...@mamane.lu> ---
(In reply to comment #3)
> (In reply to comment #2)
> > Note: I have checked the modifications made by Lionel Elie Mamane...
> > It appears as if this modification makes LibreOffice consistent with the
> > documentation BUT not consistent with Excel's implementation of YEARFRAC.
>
> It looks like we have two choices here
> 1) Change our code to become consistent with Excel's implementation
> 2) Document the difference, e.g. on
> https://help.libreoffice.org/Calc/YEARFRAC
>
> Lionel - Thoughts?
I will not, under my decision / responsibility, make LibreOffice Calc depart
from the ODF standard. Whether the ODF standard should be "fixed" to match
Excel, or if the YEARFRAC option should be a different function in .ods files
and in .xls(x) files is a question I punt to the Calc experts.
I consider authoritative ODF 1.2
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017922_715980110
as opposed to
https://www.oasis-open.org/committees/document.php?document_id=39507
I came into bug 40100 as a *user* because LibreOffice was giving me wrong
results for an "obvious" case like
"=YEARFRAC(DATE(2023;1;1);DATE(2024;1;1);1)", so I fixed it. As long as I'm
able to get sane results fom my LibreOffice in some way, I don't care much
about Excel compatibility. I mean: if Excel gives results that are "wrong",
then either give correct results in LibreOffice, or have "basis 5" be the
"right result" in LibreOffice, so that I can do
"=YEARFRAC(DATE(2023;1;1);DATE(2024;1;1);5)" and get the result I expect. But
don't cripple my LibreOffice for the sake of Excel compatibility.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
