https://bugs.documentfoundation.org/show_bug.cgi?id=155157
--- Comment #2 from m.a.riosv <[email protected]> --- Created attachment 187118 --> https://bugs.documentfoundation.org/attachment.cgi?id=187118&action=edit Sample file Please, @David answer here, not sending private messages. " The problem lies in the copying/duplicating of tabs in a spreadsheet. When a tab is copied, the conditional rules are combined if the cells on the left half of the equation fall within a range of each other. Even though the right side of the rule equation is not the same, the conditional statements are still combined upon a tab copy/duplication. Here's how you can test the situation: 1. In the sample spreadsheet, notice the tab titles "sample sheet, base sheet" 2. Inspect the conditional rule set. Menu sequence: Format > Conditional > Manage. Notice the rule set and its values on the left/right side of the individual rules. 3. Copy the Tab to another tab. 4. Inspection the conditional rule set of the new Tab. Notice the differences. The rules are combined if the cells that are within the rule set are within a range even though the condition is not the same. Hence, the bug. " I hope I have explained this properly. First time I have ever done something like this. Not sure if this is detailed enough for what you need. Please feel free to contact me again if you need some other information regarding this matter. -- You are receiving this mail because: You are the assignee for the bug.
