https://bugs.documentfoundation.org/show_bug.cgi?id=69569
Xisco Faulí changed:
What|Removed |Added
CC||xiscofa...@libreoffice.org
https://bugs.documentfoundation.org/show_bug.cgi?id=69569
Winfried Donkers changed:
What|Removed |Added
Status|NEW |ASSIGNED
--- Comment #20 from
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 s
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 map
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
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.___
Lib
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 rete
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 might be differences in
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&action=edit
Excel vs Calc comparison
Spreadsheet with formulas, Excel results, Calc results and comparison
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 reporters and confirmers to rete
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 reporters and confirmers to rete
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Joel Madero changed:
What|Removed |Added
Whiteboard|NeedAdvice |
--
You are receiving this mail because:
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Robinson Tryon (qubit) changed:
What|Removed |Added
Status|UNCONFIRMED |NEW
Ever confirmed|0
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #9 from Lionel Elie Mamane ---
(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.
> How abo
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #8 from Christian Fries ---
(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
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #7 from Lionel Elie Mamane ---
(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 wh
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #6 from Lionel Elie Mamane ---
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
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #5 from Christian Fries ---
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 includ
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Lionel Elie Mamane changed:
What|Removed |Added
CC||kyosh...@slickedit.com,
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Robinson Tryon (qubit) changed:
What|Removed |Added
CC||lio...@mamane.lu,
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Joel Madero changed:
What|Removed |Added
Whiteboard||NeedAdvice
CC|
https://bugs.freedesktop.org/show_bug.cgi?id=69569
Michael Stahl changed:
What|Removed |Added
Attachment #86136|text/plain |application/x-zip
mime type|
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #2 from Christian Fries ---
Note: I have checked the modifications made by Lionel Elie Mamane at
http://cgit.freedesktop.org/libreoffice/core/commit/?id=0f002a14ecdc445deb2bc8d4cc6fbe4b724ac7f6&h=libreoffice-4-1
- just looking at the
https://bugs.freedesktop.org/show_bug.cgi?id=69569
--- Comment #1 from Christian Fries ---
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 receiving this mail because
24 matches
Mail list logo