https://bugs.freedesktop.org/show_bug.cgi?id=70551
Priority: medium
Bug ID: 70551
Assignee: [email protected]
Summary: UI: Wrong result returned from WEEKS() function
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 87761
--> https://bugs.freedesktop.org/attachment.cgi?id=87761&action=edit
Spreadsheet illustrating the problem described.
Problem description: An incorrect result is returned for some dates entered
into this function
Steps to reproduce:
1. Open Calc
2. Enter data, such as 1st April 2011, 1st May 2011 and number 1, into cells
A1, A2 and A3 respectively
3. in cell 4 enter the function, using the Function Wizard, of WEEKS(A1,A2,A3)
Current behavior:
It returns the result 4
Expected behavior:
It should return the result 5. The two dates appear in weeks which are 5 weeks
apart.
Computer is set to US-locale.
Operating System: Windows XP
Version: 4.1.1.2 release
--
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
