Bug 79926 (mamboknave@gmail.com) - FUNCTION N() returns invalid value in this specific cases...
Summary: FUNCTION N() returns invalid value in this specific cases...
Status: RESOLVED WORKSFORME
Alias: mamboknave@gmail.com
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-06-11 17:56 UTC by Mambo
Modified: 2014-06-11 21:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mambo 2014-06-11 17:56:35 UTC 
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
Comment 1 Julien Nabet 2014-06-11 20:25:07 UTC 
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)
Comment 2 Mambo 2014-06-11 21:21:01 UTC 
You are very right. I updated to the release 4.2.4 and that problem is gone.

Thank You.
Comment 3 Julien Nabet 2014-06-11 21:21:49 UTC 
Thank you for your quick feedback, I put it as WFM.