Description: A merged area (A16:D19) is to be changed in color by conditional formatting. The conditions are trivial: threshold values 8 green, 10 yellow, 15 red. The condition is correctly implemented, but the color change is executed only for the first line (here A16:A19) instead of for the entire range A16:D19. Steps to Reproduce: 1.Merge some cells 2.type in a number 3.set up conditions for format with different colours Actual Results: colours will be changed for the first Line of cells only Expected Results: people usually expect that all the merged cells will be changed by cond. formatting Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 176279 [details] Screenshot of the incorrect formatting
Please attach a sample file to test.
Created attachment 176306 [details] Evaluation of gas- water- and electricity consumption by coloring The conditional formatting is located in the table 'Dashboard' over the cells A16:D19. In order to be able to test the formatting, a corresponding value for the current date is expected in each of the tables 'WATER_Data' 'GAS_Data' or 'CURRENT_Data'.
Seems CF it's not working fine. For row 16 A16:D16 applies the CF even B16:D16 are empty, but not for the other rows of the merged cells. Adding a formula like =a16 in A17:D19, applies the CF in B16:D16 and A17:A19, which not sound very consistent. You can work around, while the bug exist by filling A17:A19~B16:D19 with a formula =A16, and merging keeping the values in hidden cells.
*** This bug has been marked as a duplicate of bug 155322 ***