[sc-issues] [Issue 105611] If 'search_text' is not f ound, let FIND() and SEARCH() return 0 instead of a #VALUE error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105611 --- Additional comments from disco...@openoffice.org Tue Oct 6 16:28:15 + 2009 --- This is actually a duplicate of issue 66590 (http://www.openoffice.org/issues/show_bug.cgi?id=66590) - 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 105611] If 'search_text' is not f ound, let FIND() and SEARCH() return 0 instead of a #VALUE error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105611 Issue #|105611 Summary|If 'search_text' is not found, let FIND() and SEARCH() | return 0 instead of a #VALUE error Component|Spreadsheet Version|DEV300m55 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|smls --- Additional comments from s...@openoffice.org Mon Oct 5 11:37:20 + 2009 --- Feature request title should be self-explanatory. 1) Avoid annoying error values in dynamic spreadsheets, 2) make it possible to write IF(SEARCH(.. , ..)) and similar. That should be benefit enough. - 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 105611] If 'search_text' is not f ound, let FIND() and SEARCH() return 0 instead of a #VALUE error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105611 User er changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WONTFIX --- Additional comments from e...@openoffice.org Mon Oct 5 13:14:30 + 2009 --- Those functions use the same semantics as in the other spreadsheet application. Changing the behavior will make fail formulas that use some IF(ISERROR(FIND(...)) construct. Future releases will have the IFERROR() function. See also http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula - 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 105611] If 'search_text' is not f ound, let FIND() and SEARCH() return 0 instead of a #VALUE error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105611 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from e...@openoffice.org Mon Oct 5 13:14:46 + 2009 --- Closing. - 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