https://bugs.freedesktop.org/show_bug.cgi?id=87386
Bug ID: 87386
Summary: Calculation inaccuracy and inconsistency converting
numbers and text to dates.
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: x86 (IA32)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Cell C13 & D13 contain general number 24.09 and text 24.09.13, respectively
(European dates dd.mm and dd.mm.yy in a .CSV opened on a US machine). Formula
to convert the first dd.mm and the second year to a date would be
=DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)), however, for this
particular date the formula returns 08/24/13 rather than 09/24/13. Note that:
=DATE(2000+VALUE(RIGHT(D13,2)),0.09*100,INT(C13)) works
=DATE(2000+VALUE(RIGHT(D13,2)),C13*100-INT(C13)*100,INT(C13)) works
=DATE(2000+VALUE(RIGHT(D13,2)),(C13-INT(C13))*100,INT(C13)) does not
=DATE(2000+VALUE(RIGHT(D13,2)),MOD(C13,1)*100,INT(C13)) does not
A similar problem occurs with number 7.05 and text 07.05.13 and others, but
not all.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
