Apache OpenOffice (AOO) Bugzilla – Issue 86721
ODFF: Function N() should return 0 also for literal text that could be interpreted as number.
Last modified: 2013-08-07 15:15:24 UTC
For ODFF compliance and interoperability with other spreadsheet applications the function N() should return 0 for all text, also if that could be interpreted as a numeric value. Text must not be converted to number as VALUE() does. Currently =N("1") returns the numeric value 1.
Hi Yue, The issue for the change I mentioned on IRC today. Eike
Created attachment 51999 [details] The first patch on N().
Created attachment 52069 [details] patch2 of i86721
In cws odff03: sc/source/core/tool/interpr1.cxx 1.56.20.3 Added missing curly braces to the if() condition.
Reassigning to QA for verification.
verified in internal build cws_odff3
ok in m28 → closing