https://bugs.documentfoundation.org/show_bug.cgi?id=172675
Bug ID: 172675
Summary: Conditional formatting breaks
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Stumbled upon a very interesting set of behavior with conditional formatting:
When having a conditional formatting range, having style names that share
values with the conditions themselves and having some text in common with each
other breaks most of the formatting you set.
For example, if we have 8 cases: very poor, poor, below average, average, above
average, excellent, superior; having styles named after the cases breaks the
formatting. In the example above, it is particularly below average, average,
and above average that break: They seem to jumble up the styles to use, and
reuse the same exact one.
It's fairly disruptive, in the sense that it isnt immediately obvious what is
causing the breakage to begin with.
Steps to Reproduce:
1. Select a range of rows and/or columns, enter sample case text/strings. Copy
it to other ranges.
2. Create a conditional formatting range, have every condition share exact
names with the styles
3. Create another conditional formatting range in the range copy you made, have
style names be unique from other styles AND unique from conditions checked.
Actual Results:
Mixes up style formatting with wrong text/string values.
Example: "Above Average" in one cell would have the appropriate formatting,
then have "Superior"'s formatting in another.
Expected Results:
Kept (style name) and (text value) separate, search entire text value instead
of parts.
Example: "Above Average" would have "Above Average"'s style in all cases, even
if sharing a name with string value and having the word "Average" in other
styles/cases.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Notes: Creating unique styles as opposed to having a hierarchy of styles does
NOT change anything.
--
You are receiving this mail because:
You are the assignee for the bug.
