[Libreoffice-bugs] [Bug 53274] : N() doesn't return 0 if input is #N/A

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=53274

David Lynch <david_lynch at blueyonder.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CLOSED                      |REOPENED
         Resolution|NOTABUG                     |
     Ever Confirmed|0                           |1

--- Comment #4 from David Lynch <david_lynch at blueyonder.co.uk> 2012-08-13 16:55:30 UTC ---
There is a bug, either in the software or the documentation. 

The documentation is:

"N
Returns the numeric value of the given parameter, if the parameter is a number.
Returns the number 1 if the parameter is TRUE. Returns the number 0 for other
parameters (text, FALSE or #NA).
If an error occurs, other than #NA, the function returns the error value."

Clearly, this says that N(NA()) should return 0. And previous versions of the
software did this. I and (and apparently others) have been relying on this. 

If it is decided that is right to change the behaviour of N(), then I suggest
that adequate warning of this is given, and the documentation amended to
reflect this warning.

Meanwhile, the software does not behave as the documentation says so there is a
bug somewhere.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.