https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #8 from Christian Fries <em...@christian-fries.de> --- (In reply to comment #7) > > 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. If would like to add that both Excel and LibreOffice have a wrong algorithm - in the following sense that both algorithms do not comply with the ACT/ACT ISDA definition which is a) the most popular definition of ACT/ACT with relevance to industry and b) much simpler (=n1/365 + n2/366 where n1 = number of days falling in non-leap year and n2 = number of days falling in leap year). So "naively should be" or "defined in ODF" is IMHO not very relevant. How about: - use base 4 for the Excel compatible implementation - introduce a new base or even a new function for ACT/ACT ISDA - if necessary, implement LibreOffices method too (as part of the new function of base 6?) Or: - Have the definition of base 4 configurable. -- 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