https://bugs.documentfoundation.org/show_bug.cgi?id=152303
Bug ID: 152303
Summary: Conditional Formatting > Contains - doesn't work at
all.
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
While I'm able to correctly execute Conditional Formatting with "Cell Value" >
"is equal to" as expected, I'm struggling to get "contains" formatting.
same cell values > "contains" doesn't work at all.
problem is 'is equal to' needs whole cell value to be exact match, which is not
the case with my data, it only contains the data. so "contains" must work as
expected.
Steps to Reproduce:
1. Select a range of cells.
2. Conditional Formatting > "Cell Value" > "contains" > "enter a value"
2. Enter the same value "Dallas " in any given cell range.
3. Formatting doesn't work as expected.
Actual Results:
Conditional Formatting doesn't work as expected.
Expected Results:
Conditional Formatting MUST work as expected. It painful to have one function
working and other NOT.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
--
You are receiving this mail because:
You are the assignee for the bug.
