To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=45426
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'fst'
--------------------------------------------------------------------------------
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
OS/Version|Windows XP |All
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Apr 11 03:37:15 -0700
2005 -------
It's not a bug, it's a feature ;-)
This one is a bit tricky and you have to know how regular expressions work. The
expression "4|40" used to search for "40" already matches with "4". The match
returned is only a substring of the cell, but under Tools.Options.Calc.Calculate
the option "Search criteria = and <> must apply to whole cells" is activated,
which also controls regular expresions, and the "4" does not match the entire
cell's content "40".
There are two possibilities how this can be solved: either switch off the option
and formulate the expressions such that they have to match entire strings by
anchoring the expression, e.g. "^(4|40)$" for the example above, or, as that
might not be wanted for an entire document, leave the option as is and formulate
the expression such that the alternatives are sorted descending on string
length, in the example above it would be "40|4", in the document's example cell
it would be "40|33|29|16|6|4".
Eike
---------------------------------------------------------------------
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]
