https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #5 from Christian Fries <em...@christian-fries.de> --- Maybe I would like to add that the ACT/ACT implementation of Excel AND LibreOffice is wrong - in the sense that is does not agree with the (most popular) ISDA definition of ACT/ACT. I would vote for including new „basis“ definitions and have basis 4 be the ACT/ACT EXCEL. Am 03.07.2014 um 17:47 schrieb bugzilla-dae...@freedesktop.org: > Lionel Elie Mamane changed bug 69569 > What Removed Added > CC kyosh...@slickedit.com, libreoff...@kohei.us, > markus.mohrh...@googlemail.com > > Comment # 4 on bug 69569 from Lionel Elie Mamane > (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 reported the bug. -- 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