https://issues.apache.org/ooo/show_bug.cgi?id=124957
mroe <[email protected]> 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 <[email protected]> --- 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.
