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 +0000 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