[sc-issues] [Issue 32344] Simple wildcards * and ? as opposed to regular expressions
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] Sun Sep 4 19:31:57 -0700 2005 --- You didn't get my point. The argument doesn't have to be a direct value I think I did get your point and thought I had explained that in the statement below to be interpreted as (The argument DOES have to be a direct value) Though it would be easier to just restrict that argument to only the values 0,1,True,False and anything else would result in a formula error and if it was not that would be in error. I can understand that you might want to or have to generalize from this specific case because the next complaint would be that a formula result could not be used. I can also understand that there may be no existing code in the current formula handling to force an argument to be only a direct value. Since it seems all of the above is not a realistic option, would you be willing to agree a reasonable option would be to make the setting applicable to each sheet in a workbook, rather than to the entire workbook? This would allow an import from Excel using wildcards and then adding a new sheet to the workbook that uses regular expressions within the same workbook. The user could reference cells on those sheets within the same workbook that are results of regular expressions. Thankyou for being patient in explaining your objections and the reasons for those objections in detail. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Tue Aug 30 04:02:53 -0700 2005 --- Hi Drensink, What should be exported if that argument is the result of a formula? Keep in mind this would not be the argument with the wildcards/regular expressions in it, but an additional, optional argument whose value would be restricted to 0 or 1, True or False. You didn't get my point. The argument doesn't have to be a direct value, it could be a formula result instead, e.g. FALSE(), or a cell reference where the user could play with the value, or any sophisticated formula, even with side effects. In these cases stripping away the parameter simply can't be done. 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: [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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Mon Aug 15 03:13:55 -0700 2005 --- Hi Drensink, 6. For documents in openoffice to be exported to excel the user can set the argument to use wildcards. What should be exported if that argument is the result of a formula? 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. I'd rather implement a simple wildcard search than fiddling around with the argument's string content. Bear in mind that all other content that possibly could form a regular expression would have to be escaped otherwise. 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: [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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Mon Aug 15 19:32:08 -0700 2005 --- This gets a bit more complicated than it seems at face value, but I will continue a bit more to see if there is an optimal solution to the problem. What should be exported if that argument is the result of a formula? Keep in mind this would not be the argument with the wildcards/regular expressions in it, but an additional, optional argument whose value would be restricted to 0 or 1, True or False. If it is set to 1, then the formula uses wildcards and you export the other argument to the function with the wildcards in it as it is written by the author of the document and strip the 1 during export since Excel does not use it because by default it uses wildcards. If it is not set or set to 0, then you know you are exporting a document that is very likely not to be compatible with Excel, but could warn and continue exporting anyway. If the additional, optional argument is a result of a formula, which should not be necessary, then that formula should result in True or False, 0 or 1 otherwise it would be in error. That still would not matter because you would just check to see if it results in 0 and 1 and strip the whole formula off just like you would strip the 1 off. Though it would be easier to just restrict that argument to only the values 0,1,True,False and anything else would result in a formula error. I'd rather implement a simple wildcard search than fiddling around with the argument's string content. Bear in mind that all other content that possibly could form a regular expression would have to be escaped otherwise. The additional, optional argument would just determine which code path is taken. If you want to do a whole new implementation of the formula using wildcards instead of messing with the string content of the argument containing wildcards/regular expressions, the same principle would still work. The biggest problem I see with the supposedly simple solution, just turn off regular expressions and turn on wildcards is that it immediately eliminates the use of more powerful regular expressions in that document, preventing someone from importing a document containing wildcards from excel for the purpose of using regular expressions. The continued incompatibility on export of formulas with the same names using regular expressions would also still have to be dealt with in the simple case. The basis of my approach is almost exactly the same as doing it for the whole document or sheet, with the exception that it is done for each cell where those formulas are used, rather than the whole document at once. You still have to decide whether its a regular expression or wildcard and fix the code for each formula to handle it if you do it for the whole document. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Mon Aug 15 19:53:26 -0700 2005 --- One more note: It would be an irritatant to a user to have to add the ;1 constantly to a formula. The option for the document could be added anyway so when it is set to wildcards the ;1 is automatically added upon finishing the formula input. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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]
[sc-issues] [Issue 32344] Simple wildcards * and ? as opposed to regular expressions
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] Wed Aug 3 08:30:45 -0700 2005 --- Drensink, Navvy, Please note that automatic translation is not feasible. It might work in simple cases of literal string arguments as parameters during import, but as soon as the search expression is concatenated from substrings or obtained via formula functions it would fail. Furthermore it wouldn't work with round-trip documents, i.e. load from Excel and save to Excel file format again. The only viable way is another wildcard mode, which would also ease use for the not so experienced user for whom regular expressions are too complicated. 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: [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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Wed Aug 3 20:08:49 -0700 2005 --- Eike, I did not quite understand your comment at first, because the strings I was using for the DSUM criteria were a string (substring) in a cell (reference to cell being a formula). I now see that you could not just go replacing them all because there is no way to know if they are just an * or ? or actual wildcards short of scanning the whole sheet to see if each is an input into a formula that handles wildcards which would not be so good logic and performance wise. I then wondered what would happen with a spreadsheet using wildcards was imported, but the user wanted to use regular expressions on that same sheet and still have the wildcards calculated. The obvious hangup with that is the ? and * do different things depending which option you want. A good answer to that would be for the functions like DSUM to have two implementations, one that calculates with regular expressions and one that calculates with wildcards. This would create yet another problem since DSUM used in calc is not the same as DSUM in excel, but the same formula name has been used by both excel and calc users, though this might be easy to take care of on import and export by translating DSUM in excel to something like DSUMWILDCARD in calc and something similar on export. This all assumes someone would actually want to use both wildcards and regular expressions on the same sheet, but that might be a bit crazy and I understand implementing the option you propose is probably far quicker, especially if you could have it coded in 2.0 or 2.0.1 instead of later versions. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Tue Aug 2 08:35:00 -0700 2005 --- I agree with drensink. Automatic translation is what the user needs and expects. Changing options that affect all workbooks, will cause more problems than it solves. If the user sees a warning that a regular expression could not be translated to Excel format, they will learn that Open Office is more powerful than Excel. Currently the inadequate translation gives the opposite impression, if the user has never heard of 'regular expressions'. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Sat Jul 30 17:13:09 -0700 2005 --- Instead of disabling regular expressions in the options when opening an excel document that uses wildcard characters or adding a wildcard option to the options, wouldn't it be easier to actually convert the ? and * wildcard characters to regular expressions on import and then convert the regular expressions back to wildcards when exporting back to excel formats, giving a warning for any regular expressions that cannot be converted exactly to wildcards. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Thu Jun 30 04:14:16 -0700 2005 --- *** Issue 51072 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Mon Apr 25 02:38:21 -0700 2005 --- The problem is Excel formulas that do not give the correct result in Open Office. When I open an Excel spreadsheet in Open Office, I need to either get the correct results or to get a message warning that some cells contain formulas that cannot be handled correctly. Open Office does neither. As an Excel user, I don't want to know about regular expressions - I just want Open Office to give the same answers as Excel. I also don't want to accidentally create Open Office formulas that will give the wrong results in Excel. If there is a radio button in Tools/Options to change the formula-handling method, I would expect that to be automatically set correctly to match the way that Excel works, whenever an Excel file is opened. Alternatively, when the troublesome formulas are detected, a warning box should open when the file is opened, preferably giving a quick way to make the necessary changes. - 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Sat Apr 23 10:21:42 -0700 2005 --- *** Issue 48020 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Tue Apr 5 06:00:41 -0700 2005 --- *** Issue 46706 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 32344] Simple wildcards * and ? as opposed to regular expressions
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] Thu Feb 10 11:20:00 -0800 2005 --- This issue has been proposed as a SO9 requirement. Please clarify what kinds of functions and parameters should be able to use wildcards. - 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]
