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

Reply via email to