https://bugs.documentfoundation.org/show_bug.cgi?id=122096
--- Comment #10 from ady <[email protected]> --- As of a recent LO Dev 24.2, IMHO the "Contains" conditional format is not working as expected, whether it is imported from xlsx, or in a new (ods) file. IMHO, the "Contains" type of condition should not require to use quotation marks in order to return TRUE for the condition on non-numeric values. (However, I am not sure whether changing this might have compatibility problems with older versions.) A condition such as 'Contains 1' should be evaluated independently of whether the value in the cell is text or number. If users want to restrict this to a specific type of value (e.g. either numeric values only, or text values only), they should add an additional condition. Currently, we have a somewhat-confusing situation. For example, starting from attachment 147527 (from comment 1), if the condition is modified (menu Format > Conditional > Manage > Edit) from: 'Contains "1,23"' to: 'Contains 1,23' (without the quotation marks around the value) it results in all empty cells being TRUE for the condition; this result is not intuitive, or even not understandable/logical at all (at least for users). -- You are receiving this mail because: You are the assignee for the bug.
