|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | ODFF: Function N() should return 0 also for literal text that could be interpreted as number. | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | ooo | ||||||
| Component: | programming | Assignee: | oc | ||||||
| Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||||
| Severity: | Trivial | ||||||||
| Priority: | P3 | CC: | issues, lohmaier, lvyue | ||||||
| Version: | recent-trunk | Keywords: | ms_interoperability, oooqa | ||||||
| Target Milestone: | --- | ||||||||
| Hardware: | All | ||||||||
| OS: | All | ||||||||
| URL: | http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula | ||||||||
| Issue Type: | PATCH | Latest Confirmation in: | --- | ||||||
| Developer Difficulty: | --- | ||||||||
| Issue Depends on: | |||||||||
| Issue Blocks: | 72764 | ||||||||
| Attachments: |
|
||||||||
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 |
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.