[sc-issues] [Issue 81214] ODFF: LOOKUP function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Fri Jun 12 08:34:21 + 2009 --- The Excel export problem is now covered by issue 102702. - 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 function is t oo restricted in what it accepts as arguments.
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 IssuesThisDependsOn| |102702 - 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 function is t oo restricted in what it accepts as arguments.
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 lv...@openoffice.org Tue May 5 08:50:39 + 2009 --- Created an attachment (id=61995) based on Eike's latest patch, changed for the third paramater, enable value, string or singleref. - 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 function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Thu Apr 30 09:05:24 + 2009 --- dr-er: Seems that there is another type of token class in Excel which is neither exactly ref-type nor array-type. First, please do not change the first parameter, it must remain value-type. For the second parameter, Excel seems to handle it as array-type in cell formulas (value-type context) and as ref-type in other formula types, e.g. defined names and array formula cells (ref-type and array-type contexts). I have checked handling of ref-type parameters (e.g. SUM) and array-type parameters (e.g. SUMPRODUCT) in all formula types. The export filter works correctly for all types of formulas there. So I need to extend the formula compiler for this new parameter type. - 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 function is t oo restricted in what it accepts as arguments.
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 Thu Apr 30 10:06:50 + 2009 --- @dr: First, please do not change the first parameter, it must remain value-type. Argh, sure, that was in error, bad me.. I'll attach a corrected patch. So I need to extend the formula compiler for this new parameter type. Question remains whether there are other functions using this type yet undiscovered. And if it has any influence on our internal classification. - 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 function is t oo restricted in what it accepts as arguments.
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 Thu Apr 30 10:53:28 + 2009 --- Created an attachment (id=61913) exported Excel .xls with the corrected parameter classification (no change in display behavior though) - 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 function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Thu Apr 30 11:46:08 + 2009 --- Yes, what about the [HV]LOOKUP functions? I am currently thinking about a generic testcase to be able to distinguish these 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 81214] ODFF: LOOKUP function is t oo restricted in what it accepts as arguments.
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 Attachment is patch| |Created an attachment (id= | |61912) patch with correcte | |d Excel classification, ba | |sed on current CWS odff06 --- Additional comments from e...@openoffice.org Thu Apr 30 10:50:36 + 2009 --- Created an attachment (id=61912) patch with corrected Excel classification, based on current 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 function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Thu Apr 30 12:51:43 + 2009 --- I think all functions should be tested that contain an R parameter type in the Excel filter function list, except functions that do not accept anything but real references (e.g. the ROW() function). The functions should be used in a cell formula receiving a value-type parameter (e.g. PI()), and a (value-type*ref-type) parameter (e.g. A1*PI()) as argument. If Excel writes the function parameter as array-type, this function needs to be changed to the new parameter type. I will add the new functionality in the Excel filter to CWS odff06, and I will check the functions. - 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 function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Thu Apr 30 12:55:18 + 2009 --- @er: please remove the changed parameter type in the Excel filter from the patch, to not run into confusion :-) - 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 function is t oo restricted in what it accepts as arguments.
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 d...@openoffice.org Thu Apr 30 12:57:20 + 2009 --- Created an attachment (id=61926) Possible combinations of formula type, param type, token type - 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 function is t oo restricted in what it accepts as arguments.
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 Attachment is patch| |Created an attachment (id= | |61933) patch without the E | |xcel export bits against t | |he now current CWS odff06 --- Additional comments from e...@openoffice.org Thu Apr 30 16:03:12 + 2009 --- Created an attachment (id=61933) patch without the Excel export bits against the now current 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 function is t oo restricted in what it accepts as arguments.
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 Thu Apr 30 16:03:56 + 2009 --- All 3 LOOKUP results in that i81214_paramtypes.xls are #N/A with the current patch. - 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 function is t oo restricted in what it accepts as arguments.
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 CC|''|'lvyue' Status|NEW |STARTED --- Additional comments from e...@openoffice.org Wed Apr 29 19:34:39 + 2009 --- The patch missed to change the parameter classification to ForceArray to make the example from #desc4 work, also for Excel export. Comparing with Excel another undocumented subtlety turned out: if the data = query found is of type string and the query was numeric, or vice versa, Excel returns #N/A, even if it is said that a 0-9 A-Z sorted data is searched. Changed function accordingly. Other smaller changes: eDataArray didn't need to be assigned in each case block, once before the switch and switching on the value suffices. The result of CollatorWrapper::compareString() is not one of COMPARE_EQUAL, COMPARE_LESS, ... but values 0, ==0 or 0 instead. I'll attach my current patch, a test case document and comment on remaining problems. - 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 function is t oo restricted in what it accepts as arguments.
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 Attachment is patch| |Created an attachment (id= | |61898) patch for modules s | |c and oox --- Additional comments from e...@openoffice.org Wed Apr 29 19:36:19 + 2009 --- Created an attachment (id=61898) patch for modules sc and oox - 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 function is t oo restricted in what it accepts as arguments.
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 Wed Apr 29 19:38:33 + 2009 --- Created an attachment (id=61899) testcase Calc .ods - 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 function is t oo restricted in what it accepts as arguments.
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 Wed Apr 29 19:39:43 + 2009 --- Created an attachment (id=61900) the same testcase exported to Excel .xls - 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 function is t oo restricted in what it accepts as arguments.
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 Wed Apr 29 19:47:45 + 2009 --- @lvyue: with the second patch applied, loading the .ods testcase displays Err:504 in H2 and H3, these should also work. @dr: with the second patch applied, testcase exported to .xls and loaded in Excel it displays #VALUE! in cells E19:H28, see also attached .xls file. Pressing F2 and enter on each then displays the expected value. The formulas are not different from those in A19:D28, except of different cells referred. I don't see a reason why this should be.. please investigate. Thanks Eike - 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 function is t oo restricted in what it accepts as arguments.
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 Issue type|DEFECT|PATCH - 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 function is t oo restricted in what it accepts as arguments.
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 lv...@openoffice.org Thu Mar 12 09:17:29 + 2009 --- Created an attachment (id=60894) patch 1. - 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 function is t oo restricted in what it accepts as arguments.
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 Target milestone|OOo 3.1 |OOo 3.2 --- Additional comments from e...@openoffice.org Wed Jan 21 23:33:00 + 2009 --- Won't make it for 3.1, targeting to 3.2 - 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 function is t oo restricted in what it accepts as arguments.
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|LOOKUP function is too res|ODFF: LOOKUP function is t
|tricted |oo restricted in what it a
| |ccepts as arguments.
Subcomponent|ui|programming
Target milestone|OOo 3.x |OOo 3.1
--- Additional comments from [EMAIL PROTECTED] Thu Jun 12 15:47:43 +
2008 ---
Comment from issue 90628:
ODFF defines the Searched and Results parameters as 'ForceArray'.
Calc doesn't handle for example
=LOOKUP(4; A1:C1*2; A3:C3)
entered in D4, where A1:C1*2 should be evaluated as an array expression, as does
Excel.
Additional note: the array case =LOOKUP(1;{1;2}) was implemented with CWS
odff03. Other cases remain to be done.
-
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
