To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90920 Issue #|90920 Summary|the regular expression '^$' doesn't work in search&rep |lace, nor in standard filter Component|Spreadsheet Version|OOo 2.4.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|oopla
------- Additional comments from [EMAIL PROTECTED] Fri Jun 20 11:50:33 +0000 2008 ------- I want to search for void cells and put 'X' in, so at first I'd use search&replace, but I've found 2 problems here: 1. replace( all) is greyed-out till something is written in 'serach' box. This is wrong,in IMHO, as a search for the NULL string (ie void cells here) isn't that exotic. 2. as a workaround, I tried RE, expecting '^$' to do the trick, but nope "search term not found". As a dumb test, I also tried '.*' which would match all and everything, but nope again - it matched cells with 1+ chars only; that is, '.*' behaves like '.+'. Same for .?. Likewise in 'standard filer' - true we have predefined '- void -' but when doing with RE ^$ (and others eg above) should work as expected nevertheless. If this is the _intended_ behaviour (and I can see the point), then it should be clearly stated (eg "void cells are skipped" | "match is only tried on non-void cells") in the help, since it's not the _expected_ (from RE usage) behaviour. thanks --------------------------------------------------------------------- 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]
