https://bugs.freedesktop.org/show_bug.cgi?id=57865
Priority: medium
Bug ID: 57865
Assignee: [email protected]
Summary: Calc Function DATE doesn't calculate correctly
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.6.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 70985
--> https://bugs.freedesktop.org/attachment.cgi?id=70985&action=edit
The attached spreadsheet describes the problem
How to replicate:
A1 =DATE(2012,6,25)
A2 =DATE(2012,MONTH(A1)+1,25)
Use the handle on A2 and go right down to say, A25
A8 =DATE(2012,MONTH(A7)+1,25) (25/01/13) which correct, BUT
A9 =DATE(2012,MONTH(A8)+1,25) (25/02/12) which is WRONG
A9 should be (25/02/13) not (25/02/12)!
--
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
