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 Oct 26 03:03:42 +0000 2008 ------- I was working with an xls file and discovered this problem. From a users perspective, wouldn't it be simpler to simply have a message stating that OOo is trying to open a file that contains regular expressions/wild cards and asks whether the user wants to enable the regular expression option? i'm not sure about more complex formulas but it seems that there is no problem with OOo understanding and translating into excel's way of handling things, so long as the option is turned on. i would think therefore that simply letting the user know that the option has to be turned on because there are regular expressions in the formula would be good enough, so that the user doesn't get shocked to see all zeros in the cells as I did. I mean if there isn't any technical problem as regards OOo translating and understanding the way other spreadsheet applications handle formulas (OOo can open and save either way), then there's really no need to replace and auto translate formulas. if all the user needs to do to work with the spreadsheet (whichever format) and to save it (in whichever format as well) is to turn the option on or off, then so be it. a simple prompt like: "The spreadsheet file you are trying to open may contain regular expression. Do you want to turn these feature on?" or something... --------------------------------------------------------------------- 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]