[sc-issues] [Issue 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 User regina changed the following: What|Old value |New value CC|'inetpro' |'inetpro,regina' --- Additional comments from reg...@openoffice.org Sun Sep 13 15:39:51 + 2009 --- The behavior of SEARCH and FIND is defined in ODF 1.2. There is said, Returns an Error if text not found. Any change in behavior would require to firstly change the standard. - 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 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 --- Additional comments from reg...@openoffice.org Sun Sep 13 15:42:29 + 2009 --- *** Issue 105036 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 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 --- Additional comments from pm...@openoffice.org Tue Feb 10 20:19:55 + 2009 --- this feature can break Excel compatibility. an XLS file with FIND+ISERR construct will be opened incorrectly (even worse, OOo will show completely wrong result for =IF(ISERR(FIND(a;xxx));0;1), because ISERR() will return FALSE instead of TRUE) however, there is also SEARCH() function, which act same as FIND. I think it is possible to make FIND work a-la Excel and SEARCH as proposed here (or vice versa). then XLS import filter can simply use Excel-friendly variant. - 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 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 --- Additional comments from [EMAIL PROTECTED] Fri Aug 22 09:44:33 + 2008 --- *** Issue 90675 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 66590] Calc: String Functions: Ex tended FIND() Function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66590 User discoleo changed the following: What|Old value |New value Summary|Calc: String Functions: FI|Calc: String Functions: Ex |ND() |tended FIND() Function --- Additional comments from [EMAIL PROTECTED] Tue Aug 12 21:17:16 + 2008 --- Searching on the MS forums I saw some other requests that could well be handled by this extended function. FINDEX() Function Syntax: FINDEX(string, string, START, END) Initially, when I wrote the code for the FindEx() function, I did NOT interpret specifically a negative END position, BUT returned 0 IF START END. I did played with the idea to interpret negative values as pointing to the _end_ of the original string, though the code would have become to complex and I abandoned the idea. The requests to search the end of the string (and even a reverse search) did pop up on the MS forums, so I think it is time to get into such an extended FINDEX() function, too. The idea: - IF (START 0) = begin to search at string position: strlen() + START /* REMEMBER: START is negative */ - IF (END 0) = end search at string position: strlen() + END /* REMEMBER: END is negative */ So, it would be possible to specify relative positions from the beginnineg or from the end of the original string. This function would not cover a reverse-search, however, one could similarly define an RSearchEx() function. - 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]