| Summary: | FUNCTION N() returns invalid value in this specific cases... | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Mambo <mamboknave> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | serval2412 |
| Priority: | medium | ||
| Version: | 3.5.7.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
On pc Debian x86-64 with 4.2.4 LO Debian package, I don't reproduce this. 3.5.7 is quite an old version. Could you give a try to a newer one? (last one is 4.2.4) You are very right. I updated to the release 4.2.4 and that problem is gone. Thank You. Thank you for your quick feedback, I put it as WFM. |
Entering N("string") as the only functio or as first function in a cell, it returns the CORRECT value in that cell. Examples: =N("string") // returns zero =N("string") + 20 // returns 20 BUT, Entering N("string") in any position different from the firs position in a cell, it returns the INCORRECT value error #VALUE! Example: =20 + N("string") // returns #VALUE! error IMPROPER/INCORRECT