https://bugs.freedesktop.org/show_bug.cgi?id=69569

--- Comment #7 from Lionel Elie Mamane <lio...@mamane.lu> ---
(In reply to comment #6)
> I played a bit with Excel and LibreOffice. I found one example where they
> differ:
> 
> =YEARFRAC(DATE(2024;3;1);DATE(2025;3;1);1)
> 
> This, naively, should be "1". That's what Excel gives. LibreOffice gives
> 365/366...

This is because of clause 8 of ODFv1.2 part 2, ยง4.11.7.7
I guess I'm slipping into the "ODF has the wrong definition/algorithm" camp.

-- 
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

Reply via email to