[sc-issues] [Issue 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 User oc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from o...@openoffice.org Fri Sep 11 07:39:19 + 2009 --- verified in internal build cws_odff06 - 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 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 User er changed the following: What|Old value |New value Assigned to|er|oc --- Additional comments from e...@openoffice.org Thu Sep 3 16:06:10 + 2009 --- Reassigning to QA for verification. Note: Exporting i81214_LOOKUP.ods to .xls and loading in Excel, the following ranges differ and produce #N/A in Excel (instead of a value found in Calc) because of issue 104241: F13:I13 I13:I16 E37:E39 - 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 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 User er changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from e...@openoffice.org Fri Aug 14 16:19:35 + 2009 --- In cws odff06: revision 275000 sc/source/core/inc/parclass.hxx sc/source/core/tool/interpr1.cxx sc/source/core/tool/interpr4.cxx sc/source/core/tool/parclass.cxx Changed implementation of the patch to use PushCellResultToken() wherever possible for inherited emptiness, that was broken. For this, introduced a new parameter classification ReferenceOrForcedArray to be able to distinguish between references passed that don't need to be unnecessarily converted to arrays, and arguments that need to be converted to array in the parameter chain. - 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 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 --- Additional comments from e...@openoffice.org Fri Aug 14 20:38:55 + 2009 --- Submitted separate issue 104241 for the string query should not return match for last numeric value if no string = query was found problem, as it affects LOOKUP, MATCH, VLOOKUP and HLOOKUP. - 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 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 This issue depends on issue 102702, which changed state: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED - 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 81214] ODFF: LOOKUP ForceArray pa rameters; string vs. number must not match
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81214 User er changed the following: What|Old value |New value Summary|ODFF: LOOKUP function is t|ODFF: LOOKUP ForceArray pa |oo restricted in what it a|rameters; string vs. numbe |ccepts as arguments. |r must not match --- Additional comments from e...@openoffice.org Thu Jun 25 11:27:31 + 2009 --- Another detail: a non-range lookup must return #N/A if the query was string and the search vector is numbers or vice versa, an automatic conversion must not be applied. For example, a query 3 must not match 3, a query 3 must not match 3. - 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