[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-04-13 Thread villeroy
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] Thu Apr 13 10:00:28 -0700 
2006 ---
quote
VLOOKUP([:digit:];range;1;0) still gives #NA, [...]
/quote
This single aspect relates to new issue 64368 (inconsistant named 
character-classes)
There is also a new evaluation-spreadsheet (less complicated ;)

-
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]



[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-04-13 Thread er
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63849


User er changed the following:

  What|Old value |New value

Status|NEW   |RESOLVED

Resolution|  |INVALID





--- Additional comments from [EMAIL PROTECTED] Thu Apr 13 10:51:27 -0700 
2006 ---
Wouldn't had been necessary to create a new issue for that, as I took this one
for the [:digit:] class problem, but so I'm closing this one here and take the
other one.

-
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]



[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-04-13 Thread er
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63849


User er changed the following:

  What|Old value |New value

Status|RESOLVED  |CLOSED





--- Additional comments from [EMAIL PROTECTED] Thu Apr 13 10:51:54 -0700 
2006 ---
Closing.

-
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]



[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-04-12 Thread fst
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63849


User fst changed the following:

  What|Old value |New value

   Assigned to|spreadsheet   |er

Ever confirmed|  |1

Status|UNCONFIRMED   |NEW

OS/Version|Unix, X11 |All

  Target milestone|---   |OOo 3.0





--- Additional comments from [EMAIL PROTECTED] Wed Apr 12 06:27:10 -0700 
2006 ---
Hi,

a bit complicate the document. As we've found out, the option for 'Search
criteria = and  must a0pply to whole cells' is set. This option under
tools-options-OpenOffice.org Calc-^calculate has also influences to regular
expressions. If you untag this option, most of the errors you seem to see will
be gone.

Eike,

this Issue is still open for the problem with the :digit: reg.exp. in the dcount
function.

Frank

-
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]



[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-04-12 Thread villeroy
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]



[sc-issues] [Issue 63849] Regex-support totally scr ewed up

2006-03-31 Thread villeroy
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] Fri Mar 31 03:23:30 -0800 
2006 ---
Created an attachment (id=35414)
regex analysis spreadsheet


-
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]