[Libreoffice-bugs] [Bug 86660] calc mid formula not returns crazy values
https://bugs.freedesktop.org/show_bug.cgi?id=86660 --- Comment #1 from Nicola Ricciarelli ricci...@libero.it --- ops, typing error: I'm currently using LO 4.3.4.1 -- 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
[Libreoffice-bugs] [Bug 86660] calc mid formula not returns crazy values
https://bugs.freedesktop.org/show_bug.cgi?id=86660 raal r...@post.cz changed: What|Removed |Added Attachment #109933|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet -- 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
[Libreoffice-bugs] [Bug 86660] calc mid formula not returns crazy values
https://bugs.freedesktop.org/show_bug.cgi?id=86660 raal r...@post.cz changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||r...@post.cz Resolution|--- |NOTABUG --- Comment #2 from raal r...@post.cz --- Hello, MID function is for text string. You can not use this function for numeric. You can convert numeric to text, for example =MID(TEXT(B3;0,000);3;1) -- 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
[Libreoffice-bugs] [Bug 86660] calc mid formula not returns crazy values
https://bugs.freedesktop.org/show_bug.cgi?id=86660 --- Comment #3 from Nicola Ricciarelli ricci...@libero.it --- (In reply to raal from comment #2) Hello, MID function is for text string. You can not use this function for numeric. You can convert numeric to text, for example =MID(TEXT(B3;0,000);3;1) Hi, thanks raal, you're true!! I missed about it: the past times I used that functions on numbers they were already converted in strings. 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