https://bugs.freedesktop.org/show_bug.cgi?id=86005
Bug ID: 86005
Summary: EDITING: Wrongly calculated value 1 in calc
Product: LibreOffice
Version: 4.3.3.1 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109088
--> https://bugs.freedesktop.org/attachment.cgi?id=109088&action=edit
Spreadsheet sample and a screenshot of my laptop just in case it works on your
computer
Problem description:
In some cases value 1 is not correctly calculated.
Please see attached files for explanation. I am attaching ods file as well as a
picture. The reason is that I tried it in MS Excel and it shows the same
problem as well. So I am not sure whether the problem is not somewhere in
windows or in my machine rather than in Calc.
I tried it in OpenOffice 3.1.1 on RedHat 5 and it shows the same issue.
The other thing is that it is really difficult to spot this issue since you
need to change the type to number with 20 decimal places. If you have fewer
decimal places the system round it to 1. But the rounding is not done
internally since Trunc function gives you 0 instead of 1.
Current behavior:
equation
=INT(8.45)+(8.45-INT(8.45))/0.6-7.75 gives 0.99999999999999800000
the same for Floor function
=FLOOR(8.45,1)+(8.45-FLOOR(8.45,1))/0.6-7.75 gives 0.99999999999999800000
Expected behavior:
equation
=INT(8.45)+(8.45-INT(8.45))/0.6-7.75 equal 1
Trunc of the line above gives 1
--
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
