To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66023
User rbanfield changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jul 10 09:59:33 -0700
2006 -------
I have read that section of the help file & found this section on parentheses.
It does not however address the second part of this bug, invalid Regular
expresions.
>From Help file: ----
( )
Defines the characters inside the parentheses as a reference. You can then refer
to the first reference in the current expression with "\1", to the second
reference with "\2", and so on.
For example, if your text contains the number 13487889 and you search using the
regular expression (8)7\1\1, "8788" is found.
You can also use () to group terms, for example, "a(bc)?d" finds "ad" or "abcd".
---- End help file section.
In the above text, as in all regular expressions, parentheses must be balanced.
In the example below, they are not, and therefore should not be considered a
valid regular expression, and by that logic should be caught by the sum-if
function, and probably all other functions as well.
EG:
String three) - Not balanced, only 1 ), no opening
String (four - Not balanced, only 1 (, no closing
There are missing a parenthesis. I used these two online regular expression
validators (http://www.sweeting.org/mark/html/revalid.php or
http://www.miningtools.net/regextester.aspx) it shows them as invalid.
In which case, sumif should work for these two entries.
On reflection, this may not necessarily be a bug in just the sum-if function,
but in the dependant code that it uses to determine if a cell contains a regular
expression. In which case it would be a larger issue, in calc in general.
Re-opening because help content, as well as basic regular expressions require
balanced parentheses. Example above does not contain balanced parentheses, but
is recognised as a Regular Expression, as such, behaviour is incorrect, be is
SUM-IF function, or CALC in general.
---------------------------------------------------------------------
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]
