[sc-issues] [Issue 32344] Simple wildcards * and ? a s 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 User cornouws changed the following: What|Old value |New value CC|'kpalagin,navvy,swubuntu' |'cornouws,kpalagin,navvy,s | |wubuntu' - 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 32344] Simple wildcards * and ? a s 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 e...@openoffice.org Mon Jul 19 12:46:53 + 2010 --- *** Issue 101712 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: 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 32344] Simple wildcards * and ? a s 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 e...@openoffice.org Mon Jul 19 12:49:57 + 2010 --- *** Issue 113243 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: 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 32344] Simple wildcards * and ? a s 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 e...@openoffice.org Tue Jul 28 11:43:51 + 2009 --- *** Issue 102843 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: 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 32344] Simple wildcards * and ? a s 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 User sweigel changed the following: What|Old value |New value OtherIssuesDependingOnTh| |15522 is| | - 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 32344] Simple wildcards * and ? a s 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 Nov 28 16:47:05 + 2008 --- *** Issue 96557 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 ? a s 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 Oct 26 03:03:42 + 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]
[sc-issues] [Issue 32344] Simple wildcards * and ? a s 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 Mar 17 13:44:44 + 2008 --- *** Issue 87106 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 ? a s 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 User swubuntu changed the following: What|Old value |New value CC|'kpalagin,navvy' |'kpalagin,navvy,swubuntu' - 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 ? a s 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 Jan 11 21:59:26 + 2008 --- Text comparison in Calc occurs in 1. Formulas by operator =A1=B1 2. Functions like MATCH etc. 3. Filters 4. Find/Replace It is influenced by following options: - CalcCalculationCase sensitive (affects 1. only) - CalcCalculationSearch criteria = and must apply to whole cells (affects 2. and 3.) - Enable regular expressions in formulas (affects 2. only, but not 1.) Better labeled Enable regular expressions in function arguments? Filters, SortDescriptors and Find/Replace have their own options for regex and case. There are too many options and implications. The behaviour is inconsistent. For instance: Did anybody notice that case-insensitive cell values obsoletes many benefits of regular expressions? My radical proposal: One option to toggle between native mode and compatibility mode. Native mode: All strings in Calc are case sensitive and support regular expressions, = and do not apply to whole cells unless you use them with ^ and $. Compatibility mode: Excel files are loaded in compatibility mode: All strings are case-insensitive except for EXACT and FIND. They support wildcards. = and apply to whole cells. - 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 ? a s 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 User kpalagin changed the following: What|Old value |New value CC|'navvy' |'kpalagin,navvy' - 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 ? a s 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 13 16:06:09 + 2007 --- Just an overdue update: the OASIS ODF TC approved the proposal to include a table:use-wildcards attribute in the file format, see Proposal for a new calculation setting: table:use-wildcards under http://wiki.oasis-open.org/office/OpenDocument_v1%2e2_Action_Items#head-4854119a1f3d7df4f22fc453bb50e8c6e5b0acd7 - 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]
