[Issue 124957] regular expression for <= doesn't work as expected if string contains placeholders (.*)

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124957

mroe <mr...@gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|4.1.0                       |OOo 3.3 or older
            Summary|problem with BD instruction |regular expression for <=
                   |                            |doesn't work as expected if
                   |                            |string contains
                   |                            |placeholders (.*)

--- Comment #1 from mroe <mr...@gmx.net> ---
I can reproduce the behaviour but I don't know if there is a bug.
There is a logical problem with the expression.

Let X be a defined number or a defined string. Then it is valid:

(X < X) = FALSE
(X = X) = TRUE
(X > X) = FALSE

(Y < X) = NOT (Y = X) AND NOT (Y > X) = NOT ((Y = X) OR (Y > X))
(Y <= X) = (Y < X) OR (Y = X) = NOT (Y > X)

If NOT (Y > X) THEN (Y <= X)

But for the expression x.* and a defined string Xstring is defined

(Xstring < X.*) = FALSE
(Xstring = X.*) = TRUE
(Xstring > X.*) = TRUE

Now we have the logical problem that

(Xstring < X.*) OR (Xstring = X.*) = TRUE
BUT
NOT (Xstring > X.*) = FALSE


@reporter:
You can solve your problem using a separate OR condition:
Name    Name
>=b.*	<d.*
    =d.*
condition area: A9:B10

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.