https://bugs.documentfoundation.org/show_bug.cgi?id=154076
Bug ID: 154076
Summary: Conditional formatting rules containing unquoted text
only apply to empty cells
Product: LibreOffice
Version: 7.5.0.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: UI
Assignee: [email protected]
Reporter: [email protected]
Description:
I created a new conditional formatting rule with the range `E1:E1000`, as an
example you can try "begins with" or "contains", and enter some text that you
know you have in the range. You can observe all non-empty cells be applied with
the rule, and not the ones matching your condition.
Putting double quotes around the text fixes this, but is not expected behavior
and is somewhat unintuitive. This is inherently bad UX design for fields that
are expected to contain text, like one would with something like "begins with".
Steps to Reproduce:
1. Create a conditional formatting rule for something that would expect text,
such as "begins with".
2. Apply the rule to a range you know contains the text
Actual Results:
Only empty cells have the condition applied.
Expected Results:
Parsed text input as text without quotations, as UX in a text field inherently
implies a non-number input.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: 50(Build:3)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
7.5.0-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
