https://bugs.documentfoundation.org/show_bug.cgi?id=90100
Bug ID: 90100
Summary: The function DAYS() returns non-interger values
Product: LibreOffice
Version: 4.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: nefil...@yahoo.com
Created attachment 114186
--> https://bugs.documentfoundation.org/attachment.cgi?id=114186&action=edit
Bug example (in sheet Calcul, cells H14 and I14)
Hello.
I am doing operations with the functions DAYS(), INDIRECT() and ADDRESS() and
have abnormal results.
I finally found that the problem comes from the value returned by the function
DAYS(), which are not integers.
In the attached example, go to sheet 'Calcul' and cell H14 (coloured in dark
pink). You may see that the cell contains the formula "=DAYS(D14;C14)" which
returns as value "364,99999724537300000000000000".
Thus when I lated use this value to find a cell reference as done in the cell
I14 (formula : "=ADDRESS($H14;B$22)"), the result is wrong ($H$364 instead of
$H$365).
So far, I am working around this by replacing "=DAYS(D14;C14)" by
"=round(DAYS(D14;C14))".
--
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
