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