Issue 86721 - ODFF: Function N() should return 0 also for literal text that could be interpreted as number.
Summary: ODFF: Function N() should return 0 also for literal text that could be interp...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL: http://www.oasis-open.org/committees/...
Keywords: ms_interoperability, oooqa
Depends on:
Blocks: 72764
  Show dependency tree
 
Reported: 2008-03-05 12:52 UTC by ooo
Modified: 2013-08-07 15:15 UTC (History)
3 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
The first patch on N(). (691 bytes, text/plain)
2008-03-10 07:34 UTC, lvyue 		no flags Details
patch2 of i86721 (707 bytes, text/plain)
2008-03-13 10:05 UTC, lvyue 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ooo 2008-03-05 12:52:14 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.
Comment 1 ooo 2008-03-05 13:04:22 UTC 
Hi Yue,
The issue for the change I mentioned on IRC today.
Eike
Comment 2 lvyue 2008-03-10 07:34:43 UTC 
Created attachment 51999 [details]
The first patch on N().
Comment 3 lvyue 2008-03-13 10:05:42 UTC 
Created attachment 52069 [details]
patch2 of i86721
Comment 4 ooo 2008-04-10 19:21:21 UTC 
In cws odff03:

sc/source/core/tool/interpr1.cxx  1.56.20.3

Added missing curly braces to the if() condition.
Comment 5 ooo 2008-05-09 18:04:24 UTC 
Reassigning to QA for verification.
Comment 6 oc 2008-06-04 14:24:17 UTC 
verified in internal build cws_odff3
Comment 7 lohmaier 2008-08-05 21:57:27 UTC 
ok in m28 → closing