To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=32344
------- Additional comments from [EMAIL PROTECTED] Fri Aug 5 21:10:25 -0700 2005 ------- I gave my last comment more thought and realized you can maintain the same behavior openoffice uses now with regular expressions, make the excel imports and exports compatible, and mix the use of both regular expressions and wildcards on the same sheet and in any cells by doing the following. 1. Provide an optional argument to any formula function that will take regular expressions in openoffice, but takes wildcards in excel. 2. If the argument is set to true, assume the function arguments use ? and * as wildcards. 3. If the argument is false or not set, assume the function arguments may contain regular expressions. 4. For documents imported from excel, add the argument set to true to the cell containing the formula. 5. For documents in openoffice assume the argument is not set by default. 6. For documents in openoffice to be exported to excel the user can set the argument to use wildcards. 7. If the user doesnt set the argument, warn that excel does not fully support the use of regular expressions. This would allow the use of the same formula names for both cases and should be fairly easy to code into the existing regular expression code, since it then becomes a simple replacement of ? and * in the arguments fed to the functions with the equivalent regular expression. --------------------------------------------------------------------- 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]
