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] Sun Jun 4 10:44:00 -0700
2006 -------
Is this a defect by design, or an unplanned consequence of two different
features interacting?
The reason I ask defect by design is that if someone was to evaluate OpenOffice
"out of the box" as a replacement for Excel "out of the box", and one of there
criteria happened to be the SUMIF function - This has just failed it. Also this
prevents the use of both SUMIF & Regular Expressions in the same session.
When someone is viewing the sheet, they can quite clearly see that the values
match, however, as pointed out, you need to turn off an advanced feature (enable
regular expressions) for it to work properly. Some pop-up of note in the formula
editor should warn re: regular expressions.
Also, How are these valid regular expressions:
String three)
String (four
There are mising parenthesis and when using thess two 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.
---------------------------------------------------------------------
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]
