[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113739 User oc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from o...@openoffice.org Wed Aug 25 09:57:23 + 2010 --- verified in internal build cws_calc58 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113739 User er changed the following: What|Old value |New value Assigned to|er|oc --- Additional comments from e...@openoffice.org Mon Aug 23 10:31:41 + 2010 --- Reassigning to QA for verification. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113739 --- Additional comments from e...@openoffice.org Wed Aug 18 16:58:23 + 2010 --- Created an attachment (id=71171) test cases - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113739 User er changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from e...@openoffice.org Wed Aug 18 16:57:36 + 2010 --- In cws calc58: changeset c8bc74228dbf http://hg.services.openoffice.org/cws/calc58/changeset/c8bc74228dbf M sc/source/core/tool/interpr1.cxx M sc/source/core/tool/interpr4.cxx You can observe the progress and possible integration date of CWS calc58 at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOO330%2Fcalc58 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113739
User er changed the following:
What|Old value |New value
Assigned to|spreadsheet |er
Ever confirmed| |1
Status|UNCONFIRMED |NEW
Keywords| |ms_interoperability, regre
| |ssion
Subcomponent|code |programming
Target milestone|--- |OOo 3.3
--- Additional comments from e...@openoffice.org Fri Aug 13 21:02:24 +
2010 ---
In short: =N("4") returns 0, but =N(A1) with A1:'4 returns 4. Instead it should
also return 0. Excel does this. OOo3.1.1 did that as well.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113739 --- Additional comments from e...@openoffice.org Fri Aug 13 20:59:22 + 2010 --- *** Issue 113872 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113739] Function N() is inconsist ent
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113739
Issue #|113739
Summary|Function N() is inconsistent
Component|Spreadsheet
Version|OOO320m12
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|keme6206
--- Additional comments from keme6...@openoffice.org Mon Aug 9 08:45:38
+ 2010 ---
Inconsistent behaviour of the N() function when the parameter is a string data
type with numeric content.
I assume that the intended use for this function is to explicitly allow the
entry of string values in cells that are used by formulas for numerical
calculations, to avoid/ignore certain errors.
The application help states that N will return zero with text parameters.
I tested with the following inputs:
Text constant entered in cell
A1: '4
Formula returning text value
A2: ="4"
Nonnumeric text
A3: jhg
I tested with several OOo builds, with results as indicated below (all packages
"en-US", except as noted):
***
OOo 3.1.1 Novell edition, as bundled with OpenSuSE 11.2, build ID: 9319 (not
updated after installing, afaik)
N(A1)=4 ; N(A2)=4 ; N(A3)=0 ; N("4")=0
I'm aware that this is a third party build. Still included for reference.
***
OOo 3.2.0 Norwegian for MS Windows, running on Windows XP pro SP3 (OOO320M12)
N(A1)=4 ; N(A2)=4 ; N(A3)=0 ; N("4")=0
Didn't make a note of build ID before upgrading to 3.2.1 (for next entry).
Sorry!
***
OOo 3.2.1 Norwegian for MS Windows, running on Windows XP pro SP3 (OOO320M18,
build 9502)
N(A1)=4 ; N(A2)=4 ; N(A3)=#VALUE ; N("4")=0
Note that here the string handling is clearly wrong. Seems to be corrected in
the dev version, though.
***
OOo-dev 3.3.0 for MS Windows, running on Windows XP pro SP3 (OOO330m2, build
9516)
N(A1)=4 ; N(A2)=4 ; N(A3)=0 ; N("4")=0
***
OOo 3.2.0 for OS-X/intel, running on OS-X 10.5.8 (OOO320m8, build 9472)
N(A1)=4 ; N(A2)=4 ; N(A3)=#VALUE ; N("4")=0
***
OOo 3.2.1 for OS-X/intel, running on OS-X 10.5.8 (OOO320m18, build 9502)
N(A1)=4 ; N(A2)=4 ; N(A3)=#VALUE ; N("4")=0
***
The only situation where N() behaves consistently as documented (per the
application's help function) is the situation where an inline constant is given.
This is also the least useful situation (I can't imagine any practical setting
where it would be useful).
With cell content, N() consistently attempts to interpret numeric content in
strings. This is not according to the application help, which states that
parameters of data type "text" will return zero. It is also inconsistent with
the behaviour of the "major player", MS Excel.
Also, with some builds, the function totally fails to do its job (as per my
assumption of intended use, above), returning an error for text that cannot be
interpreted as a number.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
