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]