https://bugs.documentfoundation.org/show_bug.cgi?id=158187
--- Comment #6 from ady <adylo811...@gmail.com> --- Regarding the "forced" merge of areas when the condition(s) and the conditional format are the same, there have been several reports complaining about the results. For instance, duplicating one worksheet with several separated conditions would result in merged conditionals, and users would claim that this is not the result they want – I would have to search for such reports as I don't recall them specifically, but I indeed remember them. Perhaps the merge should not be automatically triggered. Instead, the procedure could be: 1. Manage Conditional Format. 2. Select specific (rows of) conditions. 3. Press a button to attempt to merge the selected conditions. 3.1. If (some of) the selected conditions are equivalent, then merge their respective ranges, unifying those conditions into one (but there might be several groups of those, that are equal within each group but different between groups). Among the initially-selected conditions, unique conditions would be left unmerged. 3.2. The Manage Conditional Format dialogue shows the "first condition" on each row; "second/third/next/follow-up conditions" are not initially shown, but they should be considered for evaluation before merging (or not merging). 3.3. Within the Manage Conditional Format dialogue, Conditions (i.e. rows in the list) that are not selected for the manual merge are left alone, untouched. IOW, make the merge optional, _manually_ triggered by the user on selected conditions, instead of forcing the merge on any-and-all conditions according to some automatic action. -- You are receiving this mail because: You are the assignee for the bug.
