https://bugs.freedesktop.org/show_bug.cgi?id=79926
Priority: medium
Bug ID: 79926
Assignee: [email protected]
Summary: FUNCTION N() returns invalid value in this specific
case...
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 3.5.7.2 release
Component: Spreadsheet
Product: LibreOffice
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
--
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
