https://bugs.documentfoundation.org/show_bug.cgi?id=99808
--- Comment #5 from Theodore Matula Jr. <[email protected]> ---
Upon further testing, it seems that if a merged cell has "color scale"
condition formatting applied to it and then removed, a subsequent "conditional"
condition formatting work as intended.
Steps:
1. Open a new LibreOffice Calc spreadsheet.
2. Enter 1 in A1, 2 in B1
3. Highlight cells A1-A2 and right click on the cells and click merge cells
4. Highlight cells b1-B2 and right click on the cells and click merge cells
5. Highlight the two merged cells
6. From the Menu, click Format>Conditional Formatting>Color Scale
7. Keep the default and click ok to close the conditional formatting window.
8. From the Menu, click Format>Conditional Formatting>Manage. Select the newly
made entry and click remove, then ok
9. From the Menu, click Format>Conditional Formatting>Condition...
10. Click add. In the new window, set the condition to "Cell value is" "Not
equal to" "0"
11. From the drop down menu next to Apply Style, click New Style. Click the
background tab, choose any non-white color, and click OK.
12. Click OK to close the conditional formatting window.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
