To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63849
------- Additional comments from [EMAIL PROTECTED] Wed Apr 12 12:42:49 -0700
2006 -------
Yes, complicated indeed. "Organically grown" from some numbers and a
filter-range.
Shame on me. I should have known about the setting you mentioned. I think this
has to be mentioned in the online-help about filtering. Each cell-function with
regex-support has a hint, leading to option "Enable Regexes in Formulae". This
option should mentioned as well >> documentation-issue.
With "Regex" and "Whole Cell" you can search for empty cells "<>.+", which
should be documented as well.
You are right. Now I get consistant results for filter, search and functions as
well.
Just let me mention another formula-error you might have overlooked:
The variant
VLOOKUP("[:digit:]";range;1;0) still gives #NA, unlike
VLOOKUP("[0-9]";range;1;0)
whereas "[:digit:].*" and other variants are consistant with their [0-9]
counterparts.
---------------------------------------------------------------------
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]
