https://bugs.freedesktop.org/show_bug.cgi?id=59109
Priority: medium
Bug ID: 59109
Assignee: [email protected]
Summary: FORMATTING: Conditional Formatting not limited to a
selected range that is a subset of range that already
has a rule.
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.2.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description: When trying to set a conditional formatting rule to a
range that is a subset of a range which already has a rule, the second rule
applies to the larger range of the first rule, not the smaller selection.
Steps to reproduce:
1. Set up a range, e.g. B3:B9 with values, e.g. 1 in each cell.
2. Select B3:D9, create a conditional formatting rule (e.g. value = 1) with one
style.
3. Select C3:D9, select Conditional Formatting > Conditional Formatting.
Current behavior: The Conditional Formatting dialog box applies to the larger
range of the first rule (B3:D9), not the smaller range currently selected
(C3:D9). A rule created in this box (e.g. value > 0) is applied to that larger
range, not the smaller range selected.
Expected behavior: You should be able to create a conditional formatting rule
that applies to the smaller range selected.
More generally, you should be able to create a conditional formatting rule that
applies to a selected range, and only to that selected range, independently of
any rules that apply to different ranges, even if there is overlap of the
ranges.
Operating System: Ubuntu
Version: 3.6.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
