https://bugs.freedesktop.org/show_bug.cgi?id=75987
Priority: medium
Bug ID: 75987
Assignee: [email protected]
Summary: EDITING: When calculating decimal values by monetary
values, gives incorrect product
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 95514
--> https://bugs.freedesktop.org/attachment.cgi?id=95514&action=edit
Example of payroll spreadsheet showing incorrect calculations
Problem description:
Doing a payroll spreadsheet in Calc. Times are calculated in 10 minute
increments. Employee is paid $10 per hour. If employee works 19.67 hours, the
total should be $196.70. Instead, Calc calculates the pay as $196.67.
Steps to reproduce:
1. Create a spreadsheet. Set up columns for beginning time and ending time (as
time values), and for the total time expressed as a decimal value:
(EndTime-StartTime)*24.
2. Set a cell to contain the hourly pay rate, expressed as dollars (in this
case, $10)
3. Set a cell to calculate the total hours worked (i.e., "=SUM(E14:E22)")
4. Set a cell to calculate the total pay, referencing the cells described in
steps 2 and 3 above.
Current behavior:
If the total hours worked are 19.67 and the pay rate is $10/hour, the total pay
should be calculated as $196.70. Instead, the total pay is calculated as
$196.67.
Expected behavior:
The total pay should be calculated as $196.70 (the correct value).
Operating System: Windows 8
Version: 4.1.2.3 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
