https://bugs.freedesktop.org/show_bug.cgi?id=63242
Priority: medium
Bug ID: 63242
Assignee: [email protected]
Summary: : Functions INT and TRUNC
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.5.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 77565
--> https://bugs.freedesktop.org/attachment.cgi?id=77565&action=edit
My spreadsheet with data from laboratory, when you will find problem, which I
explained.
Problem description:
Steps to reproduce:
1. Write to cell A1 4,01 or 2,86 or 1,92 or 1,36 or maybe other special (?)
numbers...
2. In A2 make formula =A1-INT(A1)
3. In A3 make formula =A2*10
4. In A4 make formula =A3-INT(A3)
5. In A5 make formula =10*A4
6. In A6 make formula =A5-INT(A5)
7. A6 equals 1, which is wrong, because it should equals 0 !!!
8. Check in other cell, that [A5 number]-INT([A5 number])=0. Do not copy
formula from A5! Write number from A5 again, using keyboard.
9. Now replace INT with TRUNC([cell];0) and cry when you get 1 instead of 0
!!!
Current behavior: In some cases you get wrong number.
Expected behavior: Mathematical behavior, which is: If x belongs to natural
numbers, x-INT(x)=0
I don't know, whether this problem exists in other versions of Calc and which
is the latest proper-working version, if any.
Operating System: Debian
Version: 3.5.4 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
