[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 Winfried Donkers changed: What|Removed |Added Status|NEW |ASSIGNED --- Comment #20 from

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #19 from Winfried Donkers --- (In reply to dahrion from comment #17) > I had to implement the yearfrac function and can confirm that the error is > in the specification. > Specifically in ODFv1.2 part 2, §4.11.7.7 line 8 > it

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #18 from Christian Fries --- I would like to add an aspect to this issue: LibreOffice claims that it can open Excel Files. It claims compatibility. https://www.libreoffice.org/discover/calc/ The Excel YEARFRAC function is

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #17 from dahrion --- I had to implement the yearfrac function and can confirm that the error is in the specification. Specifically in ODFv1.2 part 2, §4.11.7.7 line 8 it shoul be not(A) also in line 9 the between is inclusive

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #16 from Christian Fries --- Retested this issue with LIBRE Office 5.4.7 and 6.0.5. It still exists. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #15 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #14 from Lucian Mocanu --- I can confirm that the bug is still present in LibreOffice 5.3.0. The ODF specification (v1.2 part 2 section 4.11.7.7) describes (almost) the same behaviour as in Excel (there

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #13 from Lucian Mocanu --- Created attachment 130995 --> https://bugs.documentfoundation.org/attachment.cgi?id=130995=edit Excel vs Calc comparison Spreadsheet with formulas, Excel results, Calc

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #12 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.documentfoundation.org/show_bug.cgi?id=69569 --- Comment #11 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Joel Madero jmadero@gmail.com changed: What|Removed |Added Whiteboard|NeedAdvice | -- You are

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

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.

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 --- Comment #6 from Lionel Elie Mamane lio...@mamane.lu --- 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-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

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.

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

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

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 --- Comment #9 from Lionel Elie Mamane lio...@mamane.lu --- (In reply to comment #8) (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.

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Joel Madero jmadero@gmail.com changed: What|Removed |Added Whiteboard||NeedAdvice

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 Michael Stahl mst...@redhat.com changed: What|Removed |Added Attachment #86136|text/plain |application/x-zip

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 --- Comment #1 from Christian Fries em...@christian-fries.de --- Note: There was a typo in the url to the test spreadsheets. The url is http://finmath.net/spreadsheets/Day%20Count%20Fractions.zip - but I attached that file anyway. -- You are

[Libreoffice-bugs] [Bug 69569] Implementation of YEARFRAC function inconsistent with Excel

https://bugs.freedesktop.org/show_bug.cgi?id=69569 --- Comment #2 from Christian Fries em...@christian-fries.de --- Note: I have checked the modifications made by Lionel Elie Mamane at