https://bugs.freedesktop.org/show_bug.cgi?id=86660
Bug ID: 86660
Summary: calc mid formula not returns crazy values
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ricci...@libero.it
Created attachment 109933
--> https://bugs.freedesktop.org/attachment.cgi?id=109933&action=edit
errors showed sheet
hi, I've checked that problem on win, linux and mac .. 32bit and 64bit
versions
I'm currently using LO 3.4.4.1
Open a clean sheet and type in cell A1 the followinf formula =9,107-9
(it'll returns the correct value 0,107).
In another cell write the following formula =mid(A1;5;1)
you'd expect it to returns 7 instead it returns 6
I tried to change the values: 9,101 9,102 .. 9,109 and the results are
absolutely crazy .. A1=9,111 (9,111-9 ... correctly returns 0,111 but the
mid function returns 0 instead of 1).
Checking for the validity I've noticed that the right function returns crazy
values too .. example: if cell A4=9,013 the =right(A4;1) should return 3
instead it returns 9, if A4=9,031 the =right(A4;1) should return 1
instead it returns 8, if A4=9,083 the =right(A4;1) should return 3
instead it returns 5 .. and so on).
I attach a calc sheet (test.ods) showing that crazy values.
Nicola
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
